Guaranteed IBM C2090-616 Dumps Online

NEW QUESTION 1
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 2
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?

• A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT
• B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT commandexecuted after the COMMIT command
• C. It finishes the current T1 unit of work and a new one is initiated, however it is possible to ROLLBACK to the latest SAVEPOINT before COMMIT
• D. It finishes the current T1 unit of work and a new one is initiate
• E. All changes made by UPDATE and DELETE commands during unit of work T1 are committed

Answer: D

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

Answer: A

NEW QUESTION 4
Which of the following statements about stored procedures is TRUE?

• A. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect
• B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
• C. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
• D. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Answer: B

NEW QUESTION 5
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 6
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 7
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 8
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 9
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 runtimeexecution, and ranks each WORKDEPT by SALARY

Answer: B

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

NEW QUESTION 11
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 12
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 13
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 14
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• A. COMMIT
• B. SAVEPOINT
• C. ROLLBACK WORK
• D. UPDATE TERMINATE

Answer: C

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

NEW QUESTION 16
Which of the following statements regarding locking is TRUE?

• A. The same lock modes apply to tables, rows, or blocks
• B. Lock conversion can take place implicitly as a query executes
• C. Changing the mode of a lock that is already held is called lock escalation
• D. Lock conversion is not necessary if an X lock is required and an S or U lock is currently held

Answer: B

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

Answer: CD

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

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

Answer: CE

NEW QUESTION 21
......