Examine the structure of the MEMBERS table: (Choose the best answer) Examine the SQL statement: SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution? A. It displays all cities in…
Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction B. Each Data Definition Language (DDL) statement executed forms a single transaction. C.…
See the Exhibit and examine the structure of the PROMOTIONS table: Using the PROMOTIONS table, you need to find out the average cost for all promos in the range $0-2000 and $2000-5000 in category A You issue the following SQL…
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table. Similarly, the CUST_ID and TIME_ID columns are also foreign…
View the exhibit and examine the description of the PRODUCT_INFORMATION table. Which SQL statement would retrieve from the table the number of products having LIST_PRICE as NULL? A. SELECT COUNT (DISTINCT list_price) FROM product_information WHERE list_price is NULL B. SELECT…
View the exhibit and examine the structure of the STORES table. You want to display the NAME of the store along with the ADDRESS, START_DATE, PROPERTY_PRICE, and the projected property price, which is 115% of property price. The stores displayed…
Which three statements are true regarding group functions? (Choose three,) A. They can be used on columns or expressions. B. They can be passed as an argument to another group function. C. They can be used only with a SQL…
You issued this command: CHOOSETHREE SQL > DROP TABLE employees; Which three statements are true? A. Sequences used in the EMPLOYEES table become invalid. B. If there is an uncommitted transaction in the session, it is committed. C. All indexes…
Which three statements are true regarding subqueries? (Choose three.) A. The ORDER BY Clause can be used in a subquery. B. A subquery can be used in the FROM clause of a SELECT statement. C. If a subquery returns NULL,…
Evaluate the following CRTEATE TABLE commands: The above command fails when executed. What could be the reason? A. SYSDATE cannot be used with the CHECK constraint. B. The BETWEEN clause cannot be used for the CHECK constraint. C. The CHECK…