Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
A. Shadow tables cannot be queried directly
B. Shadow tables do not store their data on disk
C. Shadow tables must be organized by column
D. Shadow tables must be maintained by replication
E. You cannot join shadow tables to other kinds of tables
Which isolation level will allow application A to immediately read the committed value of a row that is exclusively locked by application B?
A. Read Stability
B. Cursor Stability
C. Repeatable Read
D. Cursor Stability with WAIT FOR OUTCOME clause
The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?
A. SYSCAT.DBAUTH
B. SYSIBMADM.GRANTS
C. SYSIBMADM.PRIVILEGES
D. SYSCAT.USER_TAB_PRIVS
A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?
A. Shadow tables
B. Range-partitioned tables
C. Materialized query tables
D. Multidimensional clustering tables
Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability?
A. DB2 HADR
B. DB2 pureScale
C. DB2 Express-C
D. DS2 Database Partitioning Feature
If you are already connected to a database, what does running the following statement do? Db2 CONNECT
A. Prompts you for the database name or alias
B. Returns information about the current server
C. Prompts you for the authentication information
D. Returns an error, because you provided no database or alias
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
A. Read Stability
B. Cursor Stability
C. Repeatable Read
D. Uncommitted Read
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)
A. db2look with the -x option
B. db2pd with the -auth option
C. Query the SYSCAT.DBAUTH view
D. Query the SYSCAT.TABLES view
E. Query the SYSCAT.TABAUTH view
Which of the following editions of DB2 include support for Federation with Oracle database?
A. DB2 Express-C
B. DB2 Developer Edition
C. DB2 Enterprise Server Edition
D. DB2 Workgroup Server Edition
With HADR, which of the following configuration and topology choices provides the highest level of protection from potential loss of data in a pureScale environment?
A. Principal standby with SYNC synchronization mode
B. Auxiliary standby with SYNC synchronization mode
C. Principal standby with NEARSYNC synchronization mode
D. Auxiliary standby with SUPERSYNC synchronization mode
