单项选择题

The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?（）

A.&p_where_clause
B.:p_where_clause
C.WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
D.Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone

<上一题目录下一题>

热门试题

单项选择题Thesalesreportneedstodisplaythesalespersonwiththehighestordertotal.Whichbuildreportbuildercomponentwouldyouusetocreateaplaceholdercolumntodisplaythevalue?（）

A.Report wizard.
B.Layout model.
C.Data model.
D.Life previewer.

单项选择题Youwanttocreateatemplatetobeusedasastandardforallcompanyreports.Whatistheeasiestwaytodothis?（）

A.Open an existing template file, rename it and modify the template objects.
B.Open the report wizard and create a new template.
C.Open the layout model and copy the paste items from the default templates provided in report builder.
D.Templates cannot be modified in release 2.

单项选择题TheITdepartmentiscreatingahumanresourcesapplicationthatwillrequireseveralnewtables.Youneedtodevelopastandardaloneexecutablethatwilldefinesthesetablesandtheirrelationships.Whichdeveloper 2000componentcouldyouusetocreatetheexecutable?（）

A.Procedure builder.
B.Query builder.
C.Schema builder.
D.Form builder.
E.Project builder.
F.Transactional builder.

单项选择题TheITdepartmentrequestedareporttolisteachservernameandthenameofeachdepartmentthatutilizesresourcesfromeachserver.Youcreateatabularlayoutthatbreaksontheservername.Youranthereportandnoticedthatthedepartmentfieldistoolargeformostofthedepartmentnames.Whichfieldsizesettingwouldyouusetoallowthefieldtobesmallerbutnotlargerthanthefieldlayoutsize?（）

A.Fixed
B.Expand
C.Contract
D.Variable

单项选择题Youaredevelopinganinventoryreporttolisttheitemnumber,descriptionpriceandpictureofallinventoryitems.Thelayoutofeachitemisarepeatingframethatcontainsthreefixedfieldsandaimage.Whenpossibleyouwantallobjectsintherepeatingframetoappearonthesamelogicalpagewithoutcreatingblankpagesbetweeninstances.Whichpaginationpropertywouldyoualtertoachievetheseresults?（）

A.Page break before.
B.Page break after.
C.Page protect.
D.Keep with anchoring object.