单项选择题
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）
相关考题
-
单项选择题
Youexecutedthefollowingqueryinyourdatabase：SELECToldest_flashback_scn，oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG；Whatwouldyoudeterminefromthe 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. -
单项选择题
YoudatabaseoperatesinARCHIVELOGmodeanduser-managedconsistentbackupsareperformedeverySundaynight.OnTuesday，at9：00a.m.thecurrentlogsequencenumberwas369.Also，onTuesdayyoulostthedatafilebelongingtotheSYSTEMtablespaceandanachivelogfile（sequencenumber356）thatcontainedredoentriesbetween8：00a.m.and8.30a.m.Withreferencetothisscenario，whatwouldyoudotorecoverthedatabase？（）
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. -
多项选择题
Youlostadatafilethatbelongstoanindextablespaceinyourdatabase，whichoperatesinARCHIVELOGmode.Lossofthedatafileresultedinincreasedresponsetimeonyourqueries.Whichtwooptionswouldyouusetosolvethisproblem？（）
A. Restore the lost data file from the backup， and then flash back the database.
B. Restore the data file pertaining to index tablespace， and then recover the tablespace.
C. Restore all the data files， and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files， and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.
