You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
第1题:
In one of your online transaction processing (OLTP) applications, users are manipulating and querying a database table simultaneously. From the Segment Advisor, you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective?()
第2题:
You issued the following command to analyze the SCOTT.EMP table for block corruption: ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE; You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) How will you resolve the block corruption problem?()
第3题:
You work as a database administrator for Certkiller .com. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows: ERROR at Line 1: ORA-10635: Invalid segment ortablespacetype What could be the reason?()
第4题:
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?()
第5题:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
第6题:
The table is partitioned
The table name is wrong.
It is an index-Organized table (IOT)
The table is stored in locally managedtablespace.
The table is stored in atablespacewhere segment space is managed manually.
第7题:
the system change number
the locations of the redo log files
the locations of the datafiles
the physical location of all the database changes
第8题:
You must configure OMF in your database.
You must enable block change tracking feature in your database.
You must enable ROW MOVEMENT feature on the ORDERS table.
You must use the Flashback Version Query before using the Flashback Table feature.
第9题:
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
You cannot shrink the SCOTT.EMP table.
第10题:
by using the DBMS_REPAIR package
by using the DB_BLOCK_CHECKING parameter
by using the DBVERIFY utility
will not be completely resolved until the hardware fault is corrected
第11题:
INCLUDING DEPENDENCIES
INCLUDING DEPENDENCIES CASCADE
COMPACT
CASCADE
None of the above
第12题:
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
第13题:
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?()
第14题:
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
第15题:
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?()
第16题:
You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table: SQL> FLASHBACK TABLE ORDERS TO SCN 771513; What is the prerequisite to perform Flashback Table?()
第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题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE
第19题:
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
第20题:
The tablespace, DATA1, is not read-only.
The tablespace, DATA1, is not autoextensible.
The tablespace, DATA1, is not offline.
The segment space management for the tablespace, DATA1, is manual.
第21题:
You must enable the row movement on the SCOTT.EMP table.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
第22题:
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.
第23题:
REBUILD
CASCADE
TRUNCATE
ROW MOVEMENT
SHRINK SPACE COMPACT
SHRINK SPACE CASCADE