Online Access Free A2090-614 Exam Questions

What contributes to the efficient use of block-based buffer pools?

• A.The table space prefetch size is equal to the block size specified for the buffer pool.
• B.The application does not use sequential prefetching.
• C.The application performs a lot of random I/O operations.
• D.The table space extent size is equal to the block size specified for the buffer pool.

If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

• A.There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
• B.Statements generating audit records must wait for the records to be written to disk before they can complete execution.
• C.The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
• D.The audit facility writes records to disk at the same time the statements generating the audit records are executing.

Where is the HADR_TARGET_LIST configuration parameter set?

• A.On the tertiary standby databases.
• B.On all participating databases.
• C.On the primary database only.
• D.On the auxiliary standby databases only.

A table named SALES was created as follows:

Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?

• A.ALTER TABLE sales ATTACH PARTITION part_2013q1
  STARTING ('01/01/2013') ENDING ('03/31/2013')
  FROM TABLE q12013_sales;
• B.ALTER TABLE sales ADD PARTITION part_2013q1
  STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
• C.ALTER TABLE sales ADD PARTITION part_2013q1
  STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;
  SET INTEGRITY FOR sales IMMEDIATE CHECKED;
• D.ALTER TABLE sales ATTACH PARTITION part_2013q1
  STARTING ('01/01/2013') ENDING ('03/31/2013')
  FROM TABLE q12013_sales;
  SET INTEGRITY FOR sales IMMEDIATE CHECKED;

A table named MYTAB was created as follows:

How many rows will be inserted into the MYTAB table?

• A.8
• B.12
• C.11
• D.4