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

#Newsletter

Join the community of BrightBrains^TM

A Product that bridges the Academia-to-Industry gap, helps as a Self Assessment tool for competency checks, and assists in candidates filtering in the Software Industry.

SITEMAP

INFORMATION

CONTACT US

+91 265 2324495

2nd Floor, Sakar Complex, Opp. ABS Tower, Malhar Point, Old Padra Road Vadodara-390007 Gujarat

support@brightbrains.in

SQL

Join the community of BrightBrainsTM

SITEMAP

INFORMATION

CONTACT US

Join the community of BrightBrains^TM