单选题Which of the following privileges permits a user to update the comment on a sequence?（）A CONTROLB UPDATEC USAGED ALTER

第1题：

Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）

• A、The next value will be 0 and the sequence will never use the values 101 to 105.
• B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
• C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
• D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

第2题：

Which of the following groups should a user be added to for the ability to restore files, withoutgranting any ownership privileges?（）

• A、Remote Desktop Users
• B、Power Users
• C、Administrators
• D、Backup Operators

第3题：

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

第4题：

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

第5题：

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

第6题：

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

• A、ALTER DATABASE 
• B、ALTER SYSTEM 
• C、ALTER USER 
• D、ALTER REDO LOG

第7题：

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.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

更改oracle用户HR，使其变为不可用（锁定）状态（）

• A、UPDATE  USER  HR  ACCOUNT  DISABLE
• B、UPDATE  USER  HR  ACCOUNT  LOCK
• C、ALTER USER  HR  ACCOUNT  DISABLE
• D、ALTER USER  HR  ACCOUNT  LOCK

第14题：

Which of the following approval member groups can an organization administrator grant privileges to？（）

• A、ApprovalGroup
• B、Order Process
• C、User Group
• D、User Registration
• E、AccessGroup

第15题：

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

• A、REVOKE ALL PRIVILEGES FROM USER tom
• B、REVOKE ALL ON EMPLOYEE FROM USER tom
• C、REVOKE EXECUTE ON EMPLOYEE FROM USER tom
• D、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

第16题：

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

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

第17题：

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

• A、ALTER USER DEFAULT ROLE ALL
• B、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
• C、ALTER USER DEFAULT ROLE NONE
• D、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1

第18题：

User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）

• A、The transaction for user A is rolled back.
• B、The ALTER TABLE command modifies the column successfully.
• C、The ALTER TABLE command fails due to the resource being busy.
• D、The ALTER TABLE command waits until user A ends the transaction.

第19题：

User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

• A、UPDATE pets…
• B、SELECT….FROM pets
• C、INSERT INTO pets…
• D、ALTER TABLE pets…

第20题：

第21题：

第22题：

第23题：

第24题：