Bright Brains
PRODUCT OVERVIEW PRODUCT PHILOSOPHY TESTS ON OFFER SAMPLE QUESTIONS FAQ'S CONTACT US LOGIN/REGISTER

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