A. fixed tables
B. heap tables
C. external tables
D. temporary tables
E. Index-Organized Tables (IOTs)
您可能感兴趣的试卷
你可能感兴趣的试题
A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
A. TEST_TBS is a small file tablespace.
B. TEST_TBS is a bigfile tablespace (BFT).
C. TEST_TBS is the default temporary tablespace.
D. TEST_TBS is a dictionary-managed tablespace.
A. point-in-time recovery
B. execute the ROLLBACK command with transaction number
C. flashback the database to before the transaction was committed
D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery
A. SQL Repair Advisor
B. SQL Optimizer
C. SQL Access Advisor
D. SQL Tuning Advisor SQL
A. setting idle timeout limits on resource plans
B. saving storage space by using compressed backup sets
C. creating jobs that will run automatically at a scheduled time
D. assigning priorities to jobs to manage access to system resources
E. creating alerts to perform notification when tablespaces are low on available space resources
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;
A. AWR baselines are always created as repeating baselines.
B. AWR baselines can be created on the basis of two time values.
C. AWR baselines are always created with infinite expiration duration.
D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
A. ASMB
B. PMON
C. RBAL
D.SMON
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?()
A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
B.One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.
Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab
2.$ORACLE_HOME/dbs/oranfstab
3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?()
A. 1, 2, 3
B. 3, 2, 1
C. 2, 3, 1
D. 1, 3, 2
最新试题
You executed the following commands in a database session:What could have caused the recycle bin to clean up?()
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.Which method must you use to recover the lost data?()
Examine the parameter setting in your database:Which statement is correct about the database?()
Which two commands never trigger an implicit rebalancing within the disk group?()
To enable faster incremental backups, you enabled block change tracking for the database.Which two statements are true about the block change tracking file?()
Which two statements are true about a job chain?()
Examine the following RMAN script:Which statement describes the purpose of the script?()
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()