SQL |
Level:-Basic
|
Q(1) |
Count function in SQL returns the number of ________. |
A | Values |
B | Distinct values |
C | Groups |
D | Columns |
Q(2) |
Which of the following is TRUE for the System Variable $date$? |
A | Can be assigned to a global variable. |
B | Can be assigned to any field only during design time. |
C | Can be assigned to any variable or field during run time. |
D | All of the above |
Level:-Intermediate
|
Q(1) |
_______ are the different events in Trigger. |
A | Define, Create |
B | Drop, Comment |
C | Insert, Update, Delete |
D | Select, Commit |
Q(2) |
Composite key is made up of two or more columns. |
A | True |
B | False |
Level:-Expert
|
Q(1) |
_______ clause is an additional filter that is applied to the result. |
A | Select |
B | Group-by |
C | Having |
D | Order by |
Q(2) |
A candidate key is a minimal super key.
|
A | True |
B | False |