单选题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

题目
单选题
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

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.

相似考题

1.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 forwardB、Uses Flashback Log for recoveryC、Uses online redo logs to roll backD、Uses undo data to roll back the transactionE、Uses Recovery Manager （RMAN） to roll backF、Uses the System Monitor （SMON） background process to perform instance recovery

2.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.

3.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 ControlB、Oracle Management ServiceC、Oracle Enterprise Manager RepositoryD、Oracle Enterprise Manager Database Control

4.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 ControlB、Management ServerC、Management RepositoryD、Application Server ControlE、Oracle Management Agent

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

    • A、All control files are opened
    • B、All redo files are opened
    • C、The password file is opened
    • D、The parameter file is opened
    • E、All online data files are opened

    正确答案:B,E

  • 第5题：

    You work as a database administrator for Supportcenter.cn. In your production database， the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database， you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task？（）

    • A、You must have started the database instance in restricted mode.
    • B、You must have started the database instance inNORMALmode.
    • C、You must have started the database instance with server parameter file.
    • D、You must have started the database instance but must not have mounted.
    • E、You must have started the database instance but must not have opened.

    正确答案:C

  • 第6题：

    单选题
    You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
    A

    Host naming

    B

    Local naming

    C

    Easy Connect

    D

    External naming

    E

    directory naming


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）
    A

    Information about each Oracle Net connection.

    B

    Information about each entry in theLinstener.orafile

    C

    Information about the changed done in the database

    D

    Information about the different listeners in your system

    E

    Information about all thenondatabasefiles required to operate the database


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    You are using Resource Manager to manage system resources. While creating a new database user， you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this？（）
    A

    The Resource Manager plan does not affect the user.

    B

    There must be a plan directive in any of the plans of the group to control the resources.

    C

    The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.

    D

    The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.

    E

    The members of this group can change their group without the database administrator’s intervention.


    正确答案： 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


    正确答案： E
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： F
    解析： 暂无解析

  • 第12题：

    多选题
    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
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    You work as a database administrator for Supportcenter.cn. You are using three database， SupportCenter DB01， SupportCenter DB02， and SupportCenter DB03， on different host machines in your development environment. The database server configuration， such as IP address and listener port number， change frequently due to development requirements， and you have the task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）

    • A、Host naming
    • B、Local naming
    • C、Easy Connect
    • D、External naming
    • E、directory naming

    正确答案:E

  • 第17题：

    You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）

    • A、Information about each Oracle Net connection.
    • B、Information about each entry in theLinstener.orafile
    • C、Information about the changed done in the database
    • D、Information about the different listeners in your system
    • E、Information about all thenondatabasefiles required to operate the database

    正确答案:A

  • 第18题：

    单选题
    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

    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.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    多选题
    You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， SupportCenter， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）
    A

    Use a flashback query to retrieve the rows that were deleted

    B

    Useconventialincremental export and then import the affected object

    C

    Shutdown the database inNORMALmode and restart the database instance

    D

    Use DBMS_META package to reconstruct the object using undo segments

    E

    UseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the data

    F

    Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.


    正确答案： C,A
    解析： 暂无解析

  • 第20题：

    单选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    You work as a database administrator for Supportcenter.cn. You added atablespaceto your database. Because of the changes to the physical structure of your database， you performed a backup of the control file to trace. After this， you lost only the control files and the instance aborted due to a hardware failure. How would you proceed to recover the database？（）
    A

    Start the instance and open the database， instance recovery automatically recoverscontrol files

    B

    Create a file based on the contents of the trace file and save it to the control file locations and start the database

    C

    Re-create the database （The recovery of the control file is not possible because you have lost all the control files.）

    D

    Start the instance， in the NOMOUNTstate，re-create the control file using the CREATE CONTROLFILE command stored in the trace file.

    E

    Start the instance and MOUNT the database， then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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）.


    正确答案： E
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第24题：

    多选题
    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


    正确答案： D,C
    解析： 暂无解析

相关内容