Which query can be used to copy all records from table1 into table2 provided they have the same columns?

Which of the following operators can be used to check if a column contains NULL value?

Which of the following commands is used to explain access to data?

For a table with the following columns:

product_id, product_name, supplier_id, price

Which of the following queries will give you the supplier with the maximum average price of products?

To create a column in a table with a fixed length(n) string, which of the following data type is recommended?

Which of the following clauses can be included in SELECT to fetch 10 records only? (Check all that apply)

Which of the following KEYWORDS will return the first NON-NULL value from a list of columns?

Which of the following types of triggers can be used with a view?

What is a collation?

How many clustered indexes can a table have?

Which of these is not a valid constraint?