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_CONSTRAINTS
• B、CONSTRAINTS_ALL
• C、SYS_DATA_DICT
• D、US_CON_SYS

第2题：

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

第3题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

• A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
• B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis 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 drop Tables owned by SCOTT

第4题：

In which scenario do you use the Flashback Database feature？（）

• A、 when a table is dropped and you restore it from the Recycle Bin
• B、 when a user’s schema is dropped and you recover the user’s schema
• C、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
• D、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration

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

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

第7题：

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

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

• A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
• D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
• E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

第14题：

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;

第15题：

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

第16题：

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.

第17题：

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

第18题：

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

第19题：

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.

第20题：

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.

第21题：

第22题：

第23题：

第24题：