单项选择题You want to create a temporary table while executing a procedure in a form. Which statement is true?()

A.You cannot create a table form within Forms. 
B.You must use the FORMS_DDL built-in to create the table. 
C.You must use the DBMS_DYNAMIC_DDL package to create the table. 
D.You can write the CREATE TABLE statement directly into the trigger.


您可能感兴趣的试卷

你可能感兴趣的试题

2.多项选择题Which two triggers are mouse movement triggers?()

A.When-Mouse-Up 
B.When-Mouse-Move 
C.When-Mouse-Down
D.When-Mouse-Click 
E.When-Mouse-Leave  

4.单项选择题What does the term application partitioning refer to?()

A.The feature of a forms application enabling it to run both in client-server mode and on the Web. 
B.Storing PL/SQL program units between the Oracle server and the application to make optimal use of available resources. 
C.The nature of a three-tier architecture, where the form module and processing software reside on an application server. 
D.The feature of a forms application that is able to use Ethernet, twisted pair, and wireless data connections.

5.单项选择题Which built-in would you reference in your trigger code to remove a report from the Reports Server queue dynamically?()

A.FIND_REPORT_OBJECT 
B.CANCEL_REPORT_OBJECT 
C.REPORT_OBJECT_STATUS 
D.SET_PROPERTY OBJECT_PROPERTY

6.单项选择题You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this record group?()

A.All forms in the application. 
B.Any forms opened by the user who initiated the record group. 
C.Only the form issuing the CREATE_GROUP built-in. 
D.Any forms referenced by the form that contains the procedure.

7.多项选择题Which three statements describe the functionality of the DO_KEY built-in?()

A.It accepts both a built-in and a key name as argument. 
B.If no key trigger is defined, the specified built-in executes. 
C.Its parameter must be specified in upper case, enclosed in single quotation marks. 
D.It performs the same task as if you pressed the function key associated with the specified argument. 
E.It executes the key trigger that corresponds to the built-in specified as its parameter. 

8.多项选择题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?()

A.BFILE 
B.REF column 
C.Object table 
D.Column object 
E.INSTEAD-OF trigger

9.单项选择题You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?()

A.REF cursor query. 
B.Stored function. 
C.From clause query. 
D.Transactional trigger.

最新试题

You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?()

题型:单项选择题

Using the reports server how would you force the orders report in the orders entry application to run every six hours?()

题型:单项选择题

Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?()

题型:单项选择题

The IT department requested a report to list each server name and the name of each department that utilizes resources from each server. You create a tabular layout that breaks on the server name. You ran the report and noticed that the department field is too large for most of the department names. Which field size setting would you use to allow the field to be smaller but not larger than the field layout size?()

题型:单项选择题

When is an implicit anchor created?()

题型:单项选择题

The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?()

题型:单项选择题

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?()

题型:单项选择题

You are creating a sales data template and need to add a picture to the margin. What is the best way to add this margin?()

题型:单项选择题

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?()

题型:单项选择题

You are developing an inventory report to list the item number, description price and picture of all inventory items. The layout of each item is a repeating frame that contains three fixed fields and a image. When possible you want all objects in the repeating frame to appear on the same logical page without creating blank pages between instances. Which pagination property would you alter to achieve these results?()

题型:单项选择题