Question 1

USER1 is the owner of TABLE1. Assuming USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges USER1 holds?

technology databases

REVOKE CONTROL ON table1 FROM user1
REVOKE ALL PRIVILEGES ON table1 FROM user1
REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1
REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1

Answer

Correct Option: C

Question 2

Which authority or privilege is granted by the DB2 Database Manager configuration file?

technology databases

CONNECT
CONTROL
SYSMAINT
EXECUTE

Answer

Correct Option: C

Question 3

A table called DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER Which of the following statements will ONLY allow user USER1 to modify the DEPT_NAME column?

technology databases

GRANT ALTER ON TABLE department TO user1
GRANT ALTER (dept_name) ON TABLE department TO user1
GRANT UPDATE ON TABLE department TO user1
GRANT UPDATE (dept_name) ON TABLE department TO user1

Answer

Correct Option: D

Question 4

An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?

technology databases

GRANT DROP ON INDEX empid_x TO user1
GRANT DELETE ON INDEX empid_x TO user1
GRANT INDEX ON TABLE employee TO user1
GRANT CONTROL ON INDEX empid_x TO user1

Answer

Correct Option: D

Question 5

What does the following statement do? GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION

technology databases

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

Answer

Correct Option: C

Question 6

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?

technology databases

GRANT INSERT ON t.table1 TO user2
GRANT CONTROL ON v.view1 TO user2
GRANT ALL PRIVILEGES ON v.view1 TO user2
GRANT INSERT ON v.view1 TO user2

Answer

Correct Option: D

Question 7

Assume PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1 but not remove them?

technology databases

REVOKE DROP ON T1 FROM PUBLIC
REVOKE UPDATE ON T1 FROM PUBLIC
REVOKE DELETE ON T1 FROM PUBLIC
REVOKE CONTROL ON T1 FROM PUBLIC

Answer

Correct Option: C

Question 8

A DRDA host database resides on a z/OS or an i5/OS and listens on port 446. The TCP/IP address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?

technology databases

CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446
CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1
CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1

Answer

Correct Option: B

Question 9

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?

technology databases

User ID/Password File
Communications Layer
Client Applications
Operating Systems

Answer

Correct Option: D

Question 10

Which of the following tools for DB2 V9 allows user to create and debug an SQL Stored Procedure

technology databases

Control Center
Development Center
Developer Work Bench
Stored Procedure Builder

Answer

Correct Option: C

Question 11

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

technology databases

Journal
Task Center
Control Center
Activity Monitor

Answer

Correct Option: A

Question 12

which of the following tools is used to analyze all of the database operations by an application against a DB2 for i5/OS database?

technology databases

Visual Explain
Activity Monitor
SQL Performance Monitor
DB2 Performance Monitor

Answer

Correct Option: C

Question 13

A user invoking a User Defined Function (UDF) requires which DB2 Privilege?

technology databases

Call
Usage
Execute
Reference

Answer

Correct Option: C

Question 14

Which of the following privileges permit a user to update the comment on sequence?

technology databases

Control
Update
Usage
Later

Answer

Correct Option: D

Question 15

Which of the following best describes the age of the data in an OLTP System?

technology databases

Current
Projected
Historical
Current and Projected

Answer

Correct Option: A

Question 16

On which of the following database objects may the Select Privilege be controlled?

technology databases

Sequence
Schema
Group
View

Answer

Correct Option: D

Question 17

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

technology databases

Flat earth
E-D square
Trapezoidal
Round Earth

Answer

Correct Option: D

Question 18

Which of the following tools can be used to schedule a backup operation that is to be run on every Saturday?

technology databases

Journal
Task Center
Activity Monitor
Command Line Processor

Answer

Correct Option: B

Question 19

Which of the following products is used to shred Extensible Mark up Language documents?

technology databases

DB2 AVI Extender
DB2 Text Extender
DB2 XML Extender
DB2 Spatial Extender

Answer

Correct Option: C

Question 20

Which of the following does DB2 Configuration Advisor recommend?

technology databases

SQL statements
New indexes
DDL
Database configuration parameter settings

Answer

Correct Option: D

Description: databases Online Quiz - 78
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 78

Find more quizzes from top tags