Your success in IBM C2090-610 is our sole target and we develop all our C2090-610 braindumps in a way that facilitates the attainment of this target. Not only is our C2090-610 study material the best you can find, it is also the most detailed and the most updated. C2090-610 Practice Exams for IBM C2090-610 are written to the highest standards of technical accuracy.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-610 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-610 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-610-exam-dumps.html
Q51. 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 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.
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 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.
Answer: A
Explanation:
Q52. Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?
A. ALTER TABLE sales ADD COLUMN item CHAR(40);
B. ALTER TABLE sales ALTER COLUMN item CHAR(40);
C. ALTER TABLE sales MODIFY COLUMN item CHAR(40);
D. ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
Answer: D
Explanation:
Q53. A table named STATES was created as follows:
What will happen?
A. An error will be returned and the operation will fail.
B. A warning will be returned and the unique index INDX1 will become the index for the primary key.
C. The primary key will be successfully added and the unique index INDX1 will be dropped and recreated as the primary key index.
D. The primary key will be successfully added, the unique index INDX1 will be dropped, and a new index will be created for the primary key.
Answer: B
Explanation:
Q54. Which object can a buffer pool be assigned to?
A. Schema
B. Table space
C. Storage group
D. Stored procedure
Answer: B
Explanation:
Q55. 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 privileges together so that they can be simultaneously granted to and revoked from multiple users.
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 users together so that they can be simultaneously granted and revoked specific authorities and privileges.
Answer: B
Explanation:
Q56. Which privilege is required to invoke a user defined function?
A. CALL
B. USAGE
C. EXECUTE
D. REFERENCES
Answer: C
Explanation:
Q57. Which statement about large object (LOB) locators is true?
A. A LOB locator is a data type that is used to store LOB data in binary files.
B. A LOB locator is a data type that is used to store LOB data in a database.
C. A LOB locator represents a value for a LOB resource that is stored in a database.
D. A LOB locator represents a value for a LOB resource that is stored in a binary file.
Answer: C
Explanation:
Q58. What are INSTEAD OF triggers used for?
A. To update data in other tables.
B. To perform insert, update, and delete operations against complex views.
C. To check or modify values before they are actually stored in a database.
D. To run non-database operations that are coded in user-defined functions.
Answer: B
Explanation:
Q59. What is the primary purpose of a view?
A. To enable uniqueness.
B. To ensure data clustering.
C. To combine data from multiple tables.
D. To optimize queries ran against multiple tables.
Answer: C
Explanation:
Q60. Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?
A. GRANT ALTER ON SEQUENCE myseq TO user1
B. GRANT USAGE ON SEQUENCE myseq TO user1
C. GRANT SELECT ON SEQUENCE myseq TO user1
D. GRANT COMMENT ON SEQUENCE myseq TO user1
Answer: A
Explanation: