QUESTION NO: 1
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?
Correct Answer: C
Vote an answer
QUESTION NO: 2
You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
You are in the process of creating a Virtual Private Catalog (VPC) in your Oracle Database l1g database .The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER.CATOWNER executes the following command to grant privileges to a new user vpc1 using Oracle Database 11g RMAN executables:
RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;
Then you issue the following commands:
RMAN> CONNECT CATALOG vpc1/oracle@catdb;
RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"
What is the outcome of the above commands?
Correct Answer: C
Vote an answer
QUESTION NO: 3
Which three file types are managed by Data Pump jobs?
Which three file types are managed by Data Pump jobs?
Correct Answer: C,D,E
Vote an answer
QUESTION NO: 4
Given below is a list of scenarios:
1) A user terminates his session abnormally.
2) The connection between the server and the client application terminates because of a
network failure.
3) A schema is accidentally dropped.
4) The tablespace is accidentally dropped from the database.
5) The hard disk gets corrupted and the data files in the disk are lost.
6) The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
Given below is a list of scenarios:
1) A user terminates his session abnormally.
2) The connection between the server and the client application terminates because of a
network failure.
3) A schema is accidentally dropped.
4) The tablespace is accidentally dropped from the database.
5) The hard disk gets corrupted and the data files in the disk are lost.
6) The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
Correct Answer: D
Vote an answer
QUESTION NO: 5
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)
Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)
Correct Answer: A,C
Vote an answer
QUESTION NO: 6
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?
You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation?
Correct Answer: A,D
Vote an answer
QUESTION NO: 7
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?
Correct Answer: C
Vote an answer
QUESTION NO: 8
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Correct Answer: B,E
Vote an answer
QUESTION NO: 9
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?
Correct Answer: D,E
Vote an answer
QUESTION NO: 10
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?
Correct Answer: B
Vote an answer