單項(xiàng)選擇題

While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：
a） high availability of data
b） faster primary key access to the table data
c） compact storage for the table
Which type of tables would you use to achieve these objectives？（）

A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables （IOTs）

你可能感興趣的試題

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

A. The time when the last flashback operation in your database was performed.
B. The time when the first flashback operation in your database was performed.
C. A list of flashback operations performed in your database using SCN and time.
D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.

單項(xiàng)選擇題

You database operates in ARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Tuesday， at 9：00 a.m. the current log sequence number was 369. Also， on Tuesday you lost the data file belonging to the SYSTEM tablespace and an achivelog file （sequence number 356） that contained redo entries between 8：00 a.m. and 8.30 a.m. With reference to this scenario， what would you do to recover the database？（）

A. Restore all the data files from last Sunday’s backup， and then perform a time-based recovery.
B. Restore all the data files from last Sunday’s backup， and then perform a cancel-based recovery.
C. Restore all the data files from last Sunday’s backup， and then perform a change-based recovery.
D. Restore only data files that belong to the SYSTEM tablespace from last Sunday’s backup， and then perform a complete recovery.

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

你可能感興趣的試題

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）

You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）