单选题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？（）ARESYNC CATALOG；BREGISTER DATABASE；CCREATE CATALOG TABLESPACE rman_ts；DGRANT recovery_catalog_owner TO rman_db01；
单选题
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；
参考解析
解析：
暂无解析
相关考题：
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.
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
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）A、 SQL scriptsB、 Recovery Manager （RMAN） scriptC、 Data PumpD、 SQL*LoaderE、 Flashback database
The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this： 1.SQL GRANT recovery_catalog_owner TO vpc1； 2.RMAN CONNECT CATALOG vpc1/password@catdb； 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN CONNECT CATALOG catowner/password@catdb； 5.RMAN CREATE VIRTUAL CATALOG； What is the correct sequence in which the commands have to be executed？（） A、 1，4，5，2，3B、 1，4，3，2，5C、 4，5，2，3，1D、 2，3，4，5，1E、 1，4，2，3，5
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, 5B、1, 2, 4C、1, 2, 4, 5D、1, 2, 3, 4, 5
You opened the encryption wallet and then issued the following command： SQLCREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）； Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome？（） A、 It creates the table and encrypts the data in it.B、 It generates an error because the wallet is closed.C、 It creates the table but does not encrypt the data in it.D、 It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
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；
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）A、1, 4, 5, 2, 3B、1, 4, 3, 2, 5C、4, 5, 2, 3, 1D、2, 3, 4, 5, 1E、1, 4, 2, 3, 5
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.
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 .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly
Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）A、No more data files can be added to the tablespace.B、Segment space is managed by free lists in the tablespace.C、A user created without being assigned a default tablespace uses this tablespace.D、The tablespace can be dropped with the current setting with segments present in it
Which command do you use to create a recovery-catalog schema? （）A、create recovery catalog B、create catalogC、build catalog D、catalog create E、mount catalog
You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows： CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ； Which statement regarding the above command is correct？（） A、 It will create the tablespace TEMP1 in group G1.B、 It will create the tablespace TEMP1 in group G3.C、 It will not add the tablespace TEMP1 to any group.D、 It will create the tablespace TEMP1 in the default group.
You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?（）A、OPTIMAL B、INITIAL C、PCTINCREASE D、NEXT
The ORDERS table in the database of a company contains one million records. The table is stored in the DATA tablespace and the index created on the ORDERS table is stored in the index tablespace named INDEXES. On Monday， you failed to start the database because the datafiles of the INDEXES tablespace were missing. You dropped and recreated the INDEXES tablespace by issuing the following command： SQLDROP TABLESPACE INDEXES INCLUDING CONTENTS； SQL CREATE TABLESPACE INDEXES DATAFILE ’C:///ORACLE/ORADATA/ORA101t/INDEX01.DBF’ SIZE 50m； After that， you issued the following command to recreate the index： CREATE UNIQUE INDEX sales_index_pk ON sales （order_id） PCTFREE 10 INITRANS 2 MAXTRANS 255 TABLESPACE indexes STORAGE （ INITIAL 1m NEXT 1m PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 8192 ） NOLOGGING PARALLEL（ degree 4） Which two clauses are responsible for reducing the time for the recreation of the index？（）A、 PCTFREEB、 MAXTRANSC、 PCTINCREASED、 INITIALE、 NOLOGGINGF、 PARALLEL
多选题Examine the commands executed in a DBA session：SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered. Which two statements are trueregarding the MRKT tablespace（）ANo more data files can be added to the tablespace.BSegment space is managed by free lists in the tablespace.CA user created without being assigned a default tablespace uses this tablespace.DThe tablespace can be dropped with the current setting with segments present in it
单选题You have three temporary tablespace groups named G1， G2， and G3 in your database. You are creating a new temporary tablespace as follows： CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ’/u1/data/temp1.dbf’ SIZE 10M TABLESPACE GROUP ； Which statement regarding the above command is correct？（）A It will create the tablespace TEMP1 in group G1.B It will create the tablespace TEMP1 in group G3.C It will not add the tablespace TEMP1 to any group.D It will create the tablespace TEMP1 in the default group.
单选题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.A4，1，5，6，3，2B4，3，1，5，6，2C4，5，1，3，2，6D5，4，1，3，2，6E5，4，1，3，6，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.A2, 3, 5B1, 2, 4C1, 2, 4, 5D1, 2, 3, 4, 5
单选题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？（）Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly
单选题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.（）A2，3，5B1，2，4C1，2，4，5D1, 2, 3, 4, 5
单选题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？（）ARESYNC CATALOG；BREGISTER DATABASE；CCREATE CATALOG TABLESPACE rman_ts；DGRANT recovery_catalog_owner TO rman_db01；
单选题You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）AIt will create the tablespace TEMP1 in group G1.BIt will create the tablespace TEMP1 in group G3.CIt will not add the tablespace TEMP1 to any group.DIt will create the tablespace TEMP1 in the default group.
单选题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？（）AThe tablespace TBS1 is full.BThe user is not the owner of the SYSTEM tablespace.CThe user does not have quota on the TBS1 tablespace.DThe user does not have sufficient system privileges to create table in the TBS1 tablespace.EThe user does not have sufficient privileges to create table on the default permanent tablespace.
单选题You opened the encryption wallet and then issued the following command： SQLCREATE TABLESPACE securespace DATAFILE ’/home/user/oradata/secure01.dbf’ SIZE 150M ENCRYPTION USING ’3DES168’ DEFAULT STORAGE（ENCRYPT）； Then you closed the wallet. Later， you issued the following command to create theEMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column. What is the outcome？（）A It creates the table and encrypts the data in it.B It generates an error because the wallet is closed.C It creates the table but does not encrypt the data in it.D It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
单选题Which command do you use to create a recovery-catalog schema? （）Acreate recovery catalog Bcreate catalogCbuild catalog Dcatalog create Emount catalog
单选题The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL GRANT recovery_catalog_owner TO vpc1; 2.RMAN CONNECT CATALOG vpc1/password@catdb; 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN CONNECT CATALOG catowner/password@catdb; 5.RMAN CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）A1, 4, 5, 2, 3B1, 4, 3, 2, 5C4, 5, 2, 3, 1D2, 3, 4, 5, 1E1, 4, 2, 3, 5
单选题The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this： 1.SQL GRANT recovery_catalog_owner TO vpc1； 2.RMAN CONNECT CATALOG vpc1/password@catdb； 3.RMAN GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN CONNECT CATALOG catowner/password@catdb； 5.RMAN CREATE VIRTUAL CATALOG； What is the correct sequence in which the commands have to be executed？（）A 1，4，5，2，3B 1，4，3，2，5C 4，5，2，3，1D 2，3，4，5，1E 1，4，2，3，5