Tag Archives: rows

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 »

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 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 »

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

You want to use table compression suitable for OLTP that will:Compress rows for all DML statements on that tableMinimize 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 HIGH E.… Read More »

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

You want to use table compression suitable for OLTP that will:* Compress rows for all DML statements on that table* Minimize the overheads associated with compressionWhich compression option is best suited for this? A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH B. ROW STORE COMPRESS ADVANCED C. ROW STORE COMPRESS BASIC D. COLUMN STORE COMPRESS FOR QUERY LOW E.… Read More »