多选题Which three statements correctly describe the functions and use of constraints? （）AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.E

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

The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

• A、user tables
• B、view segment
• C、table segment
• D、data dictionary
• E、object segment
• F、performance tables

第3题：

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.

第4题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第5题：

Which two statements about creating constraints are true? （）

• A、Constraint names must start with SYS_C
• B、All constraints must be defines at the column level
• C、Constraints can be created after the table is created
• D、Constraints can be created at the same time the table is created
• E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

第6题：

Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

• A、 Remove all deterministic function calls from within the view. 
• B、 Remove all nondeterministic function calls from within the view. 
• C、 Schema-bind all functions that are called from within the view. 
• D、 Create the view and specify the WITH CHECK OPTION clause.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which two statements describe the purpose of a security policy？（）

• A、It enables traffic counting and logging.
• B、It enforces a set of rules for transit traffic.
• C、It controls host inbound services on a zone.
• D、It controls administrator rights to access the device.

第14题：

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.

第15题：

Which three statements correctly describe the functions and use of constraints? （）

• A、Constraints provide data independence.
• B、Constraints make complex queries easy.
• C、Constraints enforce rules at the view level.
• D、Constraints enforce rules at the table level.
• E、Constraints prevent the deletion of a table if there are dependencies.
• F、Constraints prevent the deletion of an index if there are dependencies.

第16题：

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

• A、CHECK
• B、UNIQUE
• C、NOT NULL
• D、PRIMARY KEY
• E、FOREIGN KEY

第17题：

Which two statements about creating constraints are true?（）

• A、Constraint names must start with SYS_C
• B、All constraints must be defines at the column level.
• C、Constraints can be created after the table is created.
• D、Constraints can be created at the same time the table is created.
• E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：