1.

In SQL, what are the left and right joins collectively known as?

2.

In SQL, which of the following is used to check for views that have been invalidated by DROP or ALTER operations?

3.
In SQL, which of the following operators is used when a subquery returns multiple rows that get evaluated in comparison to the outer query?
4.

In SQL, which of the following operators does not perform relative-value comparisons?

5.
Which of the following SQL queries is correct?
6.

In MySQL, which of the following is displayed when a FOREIGN KEY constraint is encountered while executing the DELETE command?

7.
In MySQL, which of the following statements defines a candidate key?
8.
In MySQL, ORDER BY clause is used to sort the result-set in _____________________________ order, by default.
9.
In MySQL, which of the following commands is used to find the number of records in a table?
10.
In MySQL, which of the following commands is used to display the current date?