databases Online Quiz - 79
Description: databases Online Quiz - 79 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Which of the following is the major difference between relational data and XML data?
Which of the following is the major difference between relational data and XML data?
Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?
Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?
Which of the following tools can be used to catalog a database?
Which of the following is used to create and debug user-defined functions?
Which of the following DB tools allow the user to execute an SQL statement and view a graphical representation of the access plan?
For which of the following is a data warehouse optimized?
Which of the following is a typical data warehouse query?
Which of the following best describes the age of the data in an OLTP system?
) Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
Which of the following is NOT a valid method of authentication that can be used by DB2 9?
A table named DEPARTMENT has the following columns: DEPT_ID DEPT_NAME MANAGER AVG_SALARY Which of the following is the best way to prevent most users from viewing AVG_SALARY data?
Assuming USER1 has no authorities or privileges, which of the following will allow USER1 to create a view named VIEW1 that references two tables named TAB1 and TAB2?
After the following SQL statement is executed: GRANT ALL PRIVILEGES ON TABLE employee TO USER user1 Assuming user USER1 has no other authorities or privileges, which of the following actions is USER1 allowed to perform?
A user wishing to invoke an SQL stored procedure that queries a table must have which of the following privileges?
Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?
Which of the following will provide user USER1 and all members of the group GROUP1 with the ability to perform DML, but no other operations on table TABLE1?