A.QuerytheV$TRANSPORTABLE_PLATFORMSviewinthesourcedatabasetodetermineifthe intendeddestinationislisted.
B.Verifythattherearenorestrictionsorlimitationsthatthesourceordestinationdatabasemayencounter.
C.VerifythatthesourceanddestinationhavethesameOracleversioncriticalupdates,patch-setversion,andpatch-setexceptions.
D.Determineifyouwillperformtheconversiononthesourceordestinationplatform.
E.Noneoftheabove.
第1题
D_nnNOTNULL,COUNTRY_NAMEVARCHAR2(20),CURRENCY_NAMEVARCHAR2(20),CONSTRAINTCOUNTRY_ID_PKPRIMARYKEY(COUNTRY_ID))ORGANIZATIONINDEX;Inwhichtablespacewillthemappingtablebecreated?()
A.SYSTEMtablespace
B.SYSAUXtablespace
C.Undotablespace
D.ThetablespaceoftheIndexOrganizedTable(IOT)
第2题
A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
E. The STATE column of the job table will be set to COMPLETED for the job
第3题
oyees in the EMP table. The EMP table contains these columns:LAST NAME VARCNAR2(35) NOT NULLSALARY NUMBER(9,2) NOT NULLCOMMISION_PCT NUMBER(4,2)Which statement ensures that a value is displayed in the calculated columns for all employees? ()
A. SELECT last_name, 12*salary* commission_pct FROM emp;
B. SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C. SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D. SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
第4题
A.YoumustenabletherowmovementontheSCOTT.EMPtable.
B.YoumustdefinethetablespaceoftheSCOTT.EMPtableforautomaticsegmentspacemanagement.
C.YoumustusetheCASCADEclauseintheALTERTABLESHRINKSPACEstatement.
D.YoumustusetheCOMPACTclauseintheALTERTABLESHRINKSPACEstatement.
第5题
A.All system users have access to the MySQL server via—login path local
B.login-path can be used only for MySQL servers running on a local machine
C.login-path allows you to provide login credentials without passing clear text passwords on the command line
D.When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later
第6题
rackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Youalsoplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis()
A.byusingtriggers
B.byusingDataPump
C.byusingexternaltables
D.byusinganonymousPL/SQLblocks
第7题
A. They consist of one or more Scheduler programs.
B. They are used to implement dependency scheduling.
C. They are used to implement time-based scheduling.
D.They are used to implement event-based scheduling.
E.None of the above.
第8题
(PROTOCOL=TCP)(HOST=10.156.24.216)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.oracle.com)))TheTNSPINGcommandexecutessuccessfullywhentestedwithORCLbutyouarenotabletoconnecttothedatabaseinstancewiththefollowingcommand:SQL>CONNECTscott/tiger@orclWhatcouldbethereasonforthis?()
A.Thelistenerisnotrunningattheserver.
B.TheTNS_ADMINenvironmentalvariableissettoawrongvalue.
C.Theorcl.oracle.comdatabaseserviceisnotregisteredwiththelistener.
D.TheDEFAULT_DOMAINparameterissettoawrongvalueintheSQLNET.ORAfile.
第9题
A.Thedatabasemustbeinread-writemode.
B.Thedatabasemusthavenoexternalfiles.
C.Thedatabasemustopeninread-onlymode.
D.Thedatabasemustbemountedbutnotopened.
第10题
ethedroptableoperationisinprogress,userBexecutesthefollowingcommandonthesametable:SQL>DELETEFROMtransWHEREtr_type=’SL’;WhichstatementistrueregardingtheDELETEcommand()
A.Itfailswitha"ResourceBusy"error.
B.ItdeletestherowssuccessfullybecausethetableislockedinSHAREmode.
C.ItfailstodeletetherecordsbecausethetableislockedinEXCLUSIVEmode.
D.ItdeletestherowssuccessfullybecausethetableislockedinSHAREROWEXCLUSIVEmode.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!