[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 361-370

2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 361 – (Topic 11)

Note the following statements that use flashback technology:

  1. FLASHBACK TABLE lt;tablegt; TO SCN lt;scngt;;

  2. SELECT * FROM lt;tablegt; AS OF SCN 123456;



  5. SELECT * FROM lt;tablegt; VERSIONS AS OF SCN 123456 AND 123999;

    Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

    1. 1, 2, and 5

    2. 1, 3, and 4

C. 2, 3, 4, and 5

D. 1, 2, 3, 4, and 5

Answer: A Explanation:

The BEFORE DROP clause uses Recycle Bin;

The FLASHBACK DATABASE uses flashback logs at FRA area.

Question No: 362 – (Topic 11)

The writes the Flashback Database logs in the flash recovery area.

  1. FLSH

  2. FLDB

  3. RVWR

  4. RVRW

  5. FBDA

Answer: C Explanation:

RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast recovery area RVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some tasks for flashback log automatic management. Existed in Database instance, Flashback Database

FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into flashback data archives and manages archive space, organization, and retention

When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.

FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the archiving of tracked transactions has progressed.

See Also: Oracle Database Advanced Application Developer#39;s Guide Existed in Database and ASM instances

Question No: 363 – (Topic 11)

You executed the following commands in a database session:

Ensurepass 2018 PDF and VCE

Which statement is true about the contents of the recycle bin in this situation?

  1. They remain unaffected.

  2. They are moved to flashback logs.

  3. They are moved to the undo tablespace.

  4. They are moved to a temporary tablespace.

  5. The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.

Answer: E

Question No: 364 – (Topic 11)

The EMP table exists in your schema. You want to execute the following query:

SELECT ename, sal FROM emp


What are the minimum requirements for the statement to execute successfully? (Choose all

that apply)

  1. ARCHIVELOG mode must be enabled

  2. Row Movement must be enabled for the table

  3. FLASHBACK must be set to ON for the database

  4. The UNDO_MANAGEMENT parameter must be set to AUTO

  5. The UNDO_RETENTION parameter must be set appropriately

Answer: D,E

Question No: 365 – (Topic 11)

Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT;

Why would you need this to be executed?

  1. Because row IDs may change during the flashback operation

  2. Because the object number changes after the flashback operation

  3. Because the rows are retrieved from the recycle bin during the flashback operation

  4. Because the table is moved forward and back to a temporary during the flashback opertion

Answer: A

Question No: 366 – (Topic 11)

You executed the following command to drop a user: DROP USER scott CASCADE;

Which two statements regarding the above command are correct? (Choose two.)

  1. All the objects of scott are moved to the Recycle Bin.

  2. Any objects in the Recycle Bin belonging to scott are purged.

  3. All the objects owned by scott are permanently dropped from the database.

  4. All the objects of scott in the Recycle Bin must be purged before executing the DROP


  5. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Answer: B,C

Question No: 367 – (Topic 11)

AUM (Automatic UNDO Management) has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000.

However, AUM still retains only about 15 minutes worth of undo. What is the problem? (Choose the best answer.)

  1. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

  2. You need to increase the size of the undo tablespace.

  3. The undo tablespace is not set to auto-extend.

  4. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

Answer: C

Question No: 368 – (Topic 11)

Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)

  1. The Recycle Bin is a physical storage area for dropped objects.

  2. The Recycle Bin is a logical container for dropped objects.

  3. The Recycle Bin stores the results of a Flashback Drop operation.

  4. The objects in the Recycle Bin are stored in the tablespace in which they were created.

Answer: B,D

Question No: 369 – (Topic 11)

At the request of a user, you issue the following command to restore a dropped table: SQLgt; flashback table quot;BIN$F2JFfMq8Q5unbC0ceE9eJg==$0quot; to before drop;

Later, the user notifies you that the data in the table seems to be very old and out of date. What might be the problem?

  1. Because a proper range of SCNs was not specified, the wrong data was restored.

  2. A proper range of timestamps was not specified, so the wrong data was restored.

  3. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.

  4. Either option A or B could be correct. Not enough information was provided to determine which.

  5. None of the above.

Answer: C

Question No: 370 – (Topic 11)

View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.

What could be the reason? Exhibit:

Ensurepass 2018 PDF and VCE

  1. The first two updated were not explicitly committed.

  2. ALTER TABLE caused the recycle bin to release the space.

  3. The data definition language (DDL) operation caused a log switch.

  4. Flashback Versions Query stops producing versions of rows that existed before a change in the table structure.

Answer: C

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


Your email address will not be published. Required fields are marked *