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 »

In which three situations does a new transaction always start? (Choose three.)

In which three situations does a new transaction always start? (Choose three.) A. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session B. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session C. when issuing the first Data Manipulation Language… Read More »

Evaluate these commands which execute successfully: (Exhibit) Which two statements are true about the

Evaluate these commands which execute successfully:Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?(Choose two.) A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ B. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row… Read More »