网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）
A
The user must have been granted the DBA role.
B
The user must have been granted the switch privilege as a part of a role.
C
The user must have been granted the Resource Manager administrator privilege.
D
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
参考答案
参考解析
解析：
暂无解析
更多 “单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）A The user must have been granted the DBA role.B The user must have been granted the switch privilege as a part of a role.C The user must have been granted the Resource Manager administrator privilege.D The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.” 相关考题
考题
单选题From the V$SESSION_LONGOPS view， you find that some of the database users have long/x7frunning queries and are consuming a lot of CPU time. This causes problems for you when you try to log on as the system user and perform small maintenance tasks. You would like to ensure that users SYS and SYSTEM get priority over all other users. Which method would you use to achieve this objective？（）A
create a plan directive in the SYS_GROUPB
create the pending area for the consumer groupC
activate the provided SYSTEM_PLAN in Resource ManagerD
set the TIMED_STATISTICS parameter to TRUE in the parameter fileE
set the execution time limit for all users， except SYS and SYSTEM， in their profiles
考题
单选题You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）A
DBMS_WORKLOAD_REPOSITORYB
DBMS_RESOURCE_MANAGERC
DBMS_SQLTUNED
DBMS_ADVISOR
考题
单选题You are maintaining your database in ARCHIVELOG mode. An important table， SCOTT.EMPLOYEE， is dropped and purged from the Recycle Bin on Monday at 2：00 P.M. You do not use RMAN to perform backups. You performed the last full user-managed backup at 9：00 P.M. on Sunday. How will you recover the dropped table， SCOTT.EMPLOYEE？（）A
by using the Flashback Table featureB
by using the Flashback Database featureC
by performing incomplete recovery using RMAN utilityD
by performing incomplete recovery using user-managed recovery
考题
多选题You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）ADB_CREATE_FILE_DESTBDB_RECOVERY_FILE_DESTCDB_RECOVERY_FILE_DEST_SIZEDDB_ONLINE_LOG_DEST_n
考题
单选题View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）A
The row movement is not enabled on the table.B
The first two updates were not explicitly committed.C
The Flashback Versions Query lists only the most recent update.D
The Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
考题
单选题You execute the following RMAN command in the order shown below： BACKUP VALIDATE DATABASE； BLOCKRECOVER CORRUPTION LIST； What will these commands do？（）A
Create a backup of the database and recover all corrupted blocks found in the backup.B
Run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database.C
Run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view.D
Run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view.E
Run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired.
考题
单选题You are maintaining your database in Oracle10g. You are required to view the list of files that have not been backed up for the last seven days. Which RMAN command will you use？（）A
LIST commandB
CROSSCHECK commandC
REPORT commandD
SHOW command
考题
单选题You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）A
This instance is being used to manage the operating system files.B
This instance is being used to manage the files of other databases.C
This instance is being used to manage the instances of other databases.D
This instance is being used to manage the background processes of other instances.
考题
单选题At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion： SELECT operation， undo_sql， logon_user FROM FLASHBACK_TRANSACTION_QUERY WHERE xid= HEXTORAW（’0100043E23456’）； where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）A
William used the Flashback Version Query feature.B
William issued the CROSSCHECK command at the RMAN prompt.C
William viewed the alert log file.D
William used the Flashback Table feature.
考题
单选题Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）： CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M； What would be the result of this command？（）A
It would result in an error because the template cannot be used along with the disk group.B
It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C
It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.D
It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.
热门标签
最新试卷