DB2 11.1 Fundamentals for LUW v1.0 (C2090-616)

Page:    1 / 5   
Total 66 questions

Which of the following is TRUE about DB2 OLAP functions?

  • A. They return scalar values and not array values
  • B. There are no DB2 monitor elements specific to OLAP functions
  • C. OLAP functions are not supported in a common table expression (CTE)
  • D. OLAP aggregation functions are not supported with column organized tables C


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?

  • A. SYSCAT.DBAUTH
  • B. SYSIBMADM.GRANTS
  • C. SYSIBMADM.PRIVILEGES
  • D. SYSCAT.USER_TAB_PRIVS


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?

  • A. You cannot switch user id in a trusted context
  • B. You can issue a switch-user request within a transaction
  • C. The new user must have the connect-privilege on the database for it to succeed
  • D. No password is ever required for the new user as an authentication is established in the trusted connection


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?

  • A. Read Stability
  • B. Cursor Stability
  • C. Repeatable Read
  • D. Uncommitted Read


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?

  • A. pureScale
  • B. auto reorg
  • C. BLU acceleration
  • D. Self tuning memory manager


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?

  • A. It ranks the rows in each WORKDEPT by SALARY
  • B. It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY
  • C. It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY
  • D. It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtime execution, and ranks each WORKDEPT by SALARY


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?

  • A. View
  • B. Alias
  • C. Table
  • D. Schema


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?

  • A. 32672 bytes
  • B. 65344 bytes
  • C. 98016 bytes
  • D. 130688 bytes A


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?

  • 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


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?

  • A. Application 2 will read the amount of 90
  • B. Application 2 will read the amount of 100
  • C. Application 2 will receive a warning message
  • D. Application 2 will enter lock-wait state until application 1 commits or the locktimeout value expires


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?

  • A. The statement will fail due to variable length character error
  • B. The statement will fail due to an incompatible data type error
  • C. The statement will execute successfully and it deletes the character data
  • D. The statement will execute successfully and it internally converts the character data into ASCII numbers


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?

  • A. SELECT
  • B. DELETE
  • C. UPDATE
  • D. CONTROL


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?

  • A. INSERT INTO t1 VALUES (100)
  • B. INSERT INTO t1 (c1, c2) VALUES (100)
  • C. INSERT INTO t1 (c1, c3) VALUES ("˜100"™, "˜100.00"™)
  • D. INSERT INTO t1 (c2, c3) VALUES (100, 100.00), (101, 101)


Answer : B

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


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.)

  • 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 CD


Answer : Explanation

Page:    1 / 5   
Total 66 questions