IBM C2090-616 Braindumps 2021

NEW QUESTION 1
Which of the following set operators can be used to find all rows that are common in 2 queries?

• A. UNION
• B. UNION ALL
• C. EXCEPT ALL
• D. INTERSECT ALL

Answer: B

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

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

NEW QUESTION 4
Which of the following authorities are sufficient for creating a database? (Choose two.)

• A. DBADM
• B. SYSADM
• C. SECADM
• D. SYSCTRL
• E. SYSMAINT

Answer: BD

NEW QUESTION 5
Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

• A. CREATE TABLE t1 (c1 INT, c2 INT);
• B. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;
• C. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;
• D. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;

Answer: B

NEW QUESTION 6
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 7
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 8
If the LOCKSIZE for a table is changed from TABLE to ROW, which of the following is TRUE?

• A. Concurrency may be improved
• B. Lock escalation will be prevented
• C. Query performance will be reduced
• D. The number of locks for the same workload will be reduced

Answer: A

NEW QUESTION 9
Which three facilities are used to control authorization in DB2?

• A. privileges, db2ssh, LBAC credentials
• B. privileges, authority levels, certificates
• C. db2ssh, trusted contexts, authority levels
• D. privileges, authority levels, LBAC credentials

Answer: D

NEW QUESTION 10
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 11
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

NEW QUESTION 12
Which of the following statements about triggers are TRUE? (Choose two.)

• A. There is a limit of 8 for the maximum number of cascading trigger activations
• B. Triggers can be activated as a result of changes due to referential constraint enforcement
• C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
• D. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
• E. The activation of the triggers for a particular table, event and activation time are conducted in descendingorder of trigger creation time

Answer: BD

NEW QUESTION 13
Which of the following is TRUE about indexes on column organized tables?

• A. No indexes are allowed
• B. Indexes are only allowed on numeric columns
• C. Indexes are automatically created to enforce unique constraints
• D. An index is only allowed on the synopsis table supporting a column organized table

Answer: A

NEW QUESTION 14
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 15
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?

• A. Deadlock
• B. Lock timeout
• C. Lock escalation
• D. Lock conversion

Answer: A

NEW QUESTION 16
A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

• A. Easy scalability
• B. Management of very large data sets
• C. Continuously available dataset solution
• D. Increased throughput of many concurrent short running queries
• E. Faster response time of long-running or complex queries with I/O spread across many computers

Answer: BE

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

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

Answer: D

NEW QUESTION 18
A user executes the following statements: REATE TABLE t1 (c1 INT, c2 INT); CREATE ALIAS a1 FOR t1;
What will be the result if the user executes the following statement? DROP ALIAS a1;

• A. The alias A1 will be dropped
• B. The table T1 will be dropped
• C. Both T1 and A1 will be dropped
• D. Nothing, the statement will result in an error

Answer: A