Oracle Database 11g: New Features for Administrators
Question No: 41
Examine the following RMAN command:
BACKUP DATABASE TAG TESTDB
KEEP UNTIL #39;SYSDATE 11 RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)
Only data files and the control file are backed up.
Archived redo logs are backed up only if the database is open during the backup
The backup is deleted after one day, regardless of the default retention policy settings.
The backup becomes obsolete after one day, regardless of the default retention policy settings.
Question No: 42
In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)
when one or more disks in an ASM disk group are lost
when the data file on an ASM disk group gets corrupted
when one of the disks in a disk group is accidentaly unplugged
wnen one or more file directory paths are accidentally deleted from an ASM disk group
Question No: 43
View the Exhibit to examine the error during the database startup.
You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:
RMANgt; REPAIR FAILURE;
Which statement describes the consequence of the command?
The command performs the recovery and closes the failures.
The command only displays the advice and the RMAN script required for repair.
The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command
The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
Question No: 44
Examine the following PL/SQL block:
my_plans plsjnteger; BEGIN
My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =gt;
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
It is loaded with the FIXED status.
It is loaded with the ACCEPTED status.
It is not loaded with the ENABLED status.
It is not loaded with the ACCEPTED status.
Question No: 45
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?
It updates the existing SQL profiles with current statistics.
It makes the statistics information available to GATHER_STATS_JOB.
It initiates the statistics collection process by running GATHER_STATS_JOB.
It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
Question No: 46
While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)
The plan baselines can be evolved over time to produce better performance
The newly generated plans are directly placed into the SQL plan baseline without being verified.
The new SQL statements initially run with the plans that are known to produce good performance under standard
The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
Question No: 47
Evaluate the following command and Its output: SQLgt;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.)
FREE_SPACE indicates only the space that is currently unallocated.
ALLO CAT ED_S PACE indicates only the space currently allocated and in use.
FREE_SPACE indicates only the space that is currently allocated and available for reuse.
ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.
FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.
Question No: 48
Evaluate the following code:
SQLgt;VARIABLE task_name VARCHAR2(255); SQLgt;VARIABLE sql_stmt VARCHAR2(4000); SQLgt;BEGIN
:sql_stmt := #39;SELECT COUNTO FROM customers
WHERE cust_state_province =”CA”; :task_name := #39;MY_QUICKTUNE_TASK#39;;
DBMS_ADVISOR .QUICK_TUNE(DBMS_ADVISOR .SQLACCESS_ADVISOR,
:task_name, :sql_stmt); END;
What is the outcome of this block of code?
It creates a task and workload, and executes the task.
It creates a task and workload but does not execute the task.
It produces an error because a template has not been created.
It produces an error because the SQL Tuning Set has not been created.
Question No: 49
Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:
Preprocess the captured workload.
Restart the database in RESTRICTED mode.
Set up the Replay Clients.
Restore the test database to the point when the capture started.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.
A. 2, 1,5,3,4
1,4, 5, 3 (2 is not required.)
1, 2,4, 5 (3 is not required.)
1,4, 3, 5 (2 is not required.)
Question No: 50
View the Exhibit to examine the parameter values.
You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?
100% Free Download!
–Download Free Demo:1z0-050 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-050 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|