• databases Online Quiz - 78
Back
0

databases Online Quiz - 78

Description: databases Online Quiz - 78
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

  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

Show answer
Correct Option: C

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

  1. CONNECT

  2. CONTROL

  3. SYSMAINT

  4. EXECUTE

Show answer
Correct Option: C

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

  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

Show answer
Correct Option: D

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

  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

Show answer
Correct Option: D

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

  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.

Show answer
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?

technology databases

  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

Show answer
Correct Option: D

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

  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

Show answer
Correct Option: C

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

  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

Show answer
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?

technology databases

  1. User ID/Password File

  2. Communications Layer

  3. Client Applications

  4. Operating Systems

Show answer
Correct Option: D

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

  1. Control Center

  2. Development Center

  3. Developer Work Bench

  4. Stored Procedure Builder

Show answer
Correct Option: C

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

technology databases

  1. Journal

  2. Task Center

  3. Control Center

  4. Activity Monitor

Show answer
Correct Option: A

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

  1. Visual Explain

  2. Activity Monitor

  3. SQL Performance Monitor

  4. DB2 Performance Monitor

Show answer
Correct Option: C

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

  1. Call

  2. Usage

  3. Execute

  4. Reference

Show answer
Correct Option: C

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

  1. Control

  2. Update

  3. Usage

  4. Later

Show answer
Correct Option: D

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

  1. Current

  2. Projected

  3. Historical

  4. Current and Projected

Show answer
Correct Option: A

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

  1. Sequence

  2. Schema

  3. Group

  4. View

Show answer
Correct Option: D

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

technology databases

  1. Flat earth

  2. E-D square

  3. Trapezoidal

  4. Round Earth

Show answer
Correct Option: D

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

  1. Journal

  2. Task Center

  3. Activity Monitor

  4. Command Line Processor

Show answer
Correct Option: B

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

  1. DB2 AVI Extender

  2. DB2 Text Extender

  3. DB2 XML Extender

  4. DB2 Spatial Extender

Show answer
Correct Option: C

Which of the following does DB2 Configuration Advisor recommend?
technology databases

  1. SQL statements

  2. New indexes

  3. DDL

  4. Database configuration parameter settings

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions