Tag Archives: table

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 »

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE. You

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day on the wee.Which query can be used? A. 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 »

Which three statements are true about table data storage in an Oracle Database? (Choose three.)

Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… 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 »

You want to use table compression suitable for OLTP that will: 1. Compress rows for all DML statements

You want to use table compression suitable for OLTP that will:1. Compress rows for all DML statements on that table2. Minimize the overheads associated with compressionWhich compression option is best suited for this? A. COLUMN STORE COMPRESS FOR QUERY LOW B. ROW STORE COMPRESS BASIC C. COLUMN STORE COMPRESS FOR ARCHIVE LOW D. COLUMN STORE COMPRESS FOR ARCHIVE… 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 »