单选题Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）A USER_CONSTRAINTSB USER_OBJECTSC ALL_CONSTRAINTSD USER_CONS_COLUMNSE USER_COLUMNS

第1题：

A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）

• A、Table
• B、Columns
• C、Table and Alias
• D、Columns and Alias

第2题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in

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

A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL> connect smith/smith  Connected.  SQL> SELECT * FROM v$session；  SELECT * FROM v$session *  ERROR at line 1：  ORA-00942： table or view does not exist  Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）

• A、granting SELECT privilege to SMITH on V$SESSION
• B、granting SELECT privilege to SMITH on V_$SESSION
• C、asking the user SMITH to run the catalog.sql script
• D、granting SELECT privilege to SMITH on V$FIXED_TABLES
• E、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE
• F、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created

第5题：

Which data dictionary table should you query to view the object privileges granted to the user on specific columns? （）

• A、USER_TAB_PRIVS_MADE
• B、USER_TAB_PRIVS
• C、USER_COL_PRIVS_MADE
• D、USER_COL_PRIVS

第6题：

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.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?（）

• A、GRANT select ON dept TO ALL_ USER;
• B、GRANT select ON dept TO ALL;
• C、GRANT QUERY ON dept TO ALL_USERS
• D、GRANT select ON dept TO PUBLIC;

第14题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in.

第15题：

Which view should a user query to display the columns associated with the constraints on a table owned by the user? （）

• A、USER_CONSTRAINTS
• B、USER_OBJECTS
• C、ALL_CONSTRAINTS
• D、USER_CONS_COLUMNS
• E、USER_COLUMNS

第16题：

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

第17题：

You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

• A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
• B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
• D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
• E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

第18题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

• A、A primary XML index should be created on the XML column.
• B、Statistics should be created on the nvarchar columns.
• C、A view should be created， and only the four columns that the query utilizes are contained by a view.
• D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：