DBMS 6

(Applying) Write a SQL statement to create a table called "orders" with a primary key on the "order_id" column and a foreign key on the "customer_id" column, referencing the "customers" table.

• CREATE TABLE orders (order_id INT PRIMARY KEY, customer_id INT, FOREIGN KEY (customer_id) REFERENCES customers(customer_id));
• CREATE TABLE orders (order_id INT, customer_id INT PRIMARY KEY, FOREIGN KEY (customer_id) REFERENCES customers(customer_id));
• CREATE TABLE orders (order_id INT PRIMARY KEY, customer_id INT, FOREIGN KEY (order_id) REFERENCES customers(customer_id));
• CREATE TABLE orders (order_id INT, customer_id INT, PRIMARY KEY (order_id), FOREIGN KEY (customer_id) REFERENCES customers(customer_id));

Applying a ____________ function to a column in a SELECT statement calculates the average value of that column.

• COUNT
• AVG
• MAX
• MIN

Which of the following SQL commands is used to remove a table from the database?

• DROP TABLE
• DELETE FROM
• REMOVE TABLE
• ERASE TABLE

The _______ clause is used to eliminate duplicate records from a result set.

• DISTINCT
• REDUCE
• SORT
• GROUP

The _______ operator can be used to combine two or more SELECT statements into a single result set.

• AND
• OR
• UNION
• INTERSECT