Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?
INTERSECT

.No user-defined locks are used in your database.
Which three are true about Transaction Control Language (TCL)?

Evaluate the following query

What is the correct output of the above query?

Examine the structure of the MEMBERStable.

Which query can be used to display the last names and city names only for members from the states MO and MI?
SELECT last_name, city FROM members WHERE state ='MO' AND state ='MI';

Evaluate the following CREATE TABLE command:

Which statement is true regarding the above SQL statement?