单项选择题

Which technique retrieves the error number when explicit DML fails?（）

A.SQLCODE in an On-Error trigger.
B.SQLCODE in an exception handler.
C.DBMS_ERROR_CODE in an On-Error trigger.
D.DBMS_ERROR_CODE in an exception handler.

<上一题目录下一题>

热门试题

单项选择题YoucreateadatablockbasedonarelationaltablecontainingaREFcolumn.YouselecttheREFcolumnforyourformmodule.WhatistrueabouttheitemsbasedontheREFcolumnattributes?（）

A.The Query Only property is set to Yes.
B.The Conceal Data property is set to Yes.
C.The Insert Allowed property is set to Yes.
D.The Update Allowed property is set to Yes.

单项选择题Youestablishedaccesstomenumodulesusingroles.Youhaveallowedthesalesroletoaccessthemenumodule,butpreventedaccesstotheUpdatemenuitem.Whichitempropertywouldyoualtertograyoutthemenuoptionfortherole?（）

A.Item Roles.
B.Menu Item Roles.
C.Display without Privilege.
D.Use Security.
E.Command Type.

单项选择题Youwanttoimplementamaster-detailrelationbetweendatablocksbasedonobjecttables.Howwouldyoudothis?（）

A.Create the relation manually and coordinate the blocks using triggers.
B.Base the relation on a REF pointer using the Data Block Wizard.
C.Base the relation on a foreign key using the Data Block Wizard.
D.This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.

单项选择题AsalesanalystreviewsthefirstdraftonyourSalesapplication,andrequeststhattheapplicationgraphicallyrepresentrevenuegeneratedforeachsalesrepresentative,inadditiontothetextualdatacurrentlydisplayedfortheORDERblock.Howwouldyouincorporatethisgraphicinyourform?（）

A.Invoke the Chart Wizard and create a chart based on the ORDER block.
B.Create a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block.
C.Invoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes.
D.Select the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.

单项选择题Youarebuildingtwoforms.Eachformhasabuttonandanon-basetablefield.Whenthebuttonispressed,acomplicatedcalculationisexecuted.Thecalculationisthesameforbothforms.The calculationcodedoesnotqueryorchangethedatainthedatabase.Whenthecalculationcompletes,itreturnsasinglevaluetothenon-basetablefield.Tooptimizeperformanceandmaintainability,whichPL SQLstructureshouldbeused?（）

A.A trigger in each form.
B.A subprogram in each form.
C.A stored subprogram in the database.
D.A subprogram in a library that is attached to each form.