单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definiti

第1题：

Which version of a view would you use if you just want a quick， easy view within your XPage？（）

• A、Data Table Control
• B、View Control
• C、Repeat Control
• D、Filter by category View Control

第2题：

What is necessary for your query on an existing view to execute successfully? （）

• A、The underlying tables must have data.
• B、You need SELECT privileges on the view.
• C、The underlying tables must be in the same schema.
• D、You need SELECT privileges only on the underlying tables.

第3题：

第4题：

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

• A、Create a table view.
• B、Create a view in any schema.
• C、Create a view in your schema.
• D、Create a sequence view in any schema.
• E、Create a view that is accessible by everyone.
• F、Create a view only of it is based on tables that you created.

第5题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command in the EMP_DEPT VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第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题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command on the EMP_DEPT_VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

第8题：

第9题：

You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）

• A、runtime ()  
• B、runtimeMbeanServer ()
• C、connectRuntime ()
• D、beginRuntime ()
• E、serverRuntime ()

第10题：

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

• A、Use the DESCRIBE command in the EMP_DEPT VU view.
• B、Use the DEFINE VIEW command on the EMP_DEPT VU view.
• C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
• D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
• E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
• F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.