单项选择题
View the exhibit and examine the TRANS table's storage information.
After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command?（）
A. An error is produced.
B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
相关考题
-
多项选择题
Which two statements are true about a job chain?（）
A. A job chain can contain a nested chain of jobs.
B. The jobs in a job chain cannot have more than one dependency.
C. A job of the CHAIN type can be run using event-based or time-based schedules.
D. The jobs in a job chain can be executed only by using the events generated by the Scheduler -
单项选择题
Note the following statements that use flashback technology: 1. FLASHBACK TABLE <table> TO SCN <scn>; 2. SELECT * FROM <table> AS OF SCN 123456; 3. FLASHBACK TABLE <table> TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>; 5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5 -
单项选择题
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）
A. Disk mirroring and striping would be done automatically
B. The database files would be managed by the operating system's file system
C. DBCA would not save the database files by using Optimal File Architecture (OFA)
D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization
