www.brightbrains.in

About Us/Home              Tests On Offer              Sample Questions              FAQ              Contact US

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
BACK      REGISTER NOW
About Us/Home   Terms & Conditions   Cookies Policy   Privacy Policy   FAQ   Contact Us  
   © Copyright 2017 BrightBrains