Down to date 1z0-052 Exam Study Guides With New Update Exam Questions

Q3. Identify two situations in which the block header grows in a data block. (Choose two.)

A. When row directories need more row entries

B. When there is row migration in the data block

C. When there is an increase in the PCTFREE value for the data block

D. When more transaction slots are required than are initially configured

View Answer

Q4. Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

A. The SGA advisor will be disabled

B. The MTTR advisor will be disabled

C. Automatic checkpoint tuning will be disabled

D. Checkpoint information will not be written to the alert log file

View Answer

Q5. You executed the following command to perform a backup of the USERS tablespace:

SQL> ALTER TABLESPACE users BEGIN BACKUP; ALTER TABLESPACE users BEGIN BACKUP

*

ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error?

A. The MTTR Advisor is disabled.

B. The database is in NOARCHIVELOG mode.

C. The tablespace is already in backup mode.

D. The Flash Recovery Area is not configured.

View Answer

Q6. Which two statements are true regarding a tablespace? (Choose two.)

A. It can span multiple databases

B. It can consist of multiple data files

C. It can contain blocks of different files

D. It can contains segments of different sizes

E. It can contains a part of nonpartitioned segment

View Answer

Q7. You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

A. No flashback is possible to bring back the ITEM table.

B. The ORDERS table is dropped along with the ITEM table.

C. The dependent referential integrity constraints in the ORDERS table are disabled.

D. The dependent referential integrity constraints in the ORDERS table are removed.

E. The table definition of the ITEM table and associated indexes are placed in the recycle bin.

View Answer

Q8. Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');

Which statement describes the effect of the above command?

A. Automatic statistics collection is stopped for the CUSTOMERS table

B. Statistics for the CUSTOMERS table are locked and cannot be overwritten

C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer

D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

View Answer

Q9. Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

A. It is the time period after which the undo data becomes obsolete.

B. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

C. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

D. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

View Answer

Q10. Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?

A. Run the root.sh script.

B. Create the oraInst.loc file.

C. Create the tnsnames.ora file.

D. Run the oraInstRoot.sh script.

View Answer