网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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. ” 相关考题
考题
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
考题
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.
考题
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
考题
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.
考题
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
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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?（）A、In the template used. B、In the data model. C、In the life previewer. D、In the field property palette.
考题
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？（）A、 space allocated in the tablespaceB、 space required for the bitmap index on a column of the tableC、 space remaining in the tablespace after creating the tableD、 estimated value of the PCTFREE storage parameter
考题
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.
考题
You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）A、Removing column from the available list in the report wizard. B、Removing the column from the displayed list in the report wizard. C、Changing the display width of a column in the report wizard. D、Adding a column to both the available list and displayed list in the report wizard. E、Removing a column in the live previewer.
考题
单选题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 manager_id NUMBER);B
MODIFY VIEW emp_dept_vu (ADD manager_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.
考题
单选题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？（）A
space allocated in the tablespaceB
space required for the bitmap index on a column of the tableC
space remaining in the tablespace after creating the tableD
estimated value of the PCTFREE storage parameter
考题
单选题You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）A
Removing column from the available list in the report wizard. B
Removing the column from the displayed list in the report wizard. C
Changing the display width of a column in the report wizard. D
Adding a column to both the available list and displayed list in the report wizard. E
Removing a column in the live previewer.
考题
单选题You created a department report and preview it in life preview. The font for the department name is too small and you want to enlarge it but do not want to change the font for any other fields. What is the easiest way to make this change?（）A
Select the text to be enlarged in the life previewer and make the size change using the style bar. B
Select the text to be enlarged in the layout mode and make the change. C
Open the report wizard in the re-entrant mode and make the change. D
Make the copy of the report, open the copy, make the changes and then delete the original report.
考题
单选题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.
考题
单选题The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table？（）A
The materialized view should have a complete refresh performed after the online table redefinition is completed.B
The materialized view should have a fast refresh performed after the online table redefinition is completed.C
The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.D
The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
单选题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
考题
单选题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.
考题
单选题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?（）A
In the template used. B
In the data model. C
In the life previewer. D
In the field property palette.
热门标签
最新试卷
