About Us/Home Tests On Offer Sample Questions FAQ Why BrightBrains? 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 |
