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
  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
  1. Current

  2. Projected

  3. Historical

  4. Current and Projected


Correct Option: A
  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