oracle database 11g dba ii 1z0-053 [May 2016]

Approved of 1Z0-053 braindumps materials and dumps for Oracle certification for IT examinee, Real Success Guaranteed with Updated 1Z0-053 pdf dumps vce Materials. 100% PASS Oracle Database 11g: Administration II exam Today!

2016 May 1Z0-053 Study Guide Questions:

Q431. What is the result of this command? RMAN> Report need backup days 3;

A. Lists all datafiles created in the last three days that are not backed up.

B. Lists all datafiles not recoverable based on the current retention criteria.

C. Lists all datafiles not backed up in the last three days. The datafile is not recoverable.

D. Lists all datafiles that need to be backed up due to unrecoverable operations.

E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

Answer: E


Q432. You are managing an Oracle Database 11g instance. You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication? (Choose all that apply.)

A. The source database backup must be copied over the net for test database.

B. The source database must be run in ARCHIVELOG mode if the database is open.

C. The source database must be shut down cleanly if the database is in mounted state.

D. A net service name should be set up and a listener configured with the target as well as the source database.

Answer: BCD


Q433. The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the plan history.

B. The optimizer selects the new plan for the execution of the SQL statement.

C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.

D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.

E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

Answer: AE


1Z0-053  braindumps

Renovate 1z0-053 latest exam:

Q434. You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:

SQL> EXECUTE

DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');

You need statistics to be collected more quickly. What can you do to achieve this?

A. Set DYNAMIC_SAMPLING to level 4.

B. Set the STATISTICS_LEVEL parameter to BASIC.

C. Set the INCREMENTAL value to TRUE for the partition table.

D. Increase the value of STALE_PERCENT for the partition table.

Answer: C


Q435. You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

A. the SQL text

B. the execution plan

C. the execution context

D. the execution frequency

E. the system change number (SCN)

Answer: ACD


Q436. Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

A. It cannot be done in parallel.

B. It can be done at the table level or partition level.

C. It does not require additional storage because the operation is done online.

D. Local and global indexes are maintained automatically during the operation.

Answer: B


1Z0-053  braindumps

High quality 1z0-053 exam guide:

Q437. In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.

Which method must you use to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery (TSPITR)

D. Incomplete Recovery with system change number (SCN)

Answer: C


Q438. Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:

SQL> SELECT * FROM sales;

Which process would retrieve the result from the database and return it to the client program?

A. User process

B. Server process

C. System Monitor (SMON)

D. Process Monitor (PMON)

E. Checkpoint process (CKPT)

Answer: B


Q439. View the Exhibit exhibit1 to observe the maintenance window property. View the Exhibit exhibit2 to examine the output of the query.

Which two statements describe the conclusions? (Choose two.)


A. RESOURCE_PERCENTAGE should be increased.

B. The repeat time for the window should be decreased.

C. RESOURCE_PERCENTAGE should be decreased.

D. The window duration should be increased.

Answer: AD


Q440. The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

A. WHERE clause

B. ORDER BY clause

C. BETWEEN clause

D. NLSSORT function

E. NLS_SORT function

Answer: AD



see more 1Z0-053 dumps