Bissoy.com
Doctors Medicines MCQs Q&A

Which of the following syntax is correct way to declare a variable in PL/SQL? ; b) variable_name datatype ; c) variable_name datatype; d) variable_name datatype (NOT NULL := value );

Which of the following syntax is correct way to declare a variable in PL/SQL? ; b) variable_name datatype ; c) variable_name datatype; d) variable_name datatype (NOT NULL := value ); Correct Answer NOT NULL := value

Related Questions

Consider two relations R1(A, B) with the tuples (1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A, B, C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a = (1, 5, null), b = (1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?
Consider the following statements in connection with deflection-type and null-type instruments: 1. Null-type instruments are more accurate than the deflection-type ones. 2. Null-type of instrument can be highly sensitive compared to a deflection-type instrument. 3. Under dynamic conditions, null-type instruments are less preferred to deflection-type instruments. 4. Response is faster in null-type instruments as compared to deflection-type instruments. Which of the above statements are correct?
Consider the following statements for deflection and null type instruments: 1. Deflection type of instruments are more accurate than null type of instruments. 2. Deflection type of instruments can be highly sensitive as compared with the null type of instruments. 3. Null type of instruments are more suitable for measurements under dynamic conditions than deflection type of instruments. Which of the above statements are not correct?
Consider the below given syntax book[datatype]=assignment_value; In the above syntax, the datatype within the square brackets must be
Point out the error (if any) in the following C code?
#include #include int main(void){ int* p = NULL; struct S *s = NULL; void(*f)(int, double) = NULL; char *ptr = malloc(15); if (ptr == NULL) printf("Out of memory"); free(ptr);}
The height of a tree is defined as the number of edges on the longest path in the tree. The function shown in the pseudocode below is invoked as height(root) to compute the height of a binary tree rooted at the tree pointer root. int height (treeptr n) { if (n == NULL) return -1;   if (n →  left == NULL)        if (n →  right == NULL) return 0;        else return ; \(\boxed{B1}\);     // Box 1 else { h1 = height (n →  left);          if (n → right == NULL) return (1+h1);          else { h2 = height (n → right);          return ; \(\boxed{B2}\)   // Box 2                        }            } } The appropriate expressions for the two boxes B1 and B2 are
Consider the pseudocode given below. The function DoSomething() takes as argument a pointer to the root of an arbitrary tree represented by the leftMostChild-rightSibling representation. Each node of the tree is of type treeNode. typedef struct treeNode* treeptr; struct treeNode {              treeptr leftMostChild, rightSibling; }; int DoSomething (treeptr tree) {              int value=0;              if (tree != NULL) {              if (tree->leftMostChild == NULL)              value = 1;    else               value = DoSomething(tree->leftMostChild);               value = value + DoSomething(tree->rightSibling);     }               return(value); } When the pointer to the root of a tree is passed as the argument to DoSomething, the value returned by the function corresponds to the 
Directions : In each of the following questions a statement is given, followed by two conclusions. Give answer :

Statements : The Government run company had asked its employees to declare their income and assets but it has been strongly resisted by employees union and no employee is going to declare his income.

Conclusions :
I. The employees of this company do not seem to have any additional undisclosed income besides their salary.
II. The employees union wants all senior officers to declare their income first.
Read the statement and select a conclusion from the given alternatives. Statement : Company 'X' had asked its employees to declare income and assets but it has strongly opposed by the employees' his/her union and no employee is going to declare his/her income. Conclusions : I. The employees of the company 'X' do not seem to have any additional income besides their salary. II. The employees' union want all the senior officer to declare their income first.
When a particular ‘statistics’ in a research situation is evidently declared to be significant, which of the following decisions will be considered tenable ? A. Null hypothesis is rejected B. Alternative hypothesis is accepted C. Null hypothesis is accepted D. Alternative hypothesis is rejected E. Null hypothesis along with the alternate hypothesis are accepted. Choose the correct answer from the options given below: