单选题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 TableB ColumnsC Table and AliasD Columns and Alias

第1题：

第2题：

第3题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第4题：

Which of the following describes the objects of a DB2 database and their relationships?（）

• A、Instance
• B、Table space
• C、System catalog
• D、Schema repository

第5题：

Which of the following privileges permits a user to update the comment on a sequence?（）

• A、CONTROL
• B、UPDATE
• C、USAGE
• D、ALTER

第6题：

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

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

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which table of EIGRP route information are held in RAM and maintained through the use of hello and update packets?（）

• A、Neighbor table
• B、SPF table
• C、RTP table
• D、Topology table
• E、Query table
• F、DUAL table

第15题：

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

• A、REFERENCES
• B、SELECT
• C、UPDATE
• D、ALTER

第16题：

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

第17题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

• A、UPDATE TABLE
• B、CREATE CLUSTER
• C、TRUNCATE TABLE
• D、ALTER TABLE MOVE
• E、INSERT INTO···VALUES
• F、ALTER TABLE···DROP COLUMN
• G、ALTER TABLE···DROP PARTITION

第18题：

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：  SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；  Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）

• A、The command fails because SCOTT still has privileges.
• B、The command succeeds and privileges are revoked from JIM.
• C、The command fails because HR cannot revoke the privileges from JIM.
• D、The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.

第19题：

You are adatabase developer. You develop atask management application that connect stoa SQLServer 2008 database named TaskDB.Users logon to the application by using a SQLServer login. The application contains amodule named Task that assigns tasks tousers. Information about the setasks is stored in the Tasks table of the TaskDB data base. The Tasks table contains multiple columns. These include the Close Dateand Estimated Timecolumns. The application must meet the following security requirements: Users assigned toad atabase role named User 1 canupd ate all task information columns except the Close Date and the Estimated Time columns in the Tasks table. Administrative users assigned toad atabase role named Task_Admin canupd ateall task information in the Tasks table.You needto design a strategy to meet the security requirements. Which two actions should you perform?（）

• A、Add the Task_Admin role to thedb_accessadmin fixed database role.
• B、Grant Update permissions on the Tasks table to the Task_Admin role.
• C、Grant Update  permissions on  the  Tasks table to  the  User  1  role foreach  column  except the  Close  Dateand Estimated  Time columns.
• D、Createan  INSTEAD OF trigger  on  the  Tasks Table. Use theIs_Member function  toprevent the  User  1  role from updating the Close  Date and Estimated  Time columns.

第20题：

第21题：

第22题：

第23题：

第24题：