单选题Which option is best practice for creating a recovery catalog owner in the catalog database？（）AGranting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerBAllocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege t

题目
单选题
Which option is best practice for creating a recovery catalog owner in the catalog database？（）
A

 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

B

 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

C

 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user

D

 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

相似考题

1.Which option is best practice for creating a recovery catalog owner in the catalog database?()A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the userC. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the userD. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

2. You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.A、4，1，5，6，3，2B、4，3，1，5，6，2C、4，5，1，3，2，6D、5，4，1，3，2，6E、5，4，1，3，6，2

3.Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful， media recovery would be required to bring the tablespace online.E、If the above operation were successful， instance recovery would be required to bring the tablespace online.

4.You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）A、flash back the databaseB、import the temporary tablespace from the last exportC、restore all the data files and temporary files from the last full database backup and perform a recoveryD、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题Which option is best practice for creating a recovery catalog owner in the catalog database？（）A  Granting UNLIMITED QUOTA on the SYSTEM tablespace to the ownerB  Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privile”相关问题

  • 第1题：

    In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

    • A、After the COPY command.
    • B、After adding a data file in the target database.
    • C、After adding a tablespace in the target database.
    • D、After adding a tablespace in the catalog database.
    • E、After dropping a data file in the catalog database.
    • F、After running SQL Loader to load a large amount of data.

    正确答案:B,C

  • 第2题：

    While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.

    • A、2, 3, 5
    • B、1, 2, 4
    • C、1, 2, 4, 5
    • D、1, 2, 3, 4, 5

    正确答案:B

  • 第3题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第4题：

    Which option is best practice for creating a recovery catalog owner in the catalog database？（）  

    • A、 Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
    • B、 Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
    • C、 Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user
    • D、 Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

    正确答案:C

  • 第5题：

    You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

    • A、grant CONNECT role to all of the three users
    • B、grant RESOURCE role to all of the three users
    • C、grant both CONNECT and RESOURCE role to all of the three users
    • D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
    • E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

    正确答案:D

  • 第6题：

    You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）

    • A、The backup status will be marked expired in RMAN recovery catalog.
    • B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.
    • C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery catalogl
    • D、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.
    • E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.

    正确答案:C

  • 第7题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database？（）
    A

     Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

     Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

     Creating a new tablespace，allocating this as the default， and granting UNLIMITED QUOTA on this tablespace to the user

    D

     Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第8题：

    单选题
    You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
    A

    4，1，5，6，3，2

    B

    4，3，1，5，6，2

    C

    4，5，1，3，2，6

    D

    5，4，1，3，2，6

    E

    5，4，1，3，6，2


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

  • 第9题：

    单选题
    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
    A

    the CREATE TABLE .. command

    B

    sorting of the SYSTEM tablespace’s data

    C

    sorting of data required by recursive SQL statements

    D

    the CREATE TABLE .. ORGANIZATION EXTERNAL .. command

    E

    sorting of data if the users have not been allocated temporary tablespace explicitly

    F

    sorting of data if the users have been allocated temporary tablespace explicitly


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

  • 第10题：

    单选题
    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）
    A

    RESYNC CATALOG；

    B

    REGISTER DATABASE；

    C

    CREATE CATALOG TABLESPACE rman_ts；

    D

    GRANT recovery_catalog_owner TO rman_db01；


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

  • 第11题：

    单选题
    You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）
    A

    grant CONNECT role to all of the three users

    B

    grant RESOURCE role to all of the three users

    C

    grant both CONNECT and RESOURCE role to all of the three users

    D

    execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users

    E

    create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users


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

  • 第12题：

    单选题
    Which option is best practice for creating a recovery catalog owner in the catalog database?（）
    A

    Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner

    B

    Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user

    C

    Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

    D

    Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user


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

  • 第13题：

    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

    • A、 online redo log files
    • B、 alert log files
    • C、 control file
    • D、 datafiles associated with the SYSTEM tablespace

    正确答案:C

  • 第14题：

    You are creating a recovery catalog for use with RMAN. You have issued these commands： SQL> CREATE TABLESPACE rman_ts DATAFILE  ’/DISK1/rman_ts01.dbf’ 2> SIZE 20M 3> DEFAULT STORAGE （initial 100K next 100K pctincrease 0）； SQL> CREATE USER rman_db01 IDENTIFIED BY rman_db01 2> DEFAULT TABLESPACE rman_ts 3> QUOTA unlimited ON rman_ts；  Which command should you issue next？（）

    • A、RESYNC CATALOG；
    • B、REGISTER DATABASE；
    • C、CREATE CATALOG TABLESPACE rman_ts；
    • D、GRANT recovery_catalog_owner TO rman_db01；

    正确答案:C

  • 第15题：

    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

    • A、The tablespace TBS1 is full.
    • B、The user is not the owner of the SYSTEM tablespace.
    • C、The user does not have quota on the TBS1 tablespace.
    • D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
    • E、The user does not have sufficient privileges to create table on the default permanent tablespace.

    正确答案:C

  • 第16题：

    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

    • A、the CREATE TABLE .. command
    • B、sorting of the SYSTEM tablespace’s data
    • C、sorting of data required by recursive SQL statements
    • D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
    • E、sorting of data if the users have not been allocated temporary tablespace explicitly
    • F、sorting of data if the users have been allocated temporary tablespace explicitly

    正确答案:E

  • 第17题：

    Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）

    • A、 DROP TABLESPACE temp1；
    • B、 DROP TABLESPACE temp1 INCLUDING CONTENTS；
    • C、 DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
    • D、 DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

    正确答案:C

  • 第18题：

    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）

    • A、profile
    • B、account lock
    • C、account unlock
    • D、password expire
    • E、quota 10MB on TBS1
    • F、password never expire
    • G、default tablespace TBS1
    • H、quota unlimited on TBS1
    • I、temporary tablespace TEMP
    • J、temporary tablespace SYSTEM

    正确答案:D,E,G

  • 第19题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


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

  • 第20题：

    单选题
    While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.
    A

    2, 3, 5

    B

    1, 2, 4

    C

    1, 2, 4, 5

    D

    1, 2, 3, 4, 5


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第22题：

    单选题
    You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）
    A

     flash back the database

    B

     import the temporary tablespace from the last export

    C

     restore all the data files and temporary files from the last full database backup and perform a recovery

    D

     not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace


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

  • 第23题：

    单选题
    Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）
    A

    The operation would fail if tbs_1 were a read-only tablespace.

    B

    The operation would fail if tbs_1 were a read/write tablespace.

    C

    The operation would fail if tbs_1 were the default tablespace for the database.

    D

    If the above operation were successful， media recovery would be required to bring the tablespace online.

    E

    If the above operation were successful， instance recovery would be required to bring the tablespace online.


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

  • 第24题：

    单选题
    You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）
    A

    The tablespace TBS1 is full.

    B

    The user is not the owner of the SYSTEM tablespace.

    C

    The user does not have quota on the TBS1 tablespace.

    D

    The user does not have sufficient system privileges to create table in the TBS1 tablespace.

    E

    The user does not have sufficient privileges to create table on the default permanent tablespace.


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

相关内容