database table
transactional trigger
stored procedure
FROM clause query
client-side procedure
第1题:
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?()
第2题:
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?()
第3题:
A UDT is a data type which:()
第4题:
In which two scenarios do you use SQL* Loader to load data?()
第5题:
You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?()
第6题:
You are creating a Windows Forms application by using the .Net Framework 3.5 You plan to display detailed help instructions for each control in the form.You create a help file.You configure a HelpProvider component on the form. You need to display the help file for the control that is focused when the F1 key is pressed. Which method of the HelpProvider class should you call for each control?()
第7题:
Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property.
Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
第8题:
RC_STORED_SCRIPT
RC_STORED_SCRIPT_LINE
RC_SCRIPTS
RC_STORED_LINE_SCRIPT
None of the other alternatives apply
第9题:
Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property.
Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
第10题:
NEW_FORM
OPEN_FORM
CALL_FORM
CLOSE_FORM
第11题:
heap table
object table
external table
clustered table
global temporary table
indexorganized table (IOT)
第12题:
heap table
object table
external table
clustered table
global temporary table
index-organized table (IOT)
第13题:
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?()
第14题:
In one of your online transaction processing (OLTP) applications, most users frequently modify the values, including the key values, of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance?()
第15题:
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? ()
第16题:
36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?()
第17题:
You use Microsoft .NET Framework 4 to create a Windows Forms application. You add a new class named Customer to the application. You select the Customer class to create a new object data source. You add the following components to a Windows Form: A BindingSource component named customerBindingSource that is data-bound to the Customer object data source. A set of TextBox controls to display and edit the Customer object properties. Each TextBox control is data-bound to a property of the customerBindingSource component. An ErrorProvider component named errorProvider that validates the input values for each TextBox control. You need to ensure that the input data for each TextBox control is automatically validated by using the ErrorProvider component. Which two actions should you perform?()
第18题:
database table
transactional trigger
stored procedure
FROM clause query
client-side procedure
第19题:
Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property.
Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor.
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
第20题:
SetShowHelp
SetHelpString
SetHelpKeyword
SetHelpNavigator
第21题:
Heap table
Object table
External table
Clustered table
Global temporary table
Index-organized table (IOT)
第22题:
One content canvas and multiple stacked canvases.
One content and one stacked canvas.
Tab canvas with several tab pages.
One content canvas.
A horizontal and vertical toolbar.
第23题:
Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.
Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.
第24题:
must contain unique values.
cannot be CAST to other data types.
is created using the CREATE DISTINCT command.
contains a value that was automatically calculated from values in other columns.