单项选择题
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.
While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()
A.use the external table population
B.use the Oracle Data Pump export and import utility
C.use the conventional path data load of SQL*Loader utility
D.use the direct path data load of Oracle export and import utility
相关考题
-
单项选择题
YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning,mediafailureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation?()
A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancelbased recovery
E.restore the entire database from the most recent backup and start the instance and open the database -
单项选择题
WhichstatementistrueaboutthelossofsystemcriticaldatafilesinARCHIVELOGmode?()
A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically; the database remains open.
D.The data files can be recovered to the time of the most recent backup. -
多项选择题
Inyourdatabase,theLogWriter(LGWR)processisunabletowritetoamemberofacurrentredologgroupduetoread/writefailure.Whichtwoeffectswouldyouseeinyourdatabase?()
A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
