单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A USER_TAB_PRIVS_MADEB USER_TAB_PRIVSC USER_COL_PRIVS_MADED USER_COL_PRIVS

第1题：

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

第4题：

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.

第5题：

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

第6题：

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.

第7题：

The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）

• A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
• B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
• C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. 
• 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 'Table', and enter the SELECT statement in the Query Data Source Name property. 
• E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
• F、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 to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.

第8题：

第9题：

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

第10题：

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