Simulation of C2090-730 answers materials and keys for IBM certification for IT specialist, 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:
Q61. Which of the following tools can be used to catalog a database?
A. Visual Explain
B. Alert Center
C. Journal
D. Configuration Assistant
Answer: A
Explanation:
Q62. Which of the following actions may cause a trigger to be fired?
A. DROP
B. ALTER
C. DELETE
D. ROLLBACK
Answer: C
Explanation:
Q63. What is the maximum size that can be specified when creating an XML column in a DB2 table?
A. No size is specified
B. The buffer pool size
C. The page size for the table space
D. The extent size for the table space
Answer: A
Explanation:
Far out C2090-730 book:
Q64. Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER
Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?
A. The next value will be 0 and the sequence will never use the values 101 to 105.
B. The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
C. Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
D. The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
Answer: D
Explanation:
Q65. Which of the following supports the XML data type?
A. A unique index
B. A composite index
C. A check constraint
D. A generated column
Answer: A
Explanation:
Q66. Which of the following can NOT be used to restrict specific values from being inserted into a column in a particular table?
A. Index
B. Check constraint
C. Referential constraint
D. Default constraint
Answer: D
Explanation:
Guaranteed C2090-730 software:
Q67. For which of the following is a data warehouse optimized?
A. Backup and recovery
B. Transactions
C. Security
D. Queries
Answer: D
Explanation:
Q68. Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?
A. Define the column MAINID as NOT UPDATABLE.
B. Define the column MAINID as a PRIMARY KEY.
C. Define the column MAINID as a FOREIGN KEY.
D. Define an UPDATE trigger on table TABLEX.
Answer: D
Explanation:
Q69. Which of the following is NOT true about XML columns?
A. Data can be retrieved by SQL.
B. Data can be retrieved by XQuery.
C. XML columns must be altered to accommodate additional parent and child relationships.
D. Access to any portion of an XML document can be direct, without reading the whole document.
Answer: C
Explanation:
Q70. Which of the following strings can be inserted into an XML column using XMLPARSE?
A. "<employee/>"
B. "<?xml version='1.0' encoding='UTF-8' ?>"
C. "<!DOCTYPE hello SYSTEM 'hello_world.dtd'>"
D. "<x xmlns:ibmcert='http://www.ibm.com/certify'>"
Answer: A
Explanation: