Category Archives: 1Z0-050 Dumps

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (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>… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (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… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (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? A.    /u01/app/oracle B.    $ORACLE_HOME/log C.    $ORACLE_HOME/bdump D.    /u01/app/oracle/product/11.1.0/db_1 Answer: A QUESTION 92 View the… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (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 Answer: A QUESTION 82 Which two activities are NOT… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (71-80)

QUESTION 71 Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE ————— ————— ————– ————- LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output? (Choose two.) A.    FREE_SPACE indicates only the space that is currently unallocated. B.    ALLOCATED_SPACE indicates only the space currently allocated and in use.… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (61-70)

QUESTION 61 Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = ‘IGNORE’; What is the impact of this setting on the usage of SecureFiles? A.    It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB. B.    It forces SecureFiles to be created even if the BASICFILE option is… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (51-60)

QUESTION 51 Which statements are true regarding SecureFile LOBs? (Choose all that apply.) A.    The amount of undo retained is user controlled. B.    SecureFile LOBs can be used only for nonpartitioned tables. C.    Fragmentation is minimized by using variable-sized chunks dynamically. D.    SecureFile encryption allows for random reads and writes of the encrypted data. E.   … Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (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 ____. A.   … Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (31-40)

QUESTION 31 Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.) A.    multiplexing of the control file B.    database and operating system upgrades C.    adding the redo log member to the database D.    changing the database storage to ASM-managed storage Answer: BD QUESTION 32… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (21-30)

QUESTION 21 You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (11-20)

QUESTION 11 What can you achieve by implementing reverse key index? A.    Remove repeated key values from the index to fit more index entries in a given amount of disk space B.    Prevent contention on the highest leaf block when using sequences to generate keys C.    Reverse the bytes of each column indexed including the… Read More »

Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-050 Dumps (1-10)

QUESTION 1 Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.) A.    Cursor cache B.    Stored outline C.    SQL Tuning Set D.    Automatic Workload Repository (AWR) snapshots Answer: AC QUESTION 2 Which two statements about workload capture and replay operations are true? (Choose two.) A.   … Read More »