databases Online Quiz - 78
Description: databases Online Quiz - 78 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
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?
Which authority or privilege is granted by the DB2 Database Manager configuration file?
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?
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?
What does the following statement do? GRANT REFERENCES (col1, col2) ON TABLE table1 TO user1 WITH GRANT OPTION
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?
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?
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?
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?
Which of the following tools for DB2 V9 allows user to create and debug an SQL Stored Procedure
Which of the following tools is used to view historical information about tasks, Database changes, messages and notifications.
which of the following tools is used to analyze all of the database operations by an application against a DB2 for i5/OS database?
A user invoking a User Defined Function (UDF) requires which DB2 Privilege?
Which of the following privileges permit a user to update the comment on sequence?
Which of the following best describes the age of the data in an OLTP System?
On which of the following database objects may the Select Privilege be controlled?
Which of the following describes the model used by the Geodetic Extender?
Which of the following tools can be used to schedule a backup operation that is to be run on every Saturday?
Which of the following products is used to shred Extensible Mark up Language documents?
Which of the following does DB2 Configuration Advisor recommend?