Examine the description of the EMPLOYEES table:EMP_ID NUMBER（4) NOT NULLLAST_NAME VARCHAR2

efinitionlanguage（DDL）command：SQL>SELECTenameFROMemp2WHEREjob=’CLERK’FORUPDATEOFempno；SCOTThasopenedanothersessiontoworkwiththedatabaseinstance.WhichthreeoperationswouldwaitwhenissuedinSCOTT’ssecondsession（）

A.LOCKTABLEempINSHAREMODE；

B.LOCKTABLEempINEXCLUSIVEMODE；

C.UPDATEempSETsal=sal*1.2WHEREjob=MANAGER；

D.INSERTINTOemp（empno，ename）VALUES（1289，’Harry’）；

E.SELECTenameFROMempWHEREjob=’CLERK’FORUPDATEOFempno；

A.QuerytheV$TRANSPORTABLE_PLATFORMSviewinthesourcedatabasetodetermineifthe intendeddestinationislisted.

B.Verifythattherearenorestrictionsorlimitationsthatthesourceordestinationdatabasemayencounter.

C.VerifythatthesourceanddestinationhavethesameOracleversioncriticalupdates，patch-setversion，andpatch-setexceptions.

D.Determineifyouwillperformtheconversiononthesourceordestinationplatform.

E.Noneoftheabove.

D_nnNOTNULL，COUNTRY_NAMEVARCHAR2（20），CURRENCY_NAMEVARCHAR2（20），CONSTRAINTCOUNTRY_ID_PKPRIMARYKEY（COUNTRY_ID））ORGANIZATIONINDEX；Inwhichtablespacewillthemappingtablebecreated？（）

A.SYSTEMtablespace

B.SYSAUXtablespace

C.Undotablespace

D.ThetablespaceoftheIndexOrganizedTable（IOT）

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

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;

A.YoumustenabletherowmovementontheSCOTT.EMPtable.

B.YoumustdefinethetablespaceoftheSCOTT.EMPtableforautomaticsegmentspacemanagement.

C.YoumustusetheCASCADEclauseintheALTERTABLESHRINKSPACEstatement.

D.YoumustusetheCOMPACTclauseintheALTERTABLESHRINKSPACEstatement.

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

rackuserswhoareperformingthetransactionsandthevaluesusedinthetransactions.Youalsoplantotransferthesevaluestoanothertableforanalysis.Howwouldyouachievethis（）

A.byusingtriggers

B.byusingDataPump

C.byusingexternaltables

D.byusinganonymousPL/SQLblocks

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.

（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.