摘要:
Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space 阅读全文
摘要:
Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/ 阅读全文
摘要:
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backu 阅读全文
摘要:
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level? 阅读全文
摘要:
You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable 阅读全文
摘要:
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You alsohave a table named MY_TABLE in your schema. You execute t 阅读全文
摘要:
You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?A. The BZIP2 compression 阅读全文
摘要:
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are bac 阅读全文
摘要:
You enable block change tracking. You issue the following command:BACKUP INCREMENTAL LEVEL 0 DATABASE;The next day, you issue the following command:BA 阅读全文
摘要:
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transfer 阅读全文
摘要:
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is p 阅读全文
摘要:
Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?A. a cumulative level 1 backupB. a different 阅读全文
摘要:
Which statement about using RMAN stored scripts is true?A. To create and execute an RMAN stored script, you must use a recovery catalog.B. When execut 阅读全文
摘要:
You have enabled resumable space allocation in your database by setting theRESUMABLE_TIMEOUT parameter set to a nonzero value.Which three statements a 阅读全文
摘要:
Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear 阅读全文
摘要:
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the databa 阅读全文
摘要:
You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when youperform tape backups. Which action should you take?A. Set th 阅读全文
摘要:
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance.To what value will the 阅读全文
摘要:
You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set thePGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You r 阅读全文
摘要:
Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?A. A 阅读全文