ALTER DATABASE
SET TRANSACTION
ALTER ROLLBACK SEGMENT
ALTER TABLE
第1题:
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature?()
第2题:
You work as a database administrator for Certkiller .com. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
第3题:
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? ()
第4题:
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()
第5题:
You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
You need to increase the size of the undo tablespace.
The undo tablespace is not set to auto-extend.
You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
第6题:
The extents in the undo tablespace retain data until the next full database backup.
The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.
第7题:
You must use automatic undo management in the database.
You must configure OMF in your database.
You must configure ASM for storing the datafiles.
You must multiplex the online redo log file.
第8题:
The extents in undo tablespace retain data until the next full database backup.
The extents containing committed data in the undo tablespace are never overwritten.
The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
第9题:
You must enable the block change tracking feature.
You must have enable the flashback feature.
You must use the OMF in your database.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
第10题:
The database will not start.
The database will start but will not retain the undo data in the undo segment.
The database will start, and the undo segment will contain the undo data for at least one hour.
The database will start, and the undo segment will retain the undo data for at least 15 minutes.
第11题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
第12题:
Set the UNDO_RETENTION parameter to AUTO.
Create an initial undo segment in undotablespace.
Set the UNDO_RETENTION parameter to 900 or more
Set the initialization parameter UNDO_MANAGEMENT to AUTO
Set the UNDO_MANAGEMENT parameter to the name of an undotablespace
第13题:
You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()
第14题:
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this statement have on the database?()
第15题:
Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee: SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE; What effect would this command have on the database()
第16题:
You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking feature?()
第17题:
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
第18题:
VERSIONS_STARTSCN
VERSIONS_STARTTIME
VERSIONS_XID
VERSIONS_OPERATION
第19题:
The statement will be executed successfully, and a new time zone will be set for the database.
The statement will be executed successfully, but a new time zone will not be set for the database.
The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
第20题:
Enable supplemental logging for the database.
Specify undo retention guarantee for the database
Create Flashback Data Archive in the tablespace where the tables are stored.
Create Flashback Data Archive and enable Flashback Data Archive for specific tables
第21题:
3 hours
6 months
until last year
until last commit
until the point when the undotablespacewas refreshed
until the database is shut down and the memory erased
第22题:
Enable supplemental logging for the database.
Specify undo retention guarantee for the database
Create Flashback Data Archive in the tablespace where the tables are stored.
Create Flashback Data Archive and enable Flashback Data Archive for specific tables
第23题:
The alter database archivelog command will fail
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode
The alter database archivelog command will succeed
The alter database archivelog command will ask if you want to make the database consistent first
There is no alter database archivelog command. The correct command is alter database alterlogging