Which of the following is TRUE about DB2 OLAP functions?
Answer : Explanation
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?
Answer : A
Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/t0005823.html
Which of the following is TRUE regarding user switching in a trusted context?
Answer : D
Reference: https://www.ibm.com/support/knowledgecenter/ca/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005435.html
Which of the following isolation levels most reduces concurrency and is most likely to cause lock escalations?
Answer : C
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/com.ibm.db2.luw.admin.perf.doc/doc/c0004121.html
Which of the following features can provide significant benefits in storage savings, performance of analytic workloads, and time to value?
Answer : C
Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1309db2bluaccel/index.html
Consider the following SQL statement:
SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary
FROM employee -
ORDER BY workdept, lastname -
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?
Answer : B
Reference: https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/sqlp/rbafyolap.htm
Which of the following DB2 objects in an efficient way of representing data without the need to maintain it and requires no permanent storage?
Answer : A
Reference: https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0004106.html
What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?
Answer : Explanation
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.8.0/com.ibm.db2.luw.apdv.porting.doc/doc/r0052880.html
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?
Answer : A
Explanation:
Standby databases are synchronized with the primary database through log data that is generated on the primary and shipped to the standbys. The standbys constantly roll forward through the logs. You can choose from four different synchronization modes. In order of most to least protection, these are SYNC,
NEARSYNC, ASYNC, and SUPERASYNC.
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.admin.ha.doc/doc/c0011267.html
Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES ("˜John,100);
COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME="˜John"™;
After a few seconds, application 2 executes the following query:
SELECT AMOUNT FROM TAB1 WHERE NAME="˜John"™
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?
Answer : B
Reference: https://www.ibm.com/support/knowledgecenter/pt/SSEPGG_9.7.0/com.ibm.db2.luw.admin.config.doc/doc/r0053556.html
Below are the SQL statements a DBA is planning to execute on a database:
CREATE TABLE t1 (name VARCHAR (1));
INSERT INTO t1 VALUES ("˜A"™), ("˜B"™), ("˜C"™), ("˜D"™);
ALTER TABLE t1 ALTER COLUMN name SET DATA TYPE INT;
What will be the outcome of the last statement?
Answer : C
Reference: https://dev.mysql.com/doc/refman/5.5/en/alter-table.html
The creator of an index or an index specification automatically receives which privilege on the index?
Answer : D
Reference:
https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/doc/r0000966.html
The DDL statement is used to create table T1:
CREATE TABLEt1 (
c1 INTEGER,
c2 INTEGER NOT NULL,
c1 DECIMAL(11,2),
c4 TIMESTAMP WITH DEFAULT CURRENT TIMESTAMP
)
Which of the following INSERT statements will execute successfully?
Answer : B
If you are already connected to a database, what does running the following statement do?
Db2 CONNECT -
Answer : B
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_connect.html
Shadow tables are a special kind of Materialized Query Table, but what makes them different? (Choose two.)
Answer : Explanation