Top Quality of 1Z0-053 real exam materials and class for Oracle certification for IT engineers, 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:

Q381. 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


Q382. Which statement describes the effect of table redefinition on the triggers attached to the table?

A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.

B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

C. All triggers on the table remain valid.

D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

Answer: A


Q383. To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:

SQL> ALTER TABLESPACE users BEGIN BACKUP;

While copying the file to the backup destination a power outage caused the instance to te minate abnormally.

Which statement is true about the next database startup and the USERS tablespace?

A. The database will open, and the tablespace automatically comes out of the backup mode.

B. The database will be mounted, and recovery must be performed on the USERS tablespace.

C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.

Answer: C


1Z0-053  real exam

Renovate oracle 1z0-053:

Q384. Examine the following RMAN command:

BACKUP DATABASE

TAG TESTDB

KEEP UNTIL 'SYSDATE+1'

RESTORE POINT TESTDB06;

Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. Only data files and the control file are backed up.

B. Archived redo logs are backed up only if the database is open during the backup.

C. The backup is deleted after one day, regardless of the default retention policy settings.

D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: BD


Q385. Which of the following represents the correct sequence of events for Database Replay?

A. Capture, analyze, preprocess, replay

B. Capture, preprocess, analyze, replay

C. Capture, preprocess, replay, analyze

D. Analyze, capture, preprocess, replay

E. None of the above

Answer: C


Q386. Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. The user has dropped an important table that needs to be recovered.

B. The database files are corrupted when the database is open.

C. You are not able to start up the database instance because the required database files are missing.

D. The archived log files are missing for which backup is not available.

Answer: BC


2passeasy.com

Breathing exams 1z0-051 1z0-052 1z0-053:

Q387. Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:

ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;

What would be the outcome of this command?

A. It produces an error because data already exists in the table.

B. It produces an error because compression can be enabled at table creation only.

C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

Answer: C


Q388. Examine the following command:

ALTER DISKGROUP data MOUNT FORCE;

In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline

B. when one or more ASM files are dropped

C. when some disks in a disk group are offline

D. when some disks in a failure group for a disk group are rebalancing

Answer: C


Q389. The following command is executed to create the baseline template:

SQL> EXECUTE

DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=>

TO_TIMESTAMP(SYSDATE+2),

END_TIME=>TO_TIMESTAMP(SYSDATE+10),

BASELINE_NAME=>'Mybase4',

TEMPLATE_NAME=>'Mytemp4',

EXPIRATION=>NULL);

Which statement is true about the effect of the above command?

A. It creates a baseline template that never expires.

B. It produces an error because no snapshot information is provided to create the baseline.

C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

Answer: A


Q390. Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You can add or remove the trace files to the package.

B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

C. You can add SQL test cases to the incident package.

D. You cannot create an incremental incident package when the physical files are purged rom the ADR.

Answer: ABC