Depending on outstanding technology, much better support for purchasers. Exambible offer Round-the-clock customer service with regard to Oracle examinee and you can acquire what you need understand at any time. Your own pleasure of our own 1Z0-053 is our own support objective, their combined advancement along with consumers is our own prolonged quest in the large part. Thus do not wait to contact us all if you have any questions of 1Z0-053 test.

2016 Jun 1Z0-053 exam cost

Q271. Which statement about the enabling of table compression in Oracle Database 11g is true?

A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.

B. Compression can be enabled only at the table level for both direct loads and conventional DML.

C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.

D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

Answer: D


Q272. View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?

Exhibit:


A. The text alert log file will be available in Diag Trace

B. A copy alert log file will be kept in Diag Incident for every incident.

C. The XML version of the alert log file will be available in Diag Trace.

D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.

Answer: A


Q273. Which command is used to open the database after an incomplete recovery?

A. alter database open

B. alter database open repairlog

C. alter database open resetlogs

D. alter database open resetlog

E. alter database resetlogs open

Answer: C


Q274. Examine the section of the Health Check report given below:

DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')

-----------------------------------------------------------------------

Run Name : HM_RUN_1061

Run Id : 1061

Check Name : Data Block Integrity Check

Mode : REACTIVE

Status : COMPLETED

Start Time : 2007-05-12 22:11:02.032292 -07:00

End Time : 2007-05-12 22:11:20.835135 -07:00

Error Encountered : 0

Source Incident Id : 7418

Number of Incidents Created :0

Which two statements are true regarding the Health Check report? (Choose two.)

A. Health Check was performed manually.

B. Health Check was performed to check the disk image block corruptions.

C. Health Check was performed to check interblock and intersegment corruption.

D. Health Check was performed to verify the integrity of database files and report failures.

E. Health Check was performed by the Health Monitor automatically in response to a critical error.

Answer: AB


Q275. Examine the following ALTER command;

SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

What is the purpose of the command?

A. It cancels all pending disk drops within the disk group.

B. It adds previously dropped disks back into the disk group.

C. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.

D. It mounts disks in the disk group for which the drop-disk operation has already been completed.

E. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed.

Answer: A


2passeasy.com

Renew 1z0-053 pdf free download:

Q276. You executed the following commands:

SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;

SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false');

SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A


Q277. Which command will result in a trace file being created with the create controlfile command contained in it?

A. alter database backup controlfile;

B. alter database backup controlfile to trace;

C. alter database controlfile backup;

D. alter database controlfile backup to '/ora01/oracle/ctrl_backup.ctl'

E. alter database begin controlfile backup;

Answer: B


Q278. Which of the following does the recover command not do?

A. Restore archived redo logs.

B. Apply archived redo logs.

C. Restore incremental backups.

D. Apply incremental backups.

E. Restore datafile images.

Answer: A


Q279. During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

A. V$LOGFILE

B. V$RECOVER_LOG

C. V$RECOVER_DATABASE

D. V$LOG_RECOVER

E. V$LOG

Answer: AE


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