Which two of the following authorities allow a user to create a new database?
Which two of the following authorities allow a user to create a new database? A. SYSADMN B. SYSCTRL C. SYSMAINT D. DBADM E. CREATEDB
Which two of the following authorities allow a user to create a new database? A. SYSADMN B. SYSCTRL C. SYSMAINT D. DBADM E. CREATEDB
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? A. Encrypt the table’s data B. Create a view that does not…
In which situation is shredding XML data recommended? A. When the data is naturally tabular B. When the number of nodes are volatile C. When the data by nature has sparse attributes D. When the data is of low volume…
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure? A. Control Center B. Development Center C. Developer Workbench D. Stored Procedure BuilderSecurity
Which of the following is NOT a valid method of authentication that can be used by DB2 9? A. SERVER B. SERVER_ENCRYPT C. CLIENT D. DCS
In a client-server environment, which two of the following can be used to verify passwords? A. System Catalog B. User ID/password file C. Client Operating System D. Communications layer E. Application Server
Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications? A. Journal B. Task Center C. Control Center D. Activity Monitor
Which of the following is a typical data warehouse query? A. What is this customer’s address? B. Does this customer have any unpaid bills? C. What is the balance in this customers account? D. What are the total sales for…
Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server? A. DB2 Express Edition B. DB2 Personal Edition C. DB2 Workgroup Server Edition D. DB2 Enterprise Server Edition
Which of the following best describes the age of the data in an OLTP system? A. Current B. Projected C. Historical D. Current and projected