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