Tag Archives: description

Examine the description of the SALES1 table: (Exhibit) SALES2 is a table with the same description as

Examine the description of the SALES1 table:SALES2 is a table with the same description as SALES1.Some sales data is duplicated in both tables.You want to display the rows from the SALES1 table which are not present in the SALES2 table.Which set operator generates the required output? A. UNION ALL B. MINUS C. INTERSECT D. UNION E. SUBTRACT Correct… Read More »

Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements execute successfully?

Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. ‘DUES AMOUNT’ FROM transactions; B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. “DUES” FROM transactions;SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 D. transactions;SELECT… Read More »

Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this sequence of

Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.) A. The first ROLLBACK command restores the 101 rows that were… Read More »

Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this sequence of

Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a; DELETE FROM books; ROLLBACK TO SAVEPOINT a; ROLLBACK; Which two statements are true? (Choose two.) A. The second ROLLBACK command undoes the insert B. The first… Read More »

Examine this description of the TRANSACTIONS table: (Exhibit) Which two SQL statements execute successfully?

Examine this description of the TRANSACTIONS table:Which two SQL statements execute successfully? (Choose two.)SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 A. DUES FROM transactions;SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + B. 100 “DUES AMOUNT” FROM transactions;SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM C. transactions;SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE,… Read More »

Examine the description of the BOOKS table: (Exhibit) The table has 100 rows. Examine this sequence of

Examine the description of the BOOKS table:The table has 100 rows.Examine this sequence of statements issued in a new session:INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL,NULL);SAVEPOINT a;DELETE FROM books;ROLLBACK TO SAVEPOINT a;ROLLBACK;Which two statements are true? (Choose two.) A. The second ROLLBACK command replays the delete B. The second ROLLBACK command undoes the insert C.… Read More »

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT FROM customers WHERE cust_income_level <> NULL… Read More »

Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?

Examine the description of the EMPLOYEES table:Which query is valid? A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date; B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id; C. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id; D. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id; Correct Answer: B

Examine the description of the CUSTOMERS table: (Exhibit) For customers whose income level has a value,

Examine the description of the CUSTOMERS table:For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.Which query should be used? A. SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNTFROM customersWHERE cust_income_level <> NULLAND due_amount <>… Read More »

Examine the description of the EMPLOYEES table: (Exhibit) Which query is valid?

Examine the description of the EMPLOYEES table:Which query is valid? A. SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id; B. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date; C. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id; D. SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id; Correct Answer: B