After the query.
Enter the report and change the column's position in the field tab.
Alter the column's position in the object navigator.
Enter the report wizard and change the column's position in the data tab.
Alter the column's position within its group and change the layout.
第1题:
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?()
第2题:
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?()
第3题:
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?()
第4题:
The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?()
第5题:
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? ()
第6题:
ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
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;
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;
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;
You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
第7题:
Removing column from the available list in the report wizard.
Removing the column from the displayed list in the report wizard.
Changing the display width of a column in the report wizard.
Adding a column to both the available list and displayed list in the report wizard.
Removing a column in the live previewer.
第8题:
Use the report wizard to change the column label.
Click and high light the column label and replace it with desired text.
Click the column label and alter its property palette.
Click the dept column and alter its property palette.
第9题:
Specify the break order on the gemp group Property palette.
Specify a break order on the dept_name and job columns property palettes.
Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group.
Change the position of the dept_name and the job columns within the gemp group.
第10题:
ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
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;
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;
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;
You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
第11题:
Fixed
Expand
Contract
Variable
第12题:
In the template used.
In the data model.
In the life previewer.
In the field property palette.
第13题:
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?()
第14题:
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?()
第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?()
第16题:
You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names, data types, sizes of the columns, and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return?()
第17题:
You create the sales report and run it in the live previewer. After which change would the live previewer require the data? ()
第18题:
space allocated in the tablespace
space required for the bitmap index on a column of the table
space remaining in the tablespace after creating the table
estimated value of the PCTFREE storage parameter
第19题:
Select the text to be enlarged in the life previewer and make the size change using the style bar.
Select the text to be enlarged in the layout mode and make the change.
Open the report wizard in the re-entrant mode and make the change.
Make the copy of the report, open the copy, make the changes and then delete the original report.
第20题:
The materialized view should have a complete refresh performed after the online table redefinition is completed.
The materialized view should have a fast refresh performed after the online table redefinition is completed.
The materialized view,materialized log,and the index should be dropped and re-created after the online table redefinition is complete.
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
第21题:
Double click the dept column in the group to alter the property palette and change the break out order value.
Double click the dept column in the group to open the property palette and change the set break order value.
Double click the g_dept group object to change the break order.
Click the dept column in the group to change the break order.
第22题:
Rows
Totals
Columns
Cells
Data
第23题:
ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
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;
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;
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;
You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.