You want to display the date for the first Monday of the next month and issue the following command:What is the outcome?
View the Exhibit and examine the structure of the promotions table.You need to generate a report of all promos from the promotions table based on the following conditions:1. The promo name should not begin with 'T' or 'N'.2. The promo should cost more than $20000.3. The promo should have ended after 1st January 2001.Which where clause would give the required result?
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?
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 result?
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?
Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?
