Q. Which keyword used with UNION retains duplicate rows?

View solution

Q. The UNION ALL has a higher precedence than UNION DISTINCT.

View solution

Q. Which clause is used to sort a UNION result as a whole?

View solution

Q. Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

View solution

Q. Which table is used to run a UNION-type query on MyISAM tables?

View solution

Q. SELECT on a MERGE table is like _____________

View solution

Q. Which of these is also known as a virtual table?

View solution

Q. A View can be used to select a subset of the table columns.

View solution

Q. A view can refer to multiple tables via __________

View solution

Q. Views are not updatable.

View solution

Q. A view can be deleted using the command __________

View solution

Q. What cannot be done on a view?

View solution

Q. What can be used to check for views that have been invalidated by DROP or ALTER operations?

View solution

Q. Which of the following does not support a materialized view?

View solution

Q. To perform a delete on a single-table, how is the name of a column qualified?

View solution

Q. A multiple-table delete can apply any join.

View solution

Q. Qualifying the name of column with the table name is not necessary in single-table updates.

View solution

Q. UPDATE statement is a DML statement. What does DML stand for?

View solution

Q. Which keyword in the UPDATE statement is used to assign values to columns?

View solution

Q. Which keyword is used to delete all the rows from the table?

View solution