1Z0-042
单选题You work as a database administrator for Supportcenter.cn. While granting a role， SELECT_CATALOG_ROLE， to a user， SupportCenter， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）A T
题目
The user cannot use the role at all.
The role would not be granted to the user.
The user needs to enable the role explicitly.
The user can start using the role immediately.
The user would have the admin option for the role.
相似问题和答案
第1题：
You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）
- A、The user cannot use the role at all.
- B、The role would not be granted to the user.
- C、The user needs to enable the role explicitly.
- D、The user can start using the role immediately.
- E、The user would have the admin option for the role.
正确答案:C
第2题：
You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
- A、Application Server Control
- B、Oracle Management Service
- C、Oracle Enterprise Manager Repository
- D、Oracle Enterprise Manager Database Control
正确答案:C,D
第3题：
You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
- A、Uses undo data for roll forward
- B、Uses Flashback Log for recovery
- C、Uses online redo logs to roll back
- D、Uses undo data to roll back the transaction
- E、Uses Recovery Manager （RMAN） to roll back
- F、Uses the System Monitor （SMON） background process to perform instance recovery
正确答案:D
第4题：
You work as a database administrator for Supportcenter.cn. You find that users with DBA role are using more CPU resources than what is allocated in their profiles. Which action would you take to ensure that resources limits are imposed on these users？（）
- A、Assign the DEFAULT profile to the users
- B、Set the RESOURCE_LIMIT parameter to TRUE in the parameter file
- C、Create a new profile with CPU restrictions and assign it to the users
- D、Specify the users as members of the DEFAULT_CONSUMER_GROUP
- E、Revoke the DBA role and grant CONNECT and RESOURCE role to the users
正确答案:B
第5题：
You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）
- A、The Oracle kernel will be placed in this location.
- B、The Oracle software will be placed in this location.
- C、The server parameter file （SPFILE） will be placed in this location.
- D、The database files will be placed in this location， if not specified explicitly.
- E、The location will be considered for the base of Oracle Managed Files （OMF）.
- F、The location will be considered for the base of Optimal Flexible Architecture （OFA）.
正确答案:F
第6题：
You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
- A、Application Server Control
- B、Oracle Management Service
- C、Oracle Enterprise Manager Repository
- D、Oracle Enterprise Manager Database Control
正确答案:C,D
第7题：
You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
- A、Control file
- B、Password file
- C、Parameter file
- D、Online redo log file
- E、Listener controller file
- F、Server parameter file
正确答案:B
第8题：
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective， which component would you configure on each database server？（）
- A、Database Control
- B、Management Server
- C、Management Repository
- D、Application Server Control
- E、Oracle Management Agent
正确答案:E
第9题：
You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）
- A、SQL*Plus
- B、iSQL*Plus
- C、Management Server
- D、Management Repository
- E、Oracle Enterprise Manager 10g Database Control
正确答案:E
第10题：
You work as a database administrator for Certkiller .com. While loading data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control， you find the status of the job as failed. On further investigation， you find the following error message in the output log： ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table？（）
- A、Restart the database instance and run the job
- B、Truncate the Certkiller STAFF table and run the job
- C、Delete all rows from the Certkiller STAFF table and run the job
- D、Increase the size of the USERStablespacethe and run the job
- E、Increase the size of the database default permanenttablespaceand run the job
正确答案:D