单项选择题

Youhavealargeamountofhistoricaldatainanoperatingsystemfile.Someanalystsinyourorganizationneedtoquerythisdata.Thefileistoolargetoloadintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccomplishthetask？（）
A.Upgradethehardware/memorytoaccommodatethedata.
B.LoadthedataintoyourdatabasebyusingthePARALLELclause.
C.GiveanalystsDBAprivilege，sothattheycanqueryDBA_EXTERNAL_TABLES.
D.Useanexternaltablesoyoucanhavethemetadataavailableinyourdatabase，butleavethedataintheoperatingsystemfiles.

A.Someanalystsinyourorganizationneedtoquerythisdata.Thefileistoolargetoloadintoyourcurrentdatabase.Whichisthemosteffectivemethodtoaccomplishthetask？（）
A.Upgradethehardware/memorytoaccommodatethedata.
B.LoadthedataintoyourdatabasebyusingthePARALLELclause.
C.GiveanalystsDBAprivilege，sothattheycanqueryDBA_EXTERNAL_TABLES.
D.Useanexternaltablesoyoucanhavethemetadataavailableinyourdatabase，butleavethedataintheoperatingsystemfiles.

你可能感兴趣的试题

问答题

Youneedtoensurethatonlyauthorizedpersonnelareabletomodifystudentgrades.Whichdesktopenvironmentorenvironmentsshouldyouuse?（）

A.WindowsXPProfessional
B.Windows2000Professional
C.Windows98withActiveDirectoryclientinstalled
D.WindowsNTWorkstation4.0withthelatestservicepackandActiveDirectoryclientinstalled

单项选择题

Youhaveperformedanincompleterecoverybecausesomeimportantuser’sschemaisdroppedandpurgedfromtheRecycleBin.Thecurrentlogsaresequenced1005and1006.Afterperformingtherecovery，youissuedthefollowingstatement：SQL>ALTERDATABASEOPENRESETLOGS；Whatwillbetheresultantlogsequencenumbers？（）
A.0and1
B.1and2
C.1005and1006
D.1006and1007

A.Thecurrentlogsaresequenced1005and1006.Afterperformingtherecovery，youissuedthefollowingstatement：SQL>ALTERDATABASEOPENRESETLOGS；Whatwillbetheresultantlogsequencenumbers？（）
A.0and1
B.1and2
C.1005and1006
D.1006and1007