IBM C2090-616 Free Practice Questions

NEW QUESTION 1
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?

• A. NOT NULL
• B. Foreign key
• C. Primary key
• D. Informational constraint

Answer: C

NEW QUESTION 2
What of the following is TRUE about triggers?

• A. Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
• B. Triggers can be used to perform data manipulation operations against complex views
• C. Triggers can only be used to execute logic before or after appropriate SQL statements
• D. Only one trigger for a particular event and activation time can be created for a particular table

Answer: A

NEW QUESTION 3
Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

• A. Sequence
• B. Row Identifier
• C. Identity Column
• D. Insert time clustering table

Answer: A

NEW QUESTION 4
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

NEW QUESTION 5
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

• A. DELETE FROM t1
• B. DELETE* FROM t1
• C. DELETE* TABLE t1
• D. TRUNCATE TABLE t1 IMMEDIATE
• E. TRUNCATE TABLE t1

Answer: AB

NEW QUESTION 6
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

Answer: B

NEW QUESTION 7
Which optional NPS compatibility features will be activated by executing the following? (Choose two.) SET SQL_COMPAT=‘NPS’

• A. YEARSBETWEEN
• B. BINARY and VARBINARY data types
• C. Double-dot notation to specify a database object
• D. OFFSET x ROWS FETCH FIRST y ROWS ONLY
• E. TRANSLATE (char-string-exp, from-string-exp, to-string-exp)

Answer: CE

NEW QUESTION 8
Your manager has asked you to review cloud service offering for hosting a DB2 database. As the DBA, you still want to maintain control over all maintenance and patching operations. Which of the following Cloud offerings best suits your needs?

• A. Cloudant
• B. DB2 on Cloud
• C. dashDB for analytics
• D. dashDB for transactions

Answer: B

NEW QUESTION 9
What is the primary use case for creating an index with the RANDOM option on a table?

• A. Maximize performance with OLTP random key queries
• B. Maximize performance when inserting into an expression based index containing the RAND() function
• C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment
• D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Answer: C

NEW QUESTION 10
Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

• A. DB2 Connect
• B. DB2 Runtime Client
• C. DB2 Data Server Client
• D. DB2 Enterprise Server Edition

Answer: A

NEW QUESTION 11
Which operation typically requires a Share (S) lock?

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

Answer: D

NEW QUESTION 12
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

Answer: C

NEW QUESTION 13
Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’ Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’

• A. 1
• B. 3
• C. 5

Answer: C

NEW QUESTION 14
Which of the following authorities is sufficient for connecting to a database?

• A. SQLADM
• B. CONNECT
• C. DATAACESS
• D. ACCESSCTRL

Answer: D

NEW QUESTION 15
DB2 offers compatibility features through the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable that improve application compatibility with which of the following? (Choose two.)

• A. Oracle
• B. Sybase
• C. Netezza
• D. MongoDB
• E. Microsoft SQL Server

Answer: AB

NEW QUESTION 16
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

NEW QUESTION 17
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

NEW QUESTION 18
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

NEW QUESTION 19
What is the purpose of a role?

• A. To define exactly what a specific user can and cannot do within a particular database once they have been authenticated
• B. To group a collection of users together so that they can be simultaneously granted and revoked specific authorities and privileges
• C. To group a collection of privileges together so that they can be simultaneously granted to and revoked frommultiple users, groups, or other roles
• D. To assign one or more users that need to run local DB2 applications and tools on a particular server to theDB2ADMNS or the DB2USERS group

Answer: A

NEW QUESTION 20
Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.)

• A. No other applications can access the table
• B. Only uncommitted read (UR) applications can access the table
• C. The lock owner and other applications can read, but not update, the locked table
• D. The lock owner can both read and update dat
• E. Other applications can read the table
• F. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Answer: AE

NEW QUESTION 21
......