0 of 15 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 15 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Which of the following is true about subquery?
Select NAME, LOCATION, PHONE_NUMBER from DATABASE WHERE ROLL_NO IN (SELECT ROLL_NO from STUDENT where SECTION=’A’);
What does the above code execute?
Subquery is also called as
Subqueries can be used with the SELECT, INSERT, UPDATE, and DELETE statements along with the operators like =, <, >, >=, <=, IN, BETWEEN, etc
Which of the following are correct?
(SELECT column_name FROM table_name WHERE condition);
the correct way to use the key word EXISTS?
Functions and procedure have same functionality
Which of the following is true about procedures?
Parameterized procedures can be used to retrieve data from the table using certain parameter as an input to where clause or the entire query.
What is transaction in SQL?
Which of the following are the properties of a transaction?
Which of the following fall under transaction control language?
Sequences are used for
Which of the following is true?
Auto increment allows a unique number to be generated automatically when a new record is added in the table.