单项选择题

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）

A. take data files from the read-only tablespace offline before performing a recovery
B. recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C. drop the read-only tablespace and re-create the tablespace after recovery
D. perform a recovery； status of the tablespace in control file will be changed automatically

点击查看答案

上一题目录下一题

相关考题

单项选择题

You want to create a consumer group， GROUP1， and you execute the following command in the command-line interface：
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP （CONSUMER_GROUP =>’group1’，
COMMENT => ’New Group’）；
This command errors out displaying the following message：
ERROR at line 1：
ORA-29371： pending area is not active
ORA-06512： at "SYS.DBMS_RMIN"， line 115
ORA-06512： at "SYS.DBMS_RESOURCE_MANAGER"， line 108
ORA-06512： at line 1
What action would you take to overcome this error？（）

A. activate the Pending Area before creating the consumer group
B. create the Pending Area before creating the consumer group
C. increase the size of the database buffer cache to accommodate the Pending Area
D. increase the size of the shared pool to accommodate the Pending Area
E. increase the size of the large pool to accommodate the Pending Area

单项选择题

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to？（）

A. FREQ = MONTHLY； BYDAY = 2FRI；
B. FREQ = MONTHLY； BYDAY = FRI（2）；
C. FREQ = MONTHLY； BYDAY = FRI2；
D. FREQ = MONTHLY； BYDAY = -2FRI；

多项选择题

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：
SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario？（）

A. A total of 14 GB memory will be allocated to the automatically tuned memory components
B. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F. Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE