单项选择题
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter(s) should be configured to perform a transportable tablespace import?()
A. DB_4K_CACHE_SIZE only
B. DB_8K_CACHE_SIZE only
C. DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
D. DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
E. SGA_TARGET and DB_4K_CACHE_SIZE
F. DB_CACHE_SIZE only
相关考题
-
多项选择题
WhichtwostatementsarecorrectregardingtheFlashbackVersionsQueryfeature?()
A. You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.
B. You can use this feature to identify the versions of V$ views.
C. You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.
D. You can use this feature for a table only if row movement is enabled for the table.
E. You can use this feature to identify the versions of external and fixed tables. -
多项选择题
YouexecutedthefollowingFLASHBACKTABLEcommand:FLASHBACKTABLEempTOTIMESTAMP(’11:45’,’hh12:mi’);Whichtwostatementsarecorrect?()
A. The FLASHBACK TABLE statement will not be written to the alert log file.
B. The EMP table that was dropped by mistake from the database will be restored.
C. The changes made to the EMP table since the specified time will be undone.
D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
E. The FLASHBACK TABLE statement will be executed within a single transaction.
F. The list of transactions that have modified the EMP table since the specified time will be displayed. -
单项选择题
EverySunday,consistentbackupsareperformedonyourdatabase.Becauseofausererror,you performedanincompleterecoveryonTuesdayandopenedthedatabasewiththeRESETLOGSoption.AusererroroccursagainonThursday,whichnecessitatesanincompleterecovery.Sunday’sbackupisthemostrecentbackupavailable.Whatwouldyoudointhisscenario?()
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
C. restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
D. restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
