RESYNC CATALOG;
REGISTER DATABASE;
CREATE CATALOG TABLESPACE rman_ts;
GRANT recovery_catalog_owner TO rman_db01;
第1题:
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?()
第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.
第3题:
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?()
第4题:
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?()
第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?()
第6题:
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?()
第7题:
You opened the encryption wallet and then issued the following command: SQL>CREATE 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?()
第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.
第9题:
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?()
第10题:
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?()