C2090-610 by IBM Actual Free Exam Q&As

Question 1

Which product is used to customize execution environments for the purpose of controlling system resources so that one department or service class does not overwhelm the system?

A. Workload manager B. Self-tuning memory manager C. pureScale D. Data partitioning feature

Discussion 0

Correct Answer: A Vote an answer

Question 2

User USER1 wants to define a required relationship between two tables named TAB1 and TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?

A. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE RESTRICT rule. B. 1) Create a primary key on table TAB2;
2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres
to the ON DELETE CASCADE rule. C. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE RESTRICT rule. D. 1) Create a primary key on table TAB1;
2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres
to the ON DELETE CASCADE rule.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which type of constraint can be used to ensure that an INTEGER column in a table will never be assigned more than one record that contains a NULL value?

A. Informational constraint B. Unique constraint C. Primary key constraint D. Column default constraint

Discussion 0

Correct Answer: B Vote an answer

Question 4

Which statement about application-period temporal tables is true?

A. Is useful when one wants to keep both user-based period information and system-based historical information. B. Is based on explicitly-supplied timestamps that define the time periods during which data is valid. C. Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current. D. Consists of explicitly-supplied timestamps and a separate associated history table.

Discussion 0

Correct Answer: B Vote an answer

Question 5

Which of the following privileges allow a user to update the comment on a sequence?

A. ALTER B. COMMENT C. UPDATE D. USAGE

Discussion 0

Correct Answer: A Vote an answer

Question 6

What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?

A. Read stability (RS) B. Cursor stability (CS) C. Uncommitted read (UR) D. Repeatable read (RR)

Discussion 0

Correct Answer: D Vote an answer

Question 7

Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;
Which statement is correct?

A. USER1 can only remove records from the SALES table. B. USER1 can only remove the SALES table. C. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users. D. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.

Discussion 0

Correct Answer: C Vote an answer

Question 8

What is the purpose of a role?

A. To define exactly what a specific user can 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 establish a credible relationship between DB2 and an external entity, such as a database administrator or a middleware server. D. To group a collection of privileges together so that they can be simultaneously granted to and revoked from multiple users.

Discussion 0

Correct Answer: D Vote an answer

Question 9

Which statement about UPDATE processing is FALSE?

A. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect. B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row. C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified. D. The UPDATE statement logs the before and after value of every column it modifies.

Discussion 0

Correct Answer: C Vote an answer

IBM DB2 10.1 Fundamentals - C2090-610 Exam Practice Test