Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back (111-120)

QUESTION 111
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/sys@APPPROD
RMAN> CONNECT AUXILIARY sys/sys@DUPDB
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
PASSWORD FILE
SPILE
NOFILENAMECHECK;
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.

Continue reading

Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back (101-110)

QUESTION 101
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

A.    generating the SQL profile
B.    testing and accepting the SQL profile
C.    generating a list of candidate SQLs for tuning
D.    adding tuned SQL plans into the SQL plan baseline
E.    tuning each SQL statement in the order of importance
F.    generating baselines that include candidate SQLs for tuning

Continue reading

Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back (91-100)

QUESTION 91
Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?

Continue reading

Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back (81-90)

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

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

Continue reading

Pass 1Z0-050 In First Try Passleader 1Z0-050 Real Dumps With 100% Money Back (41-50)

QUESTION 41
You executed the following PL/SQL block successfully:
VARIABLE tname VARCHAR2(20)
BEGIN
dbms_addm.insert_finding_directive (NULL, DIR_NAME=>’Detail CPU Usage’, FINDING_NAME=>’CPU Usage’,
MIN_ACTIVE_SESSIONS=>0, MIN_PERC_IMPACT=>90);
:tname := ‘database ADDM task4’;
dbms_addm.analyze_db(:tname, 150, 162);
END;
/
Then you executed the following command:
SQL> SELECT dbms_addm.get_report(:tname) FROM DUAL;
The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis ____.

Continue reading