SQL Quiz 11 Copy

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(s)

FROM table_name

WHERE EXISTS

(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.