COMP-2142022 Fall学习通超星课后章节答案期末考试题库2023年

COMP_2142022Fall学习通超星课后章节答案期末考试题库2023年____arenamedmemoryareasthatholdvaluestoallowtheretrievalandmanipulationofvaluesinaprogram.

参考答案:

Variables

____________________areusedforsituationsinwhichweneedtorepeatalineorlinesofcodewithinourblock.

参考答案:

Loops

Aprocedureandfunctionarenamedprogramunitsthatarecalledtoperformaspecifictask.

参考答案:

对

Aprogramminglanguageallowstheactionsofanendusertobeconvertedintoinstructionsthatacomputercanunderstand.

参考答案:

对

Accordingtothestatementblockabove,whatvalueisstoredinthevariabletotal_amt?

参考答案:

32

Allofthefollowingareconsideredtobeprogramminglanguages,except____.

参考答案:

Oracle

Aneventcanrangefromauseraction,suchasclickingthebuttononthescreen,toatableupdatestatementthatautomaticallycallsadatabasetrigger.

参考答案:

对

Assignmentstatementsareusedtoputorchangethevaluesofvariables.

参考答案:

对

Byindicatinganumericrange,the____________________dictatesexactlyhowmanytimestheloopshouldrunintheopeningLOOPclause.

参考答案:

FORloop

clausecanbeusedtorestrictorfilterthegroupsreturnedbyaquerybasedonagroupfunction?

参考答案:

having

Describethethree-tierapplicationmodel.

参考答案:

Thethree-tiermodelisgrowinginpopularitybecauseitattemptstoeaseapplicationmaintenanceandenablesthesupportoflargernumbersofusers.Inthisscenario,theuserinterfaceistypicallypresentedviaaWebbrowserandisoftenreferredtoasathinclient.Applicationcodeisnotloadedontotheclientmachine;alltheapplicationcodenowresidesonanapplicationserver,whichisalsoreferredtoasthemiddletier.Threelayersnowexistinthismodel:theuserinterface,theapplicationserver,andthedatabaseserver.TheOracleapplicationserverallowsthedeploymentofOracleFormsapplicationsviatheWeb.Theapplicationservercontainstheuserinterfaceandprocessinglogic,whichtogether,respondtouseractionsand,inturn,sendappropriatecodetothedatabaseserverforprocessing.

Determinewhichordershadahighertotalamountduethanorder1008.

参考答案:

SELECTCOUNT(*)

FROMbooksWHEREcategory='COOKING';SELECTMAX(retail)FROMbooksJOINbookauthorUSING(isbn)JOINauthorUSING(authorid)WHERElname='WHITE'

ANDfname='LISA';SELECTtitle,retailFROMbooksWHEREretail<(SELECTAVG(retail)FROMbooks);SELECTorder#FROMordersWHEREshipstate=(SELECTshipstateFROMordersWHEREorder#=1014);

SELECToi.order#,SUM(oi.quantity*oi.paideach)FROMorderitemsoi,booksbWHEREoi.isbn=b.isbnGROUPBYoi.order#HAVINGSUM(oi.quantity*oi.paideach)>

(SELECTSUM(oi.quantity*oi.paideach)

FROMorderitemsoi,booksbWHEREoi.isbn=b.isbnANDoi.order#=1008);

END;

参考答案:

错

groupfunctioncanbeusedtoperformacountthatincludesNULLvalues?

参考答案:

count(*)

Ifyouhaveapieceofcodethathasthepotentialofbeingusedbyvariousapplications,savingthiscodeontheserverallowsittobesharedbyseveralapplications.

参考答案:

对

In

clauseshouldyouincludethecondition"pubid=4"torestricttherowsprocessedbyaquery?

参考答案:

where

Oracle12cautomaticallycreatesanindexforwhichtypeofconstraints?

参考答案:

onlybandc

PL/SQLfullysupportsSQLdatatypes.

参考答案:

对

Procedurallanguagesallowdevelopersto____.

参考答案:

performdecision-makinglogic

StructuredQueryLanguage(SQL)isconsideredaprocedurallanguage.

参考答案:

错

The____sectionofaPL/SQLblockcontainshandlersthatallowyoutocontrolwhattheapplicationwilldoifanerroroccurswhentheexecutablestatementsareprocessed.

参考答案:

EXCEPTION

The____________________optioncanbeaddedtothevariabledeclarationtorequirethevariabletoalwayscontainaparticularvaluewithintheblock.

参考答案:

CONSTANT

The____________________sectionofthePL/SQLblockcontainscodethatcreatesvariables,cursors,andtypes.

参考答案:

DECLARE

TheBEGINsectionofaPL/SQLblockcontainscodethatcreatesvariables,cursors,andtypes.

参考答案:

错

TheonlyrequiredsectionsofaPL/SQLblockarethe____sections.

参考答案:

BEGIN&END

Theterm____________________indicatestheprogramunitissavedinthedatabase,andthereforecanbeusedorsharedbydifferentapplications.

参考答案:

stored

Thetermanonymousblocksreferstoblocksofcodethatarenotstoredforreuseanddonotexistafterbeingexecuted.

参考答案:

对

Thethree-tierapplicationmodelisalsoreferredtoasaclient/serverapplication.

参考答案:

错

Whatcomparisonoperatorsarerequiredformultiple-rowsubqueries?

参考答案:

IN,ALL,ANY,orEXIST

WhatisthepurposeoftheBEGINsectionofaPL/SQLblock?

参考答案:

TheBEGINsectionistheheartofthePL/SQLblockinthatitcontainsalltheprocessingaction,orprogramminglogic.SQLisusedfordatabasequeriesanddatamanipulation.Conditionallogic,suchasIFstatements,isusedtomakedecisionsonwhatactiontotake.Loopsareusedtorepeatcodeandassignmentstatementsareusedtoputorchangevaluesinvariables.

What’sthemaximumdepthallowedwhennestinggroupfunctions?

参考答案:

2

WhenanIFstatementchecksonlyoneconditionandperformsactionsonlyiftheconditionisTRUE,itisreferredtoasasimpleIFcondition.

参考答案:

对

Whichofthefollowingcodefragmentswouldnotraiseanerror?

参考答案:

IFrec_order.state='A'THEN

Whichofthefollowinggeneratesaseriesofintegersthatcanbestoredinadatabase?

参考答案:

asequence

Whichofthefollowinginitializesthevariableorder?

参考答案:

DECLARE

WhichofthefollowingisavalidSELECTstatement?

参考答案:

SELECTAVG(retail-cost)FROMbooksGROUPBYcategory;

Whichofthe