You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.
You executed the following RMAN commands:
RMAN> CONNECT TARGET sys/[email protected]
RMAN> CONNECT AUXILIARY sys/[email protected]
RMAN> DUPLICATE TARGET DATABASE
FROM ACTIVE DATABASE
What are the implications of this command?
A. It creates database files for the duplicate database under the Oracle base with a different directory
for the duplicate database.
B. It overwrites data files of the target database because a different location for data files is not mentioned
for the duplicate database.
C. It creates database files for the duplicate database under the same Oracle home as that of the target
database with the same directory structure.
D. It creates database files for the duplicate database under the same Oracle home as that of the target
but with a different directory for the duplicate database.
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it.
C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic
Storage Management (ASM) setup.
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was
created with the encryption option enabled.
You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Observe the following warning in an RMAN session of your database instance:
WARNING: new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning?
A. The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic
B. The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic
C. The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic
Repository (ADR) since the last LIST FAILURE.
D. The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository
(ADR) since the last LIST FAILURE command was executed.
Which statement is true regarding virtual private catalogs?
A. The virtual private catalog owner cannot create and modify the stored scripts.
B. A virtual private catalog owner can create a local stored script, and have read/write access to a global
C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the
RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or
SYSOPER privilege on the target database.
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)
A. It is used to explicitly close the open failures.
B. It is used to execute the advised repair script.
C. It is used to change failure priority only for the CRITICAL priority.
D. It is used to change failure priority only for HIGH or LOW priorities.
E. It is used to inform the database about the repair after the repair script executes.
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:
1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.
2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.
What is the reason for performing these activities?
A. to minimize plan regression due to the use of a new optimizer version
B. to completely avoid the use of new plans generated by a new optimizer version
C. to prevent plan capturing when the SQL statement is executed after the database upgrade
D. to keep the plan in the plan history so that it can be used when the older version of the optimizer
View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?
A. The index is not used by the optimizer but is maintained during DML operations.
B. The index is not used by the optimizer and is not maintained during DML operations.
C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained
during DML operations.
D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained
during DML operations.
While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?
A. It updates the existing SQL profiles with current statistics.
B. It makes the statistics information available to GATHER_STATS_JOB.
C. It initiates the statistics collection process by running GATHER_STATS_JOB.
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
If you want to pass Oracle 1Z0-050 successfully, do not missing to read latest lead2pass Oracle 1Z0-050 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.