单选题Which cannot be done through the outline view？（）A Change the HTML IDB Delete an elementC Have every applicable view navigate to the selected itemD Changerearrange objects

第1题：

第2题：

If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）

• A、 TS_OBJECTS_TO_BE_DROPPED
• B、 TS_PTTR_OBJECT_DROPPED
• C、 TS_PITR_OBJECTS_TO_BE_DROPPED
• D、 TS_OBJECTS_DROPPED
• E、 TS_DROPPED_OBJECTS

第3题：

Which of the following abilities does a view NOT provide？（）

• A、Change which columns show
• B、Open a view from another database
• C、Contain custom controls
• D、Identify a column to act as a link

第4题：

Which two statements are true regarding views?（）

• A、A subquery that defines a view cannot include the GROUP BY clause 
• B、A view that is created with the subquery having the DISTINCT keyword can be updated 
• C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
• D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

第5题：

Which object privileges can be granted on a view? （）

• A、none
• B、DELETE, INSERT,SELECT
• C、ALTER, DELETE, INSERT, SELECT
• D、DELETE, INSERT, SELECT, UPDATE

第6题：

What is true about updates through a view? （）

• A、You cannot update a view with group functions.
• B、When you update a view group functions are automatically computed.
• C、When you update a view only the constraints on the underlying table will be in effect.
• D、When you update a view the constraints on the views always override the constraints on the underlying tables.

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

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

• A、DROP emp_dept_uv;
• B、DELETE emp_dept_uv;
• C、REMOVE emp_dept_uv;
• D、DROP VIEW emp_dept_uv;
• E、DELETE VIEW emp_dept_uv;
• F、REMOVE VIEW emp_dept_uv;

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

On which of the following database objects may the SELECT privilege be controlled?（）

• A、Sequence
• B、Schema
• C、Group
• D、View

第15题：

Which cannot be done through the outline view？（）

• A、Change the HTML ID
• B、Delete an element
• C、Have every applicable view navigate to the selected item
• D、Changerearrange objects

第16题：

What is the functionality of the "Allow modifications of customized objects" check box in the OracleWorkflow Builder dialog box that is displayed from the Help menu? （）(Choose two.)

• A、Having check box selected is equivalent to Workflow Definitions Loader Upgrade mode.
• B、Having check box deselected is equivalent to Workflow Definitions Loader Upload mode.
• C、If the check box is not selected, you can save your edits only to protected objects that you have access to change, and cannot overwrite previously customized objects
• D、If the check box is selected, you overwrite any protected objects that you have the ability (access) to modify, and also any previously customized objects.

第17题：

The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）

• A、REF cursor. 
• B、Instead Of trigger. 
• C、Stored procedure that returns object values. 
• D、The underlying view cannot be modified because DML on a view is not supported.

第18题：

Which two statements about views are true?（）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第19题：

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 ()

第20题：

第21题：

第22题：

第23题：

第24题：