Breathing of C2090-730 latest exam materials and answers for IBM certification for client, Real Success Guaranteed with Updated C2090-730 pdf dumps vce Materials. 100% PASS DB2 9 Family Fundamentals exam Today!
2021 May C2090-730 Study Guide Questions:
Q71. A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?
A. REFERENCES
B. SELECT
C. UPDATE
D. ALTER
Answer: D
Explanation:
Q72. When does a view get populated?
A. When it is created
B. When it is referenced in an INSERT statement
C. The first time any executable SQL statement references it
D. Any time an executable SQL statement references it
Answer: D
Explanation:
Q73. Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?
A. INTEGER
B. REAL
C. NUMERIC(7, 3)
D. DECIMAL(10, 3)
Answer: D
Explanation:
Renovate C2090-730 vce:
Q74. Which of the following DB2 data types does NOT have a fixed length?
A. INT
B. CHAR
C. XML
D. DOUBLE
Answer: C
Explanation:
Q75. Which of the following is NOT a characteristic of a unique index?
A. Each column in a base table can only participate in one unique index, regardless of how the columns are grouped (the same column cannot be used in multiple unique indexes)
B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute
C. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value
D. A unique index can only be created for a non-nullable column
Answer: D
Explanation:
Q76. Which of the following best describes a unit of work?
A. It is a recoverable sequence of operations whose point of consistency is established when a connection to a database has been established or when a mechanism known as asavepoint is created.
B. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.
C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.
D. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as a savepoint is created.
Answer: C
Explanation:
Guaranteed C2090-730 braindumps:
Q77. Application A is running under the Repeatable Read isolation level and holds an Update lock on table TAB1. Application B wants to query table TAB1 and cannot wait for Application A to release its lock. Which isolation level should Application B run under to achieve this objective?
A. Repeatable Read
B. Read Stability
C. Cursor Stability
D. Uncommitted Read
Answer: D
Explanation:
Q78. On which of the following database objects may the SELECT privilege be controlled?
A. Sequence
B. Schema
C. Group
D. View
Answer: D
Explanation:
Q79. If the following SQL statements are executed:
CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));
CREATE TABLE model (modelid SMALLINT, model VARCHAR(25), makeid SMALLINT, CONSTRAINT const1 FOREIGN KEY (makeid) REFERENCES make(makeid) ON DELETE RESTRICT);
And each table created is populated as follows:
MAKE
MAKEID MAKE
1 Ford 2 Chevrolet 3 Toyota
MODEL
MODELID MODEL MAKEID 1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3
If the following SQL statement is executed:
DELETE FROM make WHERE makeid = 1
What is the total number of rows that will be deleted?
A. 0
B. 1
C. 2
D. 3
Answer: A
Explanation:
Q80. What does the following statement do?
GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION
A. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.
B. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give CONTROL authority for the sequence to other users and groups.
C. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
D. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
Answer: C
Explanation: