网友您好，请在下方输入框内输入要搜索的题目：

搜题

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

[主观题]

Examine the data in the EMPLOYEES table.EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPL

OYEE_ID101 Smith 20 120 SA_REP 4000102 Martin 10 105 CLERK 2500103 Chris 20 120 IT_ADMIN 4200104 John 30 108 HR_CLERK 2500105 Diana 30 108 IT_ADMIN 5000106 Smith 40 110 AD.ASST 3000108 Jennifer 30 110 HR_DIR 6500110 Bob 40 EK_DIR 8000120 Revi 20 110 SA_DIR 6500On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.Evaluate this DELETE statement:DELETE employee_id, salary, job_idFROM employeesWHERE dept_id = 90;Why does the DELETE statement fail when you execute it？（）

A. There is no row with dept_id 90 in the EMPLOYEES table.

B. You cannot delete the JOB_ID column because it is a NOT NULL column.

C. You cannot specify column names in the DELETE clause of the DELETE statement.

D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

查看答案

更多“Examine the data in the EMPLOYEES table.EMPLOYEESEMP_NAME DEPT_ID MGR_ID JOB_ID SALARYEMPL”相关的问题

第1题

IdentifyfourfeaturesofWebLogicthatprovidevalueaboveandbeyondasimpleJavaEEcontainer.（）

A.ActiveGridLinkforRAC

B.supportforenterpriseWebServicesstandardsbeyondJavaEEspecification

C.IntegrationwithEnterpriseManager

D.marketleadingperformance

E.JavaEE6SpecificationSupport

F.JavaSE7support

点击查看答案

第2题

Examine the commands executed to monitor database operations:$> conn sys oracle/oracle@

prod as sysdbaSQL > VAR eid NUMBERSQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);Which two statements are true?（）

A. Database operations will be monitored only when they consume a significant amount of resource.

B. Database operations for all sessions will be monitored.

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning.

D. Only DML and DDL statements will be monitored for the session.

E. All subsequent statements in the session will be treated as one database operation and will be monitored.

点击查看答案

第3题

GivenWhich three are valid on line？（）

A.final

B.static

C.native

D.public

E.private

F.abstract

G.protected

点击查看答案

第4题

Whichtwostatementsaretrueaboutcheckpointing（）

A.Thecheckpointfrequencydecreaseswiththesmallerredologfilesize.

B.Itensuresthatallcommitteddataiswrittentothedatafilesduringnormalshutdown.

C.Thefrequentfullcheckpointinadatabasecancausetheoveralldegradationofthedatabaseperformance.

D.ItpromptstheCheckpoint（CKPT）processtowritedatatothedatafilesandredoinformationtotheonlineredologfiles.

点击查看答案

第5题

Youlosttheindextablespaceinyourdatabase.Youdecidedtore-createtheindextablespaceandtheindexesinthetablespace.Whatmethodscanyouusetore-createtheindexes？（）

A.SQLscripts

B.RecoveryManager（RMAN）script

C.DataPump

D.SQL*Loader

E.Flashbackdatabase

点击查看答案

第6题

Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）

A. System privileges apply only to the PDB in which they are used.

B. Local users cannot use local system privileges on the schema of a common user.

C. The granter of system privileges must possess the set container privilege.

D. Common users connected to a PDB can exercise privileges across other PDBs.

E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.

点击查看答案

第7题

Thehumanresourcesdepartmentrequestedanemployeereporttohighlightthoseemployeeswhoareduefor3

0days6monthsand1yearevaluation.Thehigher_datafieldshoulddisplaybluetextfor30daysemployee,aredtextfor6monthsemployeesandagreentextforoneyearemployees.Youcreatedaformattriggeronthehigher_datafieldtohandlethistask.Whatwillhappeniftheformattriggerreturnsafalsevalue?（）

A.Thereportexecutionwillbehalted.

B.Thehigher_datafilewillnotbedisplayed.

C.Therecordwillnotbedisplayed.

D.Nothingwillhappen.

点击查看答案

第8题

Youareworkingona24x7（available24hoursperday，7daysperweek）productiondatabase.Anoperatingsystem（OS）userdeletesthealertlogfileaccidentally.Whichstatementinthisscenarioistrue？（）

A.Thedatabasecrashes.

B.TheDBAneedstore-createthefile.

C.Thefilegetsre-createdautomatically.

D.Thefilegetsrestoredautomaticallyfromthelastbackup.

E.TheDBAneedstoperformacompletedatabaserecovery.

F.TheDBAneedstoperformanincompletedatabaserecovery.

点击查看答案

第9题

FromtheV$SESSION_LONGOPSview，youfindthatsomeofthedatabaseusershavelong-runningqueriesthatc

onsumealotofCPUtime.Thiscausesperformanceproblemsforotherusersinthedatabase，whohavemuchshorterqueries.YouwouldliketomakesurethattheuserswithlargequeriesdonotusealltheCPUtime，butyoustilldonotwanttoterminatethemwithanerrormessage.Whichmethodwouldyoufollowtoachievethis？（）

A.settheCPUtimepercallintheusersprofile

B.settheCPUtimepersessionintheusersprofiles

C.settheTIMED_STATISTICSparametertoTRUEintheparameterfile

D.settheCPUlevelsfortheusers’groupusingResourceManager

点击查看答案

第10题

Younoticethattheperformanceofthedatabasehasdegradedbecauseoffrequentcheckpoints.Whichtwoactionsresolvetheissue（）

A.Disableautomaticcheckpointtuning.

B.Checkthesizeoftheredologfilesizeandincreasethesizeifitissmall.

C.SettheFAST_START_MTTR_TARGETparameteraspertheadvicegivenbytheMTTRAdvisor.

D.Decreasethenumberofredologmembersiftherearemorethanoneredologmembersavailableineachredologgroup.

点击查看答案

账号：尚未登录

登录没有账号？去注册

我要提问

联系客服

购买搜题卡

题库练习

课程学习

功能	扣减规则
功能	基础费（查看答案）	加收费（AI功能）
文字搜题、查看答案	1/每题	0/每次
语音搜题、查看答案	1/每题	2/每次
单题拍照识别、查看答案	1/每题	2/每次
整页拍照识别、查看答案	1/每题	5/每次