YouareworkingasaDBAatNetFxCorporation.Auser,Scott,ismaintainingtherecordsofalltheemployeesintheEMPLOYEEtable.Initially,thesalaryoftheemployee,’E0025’,was$1800.On1May2004,thesalaryoftheemployee,’E0025’,wasincreasedby$200.
Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’:
SQL>UPDATEEMPLOYEESETSALARY=2000
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnDecember1,2004,thesalaryoftheemployee,’E0025’,wasincreasedby$400.Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’:
SQL>UPDATEEMPLOYEESETSALARY=2400
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnJuly1,2005,thesalaryoftheemployee,’E0025’,wasincreasedby$500.Theuser,Scott,issuedthefollowingstatementtomodifytherecordoftheemployee,’E0025’
SQL>UPDATEEMPLOYEESETSALARY=2900
WHEREEMPNO=’E0025’;
SQL>COMMIT;
OnJuly5,2005,theHRmanageraskedyoutogeneratetheincrementreportoftheemployee,’E0025’,fortheperiodbetween1May2004and1July2005.Whichflashbackfeaturewillyouusetogeneratetheincrementreport?()
第1题
A.Theoptimizerstatisticsarecollectedautomatically.
B.Onlythetimedoperatingsystem(OS)statisticsandplanexecutionstatisticsarecollected.
C.TheOracleserverdynamicallygeneratesthenecessarystatisticsontablesaspartofqueryoptimization.
D.ThesnapshotsfortheAutomaticWorkloadRepository(AWR)arenotgeneratedautomatically.
E.SnapshotscannotbecollectedmanuallybyusingDBMS_WORKLOAD_REPOSITORYPACKAGE.
第2题
ONNECTandRESOURCErolesonly.Thedatabaseadministrator(DBA)grantsMGR_ROLEtotheuserSKDbyexecutingthecommand:SQL>GRANTMGR_ROLETOSKDWITHADMINOPTION;WhichstatementistrueabouttheuserSKDafterhe/sheisgrantedthisrole()
A.TheuserSKDcangrantonlytheMGR_ROLEroletootherusers,butnottheprivilegesinit.
B.TheuserSKDcanrevoketheMGR_ROLEonlyfromtheusersforwhomhe/sheisthegrantor.
C.TheuserSKDcangranttheprivilegesintheMGR_ROLEroletootherusers,butnotwithADMINOPTION.
D.TheuserSKDcangranttheprivilegesintheMGR_ROLEroletootherusers,butcannotrevokeprivilegesfromthem.
第3题
edinthetablebymistake.TheSCNnumberwas771513atthetimeofdeletion.YouissuedthefollowingstatementtoperformFlashbackTable:SQL>FLASHBACKTABLEORDERSTOSCN771513;WhatistheprerequisitetoperformFlashbackTable?()
A.YoumustconfigureOMFinyourdatabase.
B.Youmustenableblockchangetrackingfeatureinyourdatabase.
C.YoumustenableROWMOVEMENTfeatureontheORDERStable.
D.YoumustusetheFlashbackVersionQuerybeforeusingtheFlashbackTablefeature.
第4题
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
第5题
GRANTSELECT,INSERT,UPDATEONempTOscottWITHGRANTOPTION;TheuserSCOTTexecutesthiscommandtograntprivilegestotheuserJIM:SQL>GRANTSELECT,INSERT,UPDATEONhr.empTOjim;Now,theuserHRdecidestorevokeprivilegesfromJIMusingthiscommand:SQL>REVOKESELECT,INSERT,UPDATEONempFROMjim;WhichstatementistrueafterHRissuestheREVOKEcommand()
A.ThecommandfailsbecauseSCOTTstillhasprivileges.
B.ThecommandsucceedsandprivilegesarerevokedfromJIM.
C.ThecommandfailsbecauseHRcannotrevoketheprivilegesfromJIM.
D.ThecommandsucceedsandonlyHRhastheprivilegetoperformtheSELECT,INSERT,andUPDATEoperationsontheEMPtable.
第6题
A.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaareplacedintheRecycleBin,andtheobjectsthatarealreadyintheRecycleBinaredropped.
B.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaareplacedintheRecycleBin,andalltheobjectsintheRecycleBin,belongingtotheuserScott,arenotdropped.
C.Theuser,Scott,isdropped,alltheobjectsintheScott’sschemaarenotplacedintheRecycleBin,andtheobjectsintheRecycleBin,belongingtotheuser,Scott,arenotdropped.
D.Theuser,Scott,isdropped,alltheobjectsinScott’sschemaarenotplacedintheRecycleBin,andtheobjectsintheRecycleBinaredropped.
第7题
edatafromtheflatfilestructurestoanOracledatabasetooptimizetheapplicationperformance.Inyourdatabaseyouhaveclusteredtables.Whilemigratingthedata,youwanttohaveminimalimpactonthedatabaseperformanceandoptimizethedataloadoperation.WhichmethodwouldyouusetoloaddataintoOracledatabase?()
A.usetheexternaltablepopulation
B.usetheOracleDataPumpexportandimportutility
C.usetheconventionalpathdataloadofSQL*Loaderutility
D.usethedirectpathdataloadofOracleexportandimportutility
第8题
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
第9题
ofindtheundoSQLstatementsthatcanbeusedtoundothechangesmadetothedatabaseinthespecifictimeperiod.WhichpseudocolumnwillyouusetoperformtheFlashbackTransactionQuery?()
A.VERSIONS_STARTSCN
B.VERSIONS_STARTTIME
C.VERSIONS_XID
D.VERSIONS_OPERATION
第10题
vilegetotheSKDuserwithADMINOPTION.2:TheSKDusercreatesatable.3:TheSKDusergrantstheCREATETABLEsystemprivilegetotheHRuser.4:TheHRusercreatesatable.5:TheDBArevokestheCREATETABLEsystemprivilegefromSKD.Whichstatementistrueafterstep5isperformed()
A.ThetablecreatedbySKDisnotaccessibleandSKDcannotcreatenewtables.
B.ThetablescreatedbySKDandHRremain,butbothcannotcreatenewtables.
C.ThetablecreatedbyHRremainsandHRstillhastheCREATETABLEsystemprivilege.
D.ThetablecreatedbyHRremainsandHRcangranttheCREATETABLEsystemprivilegetootherusers.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!