★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Realistic of 1Z0-053 exam price materials and bundle 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:
Q301. In Oracle 11g, which recommendations does the SQL Access Advisor generate? (Choose all that apply.)
A. partitioning recommendations
B. statistics collection recommendations
C. index creation recommendations
D. materialized view recommendations
E. materialized view log recommendations
Q302. A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?
A. Flashback Drop
B. Flashback Query
C. Flashback Versions Query
D. Flashback Transaction Query
E. Flashback Table
Q303. Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)
A. Generate reports on data failure such as data file failures.
B. You can track the Service Request (SR) and implement repairs.
C. You can package and upload diagnostic data to Oracle Support.
D. You can manually run health checks to gather diagnostic data for a problem.
Latest 1z0-053 dumps free download:
Q304. The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.
View the Exhibit.
Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)
A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.
Q305. Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)
A. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
B. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D. Health Monitor checks are always initiated manually when there is some critical error.
Q306. View the Exhibit.
As shown in the diagram, in-memory statistics are transferred to the disk at regular intervals.
Which background process performs this activity?
100% Guarantee 1z0-053 braindumps:
Q307. If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?
A. recover lost blocks;
B. recover corrupt blocks;
C. recover media corrupt blocks from list;
D. recover corrupt blocks from list;
E. recover corruption list;
Q308. What will be the result of the following configuration?
A. An error will occur during database startup because the second parameter is not valid.
B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C. Archived redo logs will be created in two different locations by the ARCH process.
D. Archived redo logs will be created in two different locations by the LGWR process.
E. Neither parameter setting is valid, so the database will not start up.
Q309. 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?
A. 1440 MB
B. 90 MB
C. 362 MB
D. 272 MB
Q310. You are performing incomplete recovery using RMAN. You execute the following RUN block:
SET UNTIL SCN 1107600;
Which statement is true about the result?
A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
C. RMAN restores all datafiles and control files from the most recent backup
D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command
see more Oracle Database 11g: Administration II