0

databases Online Quiz - 78

Description: databases Online Quiz - 78
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. REVOKE CONTROL ON table1 FROM user1

  2. REVOKE ALL PRIVILEGES ON table1 FROM user1

  3. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1

  4. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1


Correct Option: C
  1. GRANT ALTER ON TABLE department TO user1

  2. GRANT ALTER (dept_name) ON TABLE department TO user1

  3. GRANT UPDATE ON TABLE department TO user1

  4. GRANT UPDATE (dept_name) ON TABLE department TO user1


Correct Option: D
  1. GRANT DROP ON INDEX empid_x TO user1

  2. GRANT DELETE ON INDEX empid_x TO user1

  3. GRANT INDEX ON TABLE employee TO user1

  4. GRANT CONTROL ON INDEX empid_x TO user1


Correct Option: D
  1. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in queries, along with the ability to give this authority to other users and groups.

  2. Gives user USER1 the ability to refer to COL1 and COL2 of table TABLE1 in views, along with the ability to give this authority to other users and groups.

  3. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the parent key of the constraint.

  4. Gives user USER1 the ability to define a referential constraint on table TABLE1 using columns COL1 and COL2 as the foreign key of the constraint.


Correct Option: C

A view named V.VIEW1 is based on a table named T.TABLE1. A user with DBADM authority issues the following statement: GRANT INSERT ON v.view1 TO user1 WITH GRANT OPTION Which of the following statements is USER1 authorized to execute?

  1. GRANT INSERT ON t.table1 TO user2

  2. GRANT CONTROL ON v.view1 TO user2

  3. GRANT ALL PRIVILEGES ON v.view1 TO user2

  4. GRANT INSERT ON v.view1 TO user2


Correct Option: D
  1. REVOKE DROP ON T1 FROM PUBLIC

  2. REVOKE UPDATE ON T1 FROM PUBLIC

  3. REVOKE DELETE ON T1 FROM PUBLIC

  4. REVOKE CONTROL ON T1 FROM PUBLIC


Correct Option: C
  1. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446

  2. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446

  3. CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1

  4. CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1


Correct Option: B

A “trusted” client needs to communicate with a server that has been configured to Use CLIENT Authentication. Which of the following will be used to verify passwords?

  1. User ID/Password File

  2. Communications Layer

  3. Client Applications

  4. Operating Systems


Correct Option: D
  1. Control Center

  2. Development Center

  3. Developer Work Bench

  4. Stored Procedure Builder


Correct Option: C

Which of the following tools is used to view historical information about tasks, Database changes, messages and notifications.

  1. Journal

  2. Task Center

  3. Control Center

  4. Activity Monitor


Correct Option: A
  1. Current

  2. Projected

  3. Historical

  4. Current and Projected


Correct Option: A

Which of the following describes the model used by the Geodetic Extender?

  1. Flat earth

  2. E-D square

  3. Trapezoidal

  4. Round Earth


Correct Option: D
  1. DB2 AVI Extender

  2. DB2 Text Extender

  3. DB2 XML Extender

  4. DB2 Spatial Extender


Correct Option: C
  1. SQL statements

  2. New indexes

  3. DDL

  4. Database configuration parameter settings


Correct Option: D
- Hide questions