单选题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 tablesB view segmentC table segmentD data dictionaryE object segmentF

第1题：

While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）

• A、heap tables
• B、object tables
• C、partitioned tables
• D、index­organized tables （IOTs）

第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 are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

• A、Update the view to use an outer join between the Customers and Sales tables.
• B、Create a clustered index on the v CustomerSales view.
• C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
• D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

第4题：

In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）

• A、hash clusters
• B、index clusters
• C、partitioned tables
• D、index­organized table （IOT）

第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 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.

第6题：

Which  statements are correct about temporary tables（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

第7题：

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.

第8题：

Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.

• A、1 and 3
• B、2， 3， and 5
• C、1， 2， and 3
• D、2， 3， 4， and 5

第9题：

Which two statements are true about simple views？（）

• A、Views can be created as read only.
• B、Views are data segments like tables.
• C、Views can be created on the basis of more than one table.
• D、Data manipulation language （DML） operations cannot be performed on views.

第10题：

Which three statements are correct about temporary tables？（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.