网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
A
assign users to consumer groups
B
set the resource plan for the instance
C
configure a simple resource plan and specify plan directives
D
configure a complex resource plan and specify plan directives
参考答案
参考解析
解析：
暂无解析
更多 “单选题You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）A assign users to consumer groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives” 相关考题
考题
单选题You want to check the EMP table in the user， Scott’s schema for block corruption. You also want to fix the corrupted blocks， if any. How will you accomplish the required task？（）A
by using the ANALYZE utilityB
by using the DBVERIFY utilityC
by using the DB_BLOCK_CHECKING parameterD
by using the DBMS_REPAIR package
考题
单选题Consider the recovery steps in each of the cases given below： Case 1： Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files， open the database using the RESETLOGS option. Back up the database. Case 2： Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3： Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A
only case 1B
only case 2C
only case 3D
case 1 and 2E
case 2 and 3F
case 1 and 3G
all cases： case 1， case 2 and case 3
考题
单选题You issued the following command at the UNIX environment： % setenv ORA_SDTZ ’OZ_TZ’ What will be the impact of issuing the above command？（）A
The operating system local time zone will be set for a user session using the operating system environment variable.B
The database local time zone will be set for a user session using the operating system environment variable.C
The operating system local time zone will be set for the database using the operating system environmentD
The database local time zone will be set for the database using the operating system environment variable.
考题
多选题In Recovery Manager （RMAN）， you have set control file autobackup to ON by using the following command： CONFIGURE CONTROLFILE AUTOBACKUP ON; Which two events would cause the control file to be backed up automatically？ （）Aa tablespace is taken offlineBthe database instance is restartedCa new data file is added to an existing tablespaceDa successful backup is recorded in the RMAN repositoryEthe RMAN connection is disconnected from the target database
考题
单选题You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）A
WindowB
ProgramC
Job classD
Window group
考题
单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）A
The rebalancing of the disk group would be stopped.B
The rebalancing of the disk group would be completed as fast as possible.C
The command would result in an error because the value of POWER cannot be 0.D
The rebalancing of the disk group would be completed without affecting the disk group DG3.E
The command would result in an error because the disk groups cannot be manually rebalanced.
考题
单选题You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）A
until Thursday morningB
until that point in time when the database is openedC
until that point in time when the recovery is performedD
until last Sunday’s backupE
until that point in time when the table is dropped and purgedF
until Wednesday evening
考题
多选题Immediately after adding a new disk to or removing an existing disk from an Automatic StorageManagement （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）Aincrease the number of checkpoint processesBdefine the POWER option while adding or removing the disksCincrease the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESDincrease the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESEincrease the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process
热门标签
最新试卷