单选题You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should yo

第1题：

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1.Display the salary multiplied by the commission_pct. 2.Exclude employees with a zero commission_pct. 3.Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide?（）

• A、all of the desired results
• B、two of the desired results
• C、one of the desired results
• D、an error statement

第2题：

Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees?（）

• A、SELECT last_name, 12*salary* commission_pct FROM emp;
• B、SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
• C、SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
• D、SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

第3题：

You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）

• A、SALARY form at runtime. 
• B、SALARY form at design time. 
• C、COMMISSION form at runtime. 
• D、COMMISSION form at design time. 

第4题：

Which scenario describes an appropriate use for opening a form in a new session?（）

• A、The data entered into the called form is logically independent of the data entered in the calling form. 
• B、The called form requires different privileges than the calling form. 
• C、The called form must execute as a different user than the calling form. 
• D、The calling form must be able to query data in the called form before it is saved.

第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?（）

• A、One content canvas and multiple stacked canvases. 
• B、One content and one stacked canvas.
• C、Tab canvas with several tab pages. 
• D、One content canvas. 
• E、A horizontal and vertical toolbar.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）

• A、SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
• B、SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
• C、SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
• D、SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

第14题：

The EMPLOYEES table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) COMMISSION_PCT NUMBER (6) You need to write a query that will produce these results: 1. Display the salary multiplied by the commission_pct. 2. Exclude employees with a zero commission_pct. 3. Display a zero for employees with a null commission value. Evaluate the SQL statement: SELECT LAST_NAME, SALARY*COMMISSION_PCT FROM EMPLOYEES WHERE COMMISSION_PCT IS NOT NULL; What does the statement provide? （）

• A、All of the desired results
• B、Two of the desired results
• C、One of the desired results
• D、An error statement

第15题：

You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

• A、Before parameter form. 
• B、After parameter form. 
• C、Before report. 
• D、After report.

第16题：

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）

• 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.

第17题：

You are creating a Windows Forms application by using the .NET Framework 3.5. You create a new form in your application.You add 100 controls at run time in the Load event handler of the form.  Users report that the form takes a long time to get displayed. You need to improve the performance of the form. What should you do？（）

• A、Call the InitLayout method of the form before adding all the controls.Call the PerformLayout method of the form after adding all the controls.
• B、Call the InitLayout method of the form before adding all the controls.Call the ResumeLayout method of the form after adding all the controls.
• C、Call the SuspendLayout method of the form before adding all the controls.Call the PerformLayout method of the form after adding all the controls.
• D、Call the SuspendLayout method of the form before adding all the controls.Call the ResumeLayout method of the form after adding all the controls.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：