[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 371-380

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 371 – (Topic 11)

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

  1. Initiate an incomplete recovery operation using RMAN.

  2. Copy the table from a development database.

  3. Advise the user to rekey the data.

  4. Perform a Flashback Drop operation.

  5. Perform a Flashback Recovery operation.

Answer: D

Question No: 372 – (Topic 11)

In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

  1. Ensure that database is running with version 10.1 compatibility.

  2. Enable Flashback Logging.

  3. Enable Supplemental Logging.

  4. Ensure that the database is running with version 10.0 compatibility.

  5. Ensure that the database is in ARCHIVELOG mode

Answer: C,D

Question No: 373 – (Topic 11)

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

SQLgt; SELECT object_name, original_name, droptime FROM recyclebin;

Latesttests 2018 PDF and VCE

What would be the outcome of the precedent statement?

  1. It retrieves the latest version of the table from the recycle bin

  2. It retrieves the oldest version of the table from the recycle bin

  3. It retrieves the version of the table for which undo information is available

  4. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

Answer: A

Question No: 374 – (Topic 11)

Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?

  1. XID

  2. VERSIONS_PK

  3. VERSIONS_XID

  4. VERSIONS_UNIQUE

Answer: C

Question No: 375 – (Topic 11)

On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.

Which option must you use to check whether a flashback operation can recover the database to the specified time?

  1. Check the alert log file

  2. Query the V$FLASHBACK_DATABASE_LOG view

  3. Query the V$RECOVERY_FILE_DEST_SIZE view

  4. Query the V$FLASHBACK_DATABASE_STAT view

  5. Check the value assigned for the UNDO_RETENTION parameter

Answer: B Explanation:

To query the V$FLASHBACK_DATABASE_LOG to get the lowest SCN or the nearest TIMESTAMP to decide the recovery possibility.

Question No: 376 – (Topic 11)

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

  1. Point-in-time recovery

  2. Execute the ROLLBACK command with transaction number

  3. Flashback the database to before the transaction was committed

  4. Determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

Answer: D

Question No: 377 – (Topic 11)

A user named Arren is executing this query:

select table_name, operation, undo_sql from

flashback_transaction_query t, (select versions_xid as xid

from employees versions between scn minvalue and maxvalue

where employee_id = 123) e where t.xid = e.xid;

When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the employees table, you know that it is not the problem.

Which of the following SQL statements will correct this problem?

  1. GRANT SELECT ANY TRANSACTION TO ARREN;

  2. GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;

  3. GRANT SELECT_ANY_TRANSACTION TO ARREN;

  4. GRANT FLASHBACK TO ARREN;

  5. GRANT SELECT ANY VIEW TO ARREN;

Answer: A

Question No: 378 – (Topic 11)

Which of the following statements best describes Flashback Versions Query?

  1. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

  2. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.

  3. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

  4. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

Answer: D

Question No: 379 – (Topic 11)

Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes) on multiple rows of data in multiple tables. The manager would like a report showing the time, table name, and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list?

  1. Flashback Drop

  2. Flashback Query

  3. Flashback Transaction Query

  4. Flashback Versions Query

  5. Flashback Table

Answer: C

Question No: 380 – (Topic 11)

Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable.

What might be the problem? (Choose the best answers.)

  1. The application user has exceeded their undo quota.

  2. The FLASHBACK GUARANTEE option is set on the undo tablespace.

  3. The table is currently being queried by a Flashback Transaction Query operation.

  4. The table is currently being queried by a Flashback Versions Query operation.

  5. The RETENTION GUARANTEE option is set on the undo tablespace.

Answer: A

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

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

2018 Latesttests IT Certification PDF and VCE