单选题You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）A After th

第1题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第2题：

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

• A、Rows 
• B、Totals 
• C、Columns 
• D、Cells 
• E、Data

第3题：

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

• A、Fixed 
• B、Expand 
• C、Contract 
• D、Variable

第4题：

You created a tabular report for human resources department. After viewing layout users have requested that you change the label of the dept column to something more meaningful. How would you change the label in the live previewer?（）

• A、Use the report wizard to change the column label. 
• B、Click and high light the column label and replace it with desired text. 
• C、Click the column label and alter its property palette. 
• D、Click the dept column and alter its property palette. 

第5题：

The transportation department requested a shipping cost report to list the resources used by each department. A separate page should be product for each department. Which property would you modify to achieve these results?（）

• A、Minimum widow records. 
• B、Column mode. 
• C、Spacing 
• D、Print direction. 
• E、Source F maximum records per page. 
• F、Maximum records per page.

第6题：

You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）

• A、ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
• B、MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
• C、ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
• D、MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
• E、CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
• F、You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

第7题：

Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

• A、Specify the break order on the gemp group Property palette. 
• B、Specify a break order on the dept_name and job columns property palettes. 
• C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
• D、Change the position of the dept_name and the job columns within the gemp group.

第8题：

 You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）

• A、Double click the dept column in the group to alter the property palette and change the break out order value. 
• B、Double click the dept column in the group to open the property palette and change the set break order value. 
• C、Double click the g_dept group object to change the break order. 
• D、Click the dept column in the group to change the break order.

第9题：

You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）

• A、After the query. 
• B、Enter the report and change the column's position in the field tab. 
• C、Alter the column's position in the object navigator. 
• D、Enter the report wizard and change the column's position in the data tab. 
• E、Alter the column's position within its group and change the layout. 

第10题：

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.