Free Oracle 1Z1-050 Exam Dumps Questions & Answers

Which setting enables the baselines by default in Oracle Database 11g?

• A.  setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
• B.  adding filters to the Automatic Database Diagnostic Monitor (ADDM)
• C.  setting the STATISTICS_LEVEL parameter to TYPICAL
• D.  enabling Automated Maintenance Task using Oracle Enterprise Manager

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011.
You executed the following RMAN commands:
RMAN> CONNECT CATALOG rco1 1/password@catdb
RMAN> IMPORT CATALOG rcat1 0/oracle@inst1;
What happens when you execute the above commands? (Choose all that apply.)

• A.  They register all the RCATIO-catalog registered databases in the RC011 catalog.
• B.  They deregister all databases registered in the RCAT10 catalog.
• C.  They import metadata for all registered databases in the RCAT10 database.
• D.  They overwrite all stored scripts in the RC011 catalog with the same name as that in the RCAT10 catalog.

Which two statements are true regarding Health Monitor checks in Oracle Database 11g?
(Choose two.)

• A.  Health Monitor checks are always initiated manually when there is some critical error.
• B.  Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption
• C.  Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
• D.  Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0,10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;

What do you infer from this?

• A.  The database instance is running with manual shared memory management.
• B.  The database instance has the MEMORY_TARGET value set to a nonzero value.
• C.  The database instance is running with manual PGA management.
• D.  All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

You upgraded Oracle Database 10g to Oracle Database 11 g. How would this affect the existing users' passwords?

• A.  All passwords remain non-case-sensitive till they are changed.
• B.  All passwords remain non-case-sensitive until their password attribute in the profile is altered.
• C.  All passwords remain non-case-sensitive and cannot be changed.
• D.  All passwords automatically become case-sensitive.