Evaluate the following SQL statement: Which statement is true regarding the above query if one of the values generated by the subquery is null? A. It produces an error. B. It executes but returns no rows. C. It generates output…
Using the customers table, you need to generate a report that shows 50% of each credit amount in each income level. The report should NOT show any repeated credit amounts in each income level. Which query would give the required…
You issue the following command to drop the products table: SQL> DROP TABLE products; Which three statements are true about the implication of this command? A. All data along with the table structure is deleted. B. A pending transaction in…
Examine the structure of the employees table. You want to display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would get the correct output? A. Option A B. Option B C. Option C D.…
You want to display the date for the first Monday of the next month and issue the following command: What is the outcome? A. It executes successfully and returns the correct result. B. It executes successfully but does not return…
Which create table statement is valid? A. Option A B. Option B C. Option C D. Option D
Which two statements are true regarding constraints? A. A table can have only one primary key and one foreign key. B. A table can have only one primary key but multiple foreign keys. C. Only the primary key can be…
In which three situations does a transaction complete? A. When a DELETE statement is executed B. When a ROLLBACK command is executed C. When a PL/SQL anonymous block is executed D. When a data definition language (DDL) statement is executed…
Examine the structure of the orders table: You want to find the total value of all the orders for each year and issue the following command: Which statement is true regarding the outcome? A. It executes successfully and gives the…
Examine the data in the PROMO_BEGIN_DATE column of the promotions table: You want to display the number of promotions started in 1999 and 2000. Which query gives the correct output? A. Option A B. Option B C. Option C D.…