题目内容（请给出正确答案）

[主观题]

Youareusingflatfilesasthedatasourceforoneofyourdatawarehousingapplications.Youplantomoveth

edatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata，youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase？（）

A.usetheexternaltablepopulation

B.usetheOracleDataPumpexportandimportutility

C.usetheconventionalpathdataloadofSQL*Loaderutility

D.usethedirectpathdataloadofOracleexportandimportutility

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“Youareusingflatfilesasthedatas…”相关的问题

第1题

You are using Recovery Manager (RMAN) with a recovery catalog to back up your production d

atabase. Thebackups and the archived redo log files are copied to a tape drive on a daily basis.Because of media failure,you lost your production database completely along with the recovery catalog database.You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task:1) Restore an autobackup of the server parameter file.2) Restore the control file3) Start the target database instance4) Mount the database5) Restore the data files6) Open the database with RESETLOGS option7) Recover the data files8) Set DBID for the target databaseWhich option illustrates the correct sequence that you must use?（）

A.8，1，3，2，4，5，7，6

B.1，8，3，4，2，5，7，6

C.1，3，4，2，8，5，6，7

D.1，3，2，4，6，5，7，8

点击查看答案

第2题

YouaremaintainingyourOLTPdatabaseinOracle10g.YouareperformingtheFlashbackTransactionQueryt

ofindtheundoSQLstatementsthatcanbeusedtoundothechangesmadetothedatabaseinthespecifictimeperiod.WhichpseudocolumnwillyouusetoperformtheFlashbackTransactionQuery？（）

A.VERSIONS_STARTSCN

B.VERSIONS_STARTTIME

C.VERSIONS_XID

D.VERSIONS_OPERATION

点击查看答案

第3题

Examinethefollowingstepsperformedonadatabaseinstance：1：TheDBAgrantstheCREATETABLEsystempri

vilegetotheSKDuserwithADMINOPTION.2：TheSKDusercreatesatable.3：TheSKDusergrantstheCREATETABLEsystemprivilegetotheHRuser.4：TheHRusercreatesatable.5：TheDBArevokestheCREATETABLEsystemprivilegefromSKD.Whichstatementistrueafterstep5isperformed（）

A.ThetablecreatedbySKDisnotaccessibleandSKDcannotcreatenewtables.

B.ThetablescreatedbySKDandHRremain，butbothcannotcreatenewtables.

C.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.

D.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.

点击查看答案

第4题

YouareusingtheBlockMediaRecoveryfeaturetorecovertheblocksthataremarkedcorruptsincethelastbackup.Whichviewwillyouquerytodisplayinformationaboutthedatablocksthataremarkedcorruptsincethelastbackup？（）

A.V$BACKUP_CORRUPTION

B.V$COPY_CORRUPTION

C.V$DATABASE_BLOCK_CORRUPTION

D.RC_BACKUP_CORRUPTION

点击查看答案

第5题

YouaremaintainingthePRODdatabaseofTeleSoftCorporation.YouhaveinitializedthefollowingDB_BLOCK_CHECKINGparameterintheinit.orafile：DB_BLOCK_CHECKING=TRUE；Whatwillbetheresultofsettingthisparameter？（）

A.OnlydatablocksoftheSYSTEMtablespacewillbechecked.

B.OnlydatablocksoftheSYSAUXtablespacewillbechecked.

C.Achecksumwilloccuronlyonthecheckpoint.

D.Achecksumwilloccureverytimeablockismodified.

点击查看答案

第6题

Review the definition of the phone_list view.CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= ‘r

oot‘@localhost‘ SQL SECURITY DEFINER VIEW ‘phone_list‘ AS SELECTe . id as id ‘e . first_name AS ‘first_name‘ ‘e . last_name AS ‘last_name‘ ‘coalesce ( ph1.phone_no, ‘ – ‘) AS ‘office_no‘ ‘coalesce (ph2 .phone_no, ‘ – ‘) AS ‘cell_no‘ FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = ‘office‘ LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = ‘mobile‘The tables employees and employee_phone are InnoDB tables;all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec)Which method can you use to change the cell_no value to ‘555-8888‘ for John Doe?（）

A.INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, ‘555-8888‘,‘mobile‘)

B.UPDATE phone_list SET cell_name ‘555-8888‘ WHERE first_name= ‘John‘ and last_name= ‘Doe‘

C.DELETE FROM phone_list WHERE first_name= ‘John‘ and last_name= ‘Doe‘; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES (‘John‘ , ‘Doe‘ , ‘x1234‘ , ‘555-8888)

D.UPDATE employee_phone SET phone_no= ‘555-8888‘ where emp_id=1

点击查看答案

第7题

Whichtwostatementsaretrueabouttheprimarykeyconstraintinatable？（）

A.Itisnotpossibletodisabletheprimarykeyconstraint.

B.Itispossibletohavemorethanoneprimarykeyconstraintinasingletable.

C.Theprimarykeyconstraintcanbereferredbyonlyoneforeignkeyconstraint.

D.Theprimarykeyconstraintcanbeimposedbycombiningmorethanonecolumn.

E.Thenon-deferrableprimarykeyconstraintcreatesanuniqueindexontheprimarykeycolumnifitisnotalreadyindexed.

点击查看答案

第8题

ouhavebackedupyourdatabasetwicewithoutconnectingtotherecoverycatalog.Whatcommanddoyouissuetotransferthecontrol-filemetadatatotherecoverycatalog?（）

A.synchcatalog

B.resynccatalog

C.replicatecatalog

D.updatecatalog

E.restorecatalog

点击查看答案

第9题

ThedatafilesofyourdatabaseareASMfiles.YouareperformingacheckfordatafileblockcorruptionbyusingtheDBVERIFYutility.WhatisaprerequisiteforcheckingblockcorruptiononanASMdatafilebyusingtheDBVERIFYutility？（）

A.Theblockchangetrackingfeaturemustbeenabled.

B.OMFmustbeconfiguredonyourdatabase.

C.ThedatabasemustbeinARCHIVELOGmode.

D.AUSERIDmustbesupplied.

点击查看答案

第10题

Youareworkingonthe24X7databasewithhightransactionvolume，toensurefasterinstancerecoveryonyo

urdatabaseyousettheFAST_START_MTTR_TARGETinitializationparametertoaverylowvalue.Whateffectitwillhaveonthedatabase？（）

A.Thedatabaseperformancewouldbeenhanced.

B.Theredologfileswouldbegetfilledmorefrequently.

C.Theoveralldatabaseperformancewouldbedegraded.

D.Themeantimetorecover（MTTR）wouldbeincreased.

点击查看答案