You&ensp;are&ensp;maintaining&ensp;the...

单项选择题 You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.
Which parameter should you specify to control the speed of the rebalancing activity？（）

A. ASM_POWER_LIMIT
B. ASM_DISKSTRING
C. ASM_DISKGROUPS
D. INSTANCE_TYPE

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 Evaluate the following command：
SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）
LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；
Which statement is true regarding the above command？（）

A. The LOB values are automatically compressed.
B. The LOB values are cached by default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

点击查看答案

2.单项选择题 The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below：
LOG_ARCHIVE_DEST_1 = ’LOCATION = /disk1/archive’ LOG_ARCHIVE_DEST_2 = ’SERVICE = stdb1’ DB_RECOVERY_FILE_DEST = ’/u01/oradata’
Examine the following RMAN command issued to set the deletion policy for archived log files：
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt；
Which statement is true regarding what this command accomplishes？（）

A. All archived redo log files backed up at least twice to tape are deleted.
B. All archived redo log files backed up at least once to tape are eligible for deletion.
C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

点击查看答案

3.单项选择题 Consider the following scenario for your database:
- Backup optimization is enabled in RMAN.
- The recovery window is set to 7 days in RMAN.
- The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
- The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?（）

A. The RMAN backup fails because the TOOLS tablespace is read-only
B. The RMAN skips the backup of the tablespace because backup optimization is enabled
C. The RMAN makes backup because optimization can be enabled only for backups to disk
D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

点击查看答案

4.单项选择题You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）

A. A base catalog exists
B. The recovery catalog is empty
C. The base recovery catalog must be dropped
D. A target database is registered in the recovery catalog

点击查看答案

5.单项选择题 Evaluate the following SQL statement used to create the PRODUCTS table：
CREATE TABLE products （product_id NUMBER（3） PRIMARY KEY， product_desc VARCHAR2（25）， qtyNUMBER（8，2）， rate NUMBER（10，2）， total_value AS （ qty * rate）） PARTITION BY RANGE （total_value）（PARTITION p1 VALUES LESS THAN （100000）， PARTITION p2 VALUES LESS THAN
（150000）， PARTITION p3 VALUES LESS THAN （MAXVALUE））
COMPRESS FOR ALL OPERATIONS；
Which statement is true regarding this command？（）

A. It executes successfully but partition pruning cannot happen for this partition key.
B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.

点击查看答案

6.单项选择题 You plan to control idle sessions that are blocking other sessions from performing transactions.
Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?（）

A. Set metric threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

点击查看答案

7.单项选择题Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?（）

A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption

点击查看答案

8.多项选择题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)

A. views
B. fixed tables
C. heap tables
D. external tables
E. temporary tables
F. index-organized tables (IOT)

点击查看答案

9.单项选择题After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）

A. Opening the database in RESTRICTED mode
B. Opening the database with the RESETLOGS option
C. Setting a new DBID for the newly restored database
D. Restoring the server parameter file (SPFILE) to the new host

点击查看答案

10.多项选择题User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

点击查看答案