Q. Which keyword used with UNION does not retain duplicate rows?

View solution

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