A: A INCLUDING DEPENDENCIES
B: B INCLUDING DEPENDENCIES CASCADE
C: C COMPACT
D: D CASCADE
E: E None of the above
举一反三
- 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？（） A: You must enable the block change tracking feature. B: You must have enable the flashback feature. C: You must use the OMF in your database. D: You must define the tablespace of the SCOT E: EMP table for automatic segment space management.
- 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？（） A: You must enable the block change tracking feature. B: You must have enable the flashback feature. C: You must use the OMF in your database. D: You must define the tablespace of the SCOTEMP table for automatic segment space management.
- You work as a database administrator for Supportcenter.cn. 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： A: The table is partitioned B: The table name is wrong. C: It is an index-Organized table （IOT） D: The table is stored in locally managedtablespace. E: The table is stored in atablespacewhere segment space is managed manually.
- What should you avoid in any lead? A: Burying the news B: Starting with a question C: Including too much information D: All of the above
- In which scenario will you use the Flashback Transaction Query feature？（） A: when you want to restore an important table that is dropped from the Recycle Bin B: when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: when you want to restore a dropped user’s schema D: when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
内容
- 0
In which scenario will you use the Flashback Transaction Query feature？（） A: A when you want to restore an important table that is dropped from the Recycle Bin B: B when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C: Cwhen you want to restore a dropped user’s schema D: D when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period
- 1
6. When you take the __________ into consideration, you’d better take a larger size. (shrink)
- 2
You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table. Which CREATE statement should you use？（） A: A B: B C: C D: D
- 3
You can find information using Web-based ____. A: indexes B: lists of links C: links provided on the pages of wikis D: all of the above
- 4
In which scenario will you perform an incomplete recovery？（） A: when a table is dropped and stored in the Recycle Bin B: when all the control files are deleted C: when a member of a multiplexed redo log group is dropped D: when you are required to recover a table to its previous state