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.) 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 »
Which three statements are true regarding indexes? (Choose three.) A. A SELECT statement can access one or more indices without accessing any tables B. A table belonging to one user can have an index that belongs to a different user C. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that… Read More »
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 »
Which two statements are true about the DUAL table? (Choose two.) A. It can be accessed only by the SYS user B. It consists of a single row and single column of VARCHAR2 data type C. It can display multiple rows but only a single column D. It can be used to display only constants or pseudo columns… Read More »
A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the PGA C. in the SYSAUX tablespace D. in the SGA E. in the temporary tablespace Correct Answer: A
View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.Examine this SQL statement:Exhibit 1.Exhibit 2.What will be the result? A. It gives an error because the ALL keyword is not valid B. It executes successfully but… Read More »
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE ‘/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. It must be smaller than the smallest BIGFILE tablespace B. Free space is managed using freelists C. Any data files added to the tablespace must have a size… Read More »
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 »