單項(xiàng)選擇題

You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）

A.3 hours
B.6 months
C.until last year
D.until last commit
E.until the point when the undotablespacewas refreshed
F.until the database is shut down and the memory erased

你可能感興趣的試題

單項(xiàng)選擇題

The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.
What kind of information is stored is stored in this file？（）

A.OracleSIDsonly
B.Oracle homes only
C.Oracle install timestamp
D.Oracle inventory pointer files
E.Oracle database creation timestamp
F.OracleSIDsand Oracle homes only
G.OracleSIDs， Oracle homes and flag for auto startup

單項(xiàng)選擇題

You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.
Which objective will be achieved by this setting？（）

A.The Oracle kernel will be placed in this location.
B.The Oracle software will be placed in this location.
C.The server parameter file （SPFILE） will be placed in this location.
D.The database files will be placed in this location， if not specified explicitly.
E.The location will be considered for the base of Oracle Managed Files （OMF）.
F.The location will be considered for the base of Optimal Flexible Architecture （OFA）.

You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？ （）

你可能感興趣的試題

The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）

You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）

The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.
What kind of information is stored is stored in this file？（）

You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.
Which objective will be achieved by this setting？（）