最新的Oracle 1Z0-514免費考試真題

問題1

Which two statements correctly differentiate undo and redo data? (Choose two.)

A. Redo reverses a change, whereas undo re-creates a change.

B. Undo reverses a change, whereas redo re-creates a change.

C. Redo protects against inconsistent reads, whereas undo protects against data loss.

D. Undo protects against inconsistent reads, whereas redo protects against data loss.

正確答案: B,D

問題2

You issue the following command as a DBA:
SQL> SHUTDOWN
What would be the outcome of the above command?

A. It waits for the current transaction in each session to complete before disconnecting the sessions.

B. It rolls back the current transactions and disconnects a/I sessions.

C. It waits for all sessions to disconnect.

D. It causes the instance to abort.

正確答案: C

問題3

Which two statements are true regarding the Undo Retention Settings? (Choose two.)

A. Enabling Retention Guarantee ensures that long running queries and transactions do not fail.

B. Undo Retention indicates the time period or which uncommitted transaction data is retained.

C. Undo Retention Indicates the time period for which committed transaction data is retained.

D. Enabling Retention Guarantee ensures that only long-running Queries do not fail.

正確答案: A,C

問題4

Which three options correctly map SQL commands with their categories? (Choose thee)

A. MERGE: Data manipulation language

B. ALTER: Data manipulation language

C. DROP: data control language

D. REVOKE:Data control language

E. SELECT: transaction control

F. ROLLBACK: transition control

正確答案: A,D,F

問題5

Which two statements ore true regarding the- Database Configuration Assistant (DIKIA)? (Choose two.)

A. It can be used to change the configurations of a database only if it has been created using DBCA.

B. It can be used to delete Uu1 logical structure and physical files of a database.

C. It can be used to change the configurations of a database that has been created either manually or using DBCA.

D. It can be used to delete only the logical structure of a database.

正確答案: B,C

問題6

Evaluate the following command: $sqlplus / noblog
In which scenario would the above command execute successfully?

A. Either from a client or server only if the database instance is up and the command connectsthe session to the instance.

B. Eitherfrom the server or client even if the database instance is not up.

C. Either from a client or server only if the database instance is up but the command does not connect the session to the instance.

D. Only from the server if the database instance is not up.

正確答案: B

問題7

The RECYCLEBIN parameter is set to onfor your database. You drop a table, PRODUCTS, from the SCOTTschema.
Which two statements are true regarding the outcome of this action? (Choose two.)

A. The Flashback Drop feature can recover only the table structure.

B. All the related indexes and views are automatically dropped.

C. Only the related indexes are dropped whereas views are invalidated.

D. TheFlashback Drop feature can recover both the table structure and its data

正確答案: C,D

最新的Oracle Database 11g Essentials - 1Z0-514免費考試真題

聯系我們

站內鏈接

最新更新