High value of C2090-610 practice exam materials and dump for IBM certification for IT learners, Real Success Guaranteed with Updated C2090-610 pdf dumps vce Materials. 100% PASS DB2 10.1 Fundamentals exam Today!
2021 Apr C2090-610 Study Guide Questions:
Q11. Which statement about INSERT operations is true?
A. The INSERT statement is used to insert rows into a table, view, or table function.
B. Inserted values must satisfy the conditions of any check constraints defined on the table.
C. If an INSERT statement omits any column from the inserted row that is defined as NULL or NOT NULL WITH DEFAULT, the statement will fail.
D. If the underlying table of a view being referenced by an INSERT statement has one or more unique indexes, each row inserted does not have to conform to the constraints imposed by those indexes.
Answer: B
Explanation:
Q12. Which object can be enabled for compression?
A. View
B. Buffer pool
C. Storage group D. Temporary table
Answer: D
Explanation:
Q13. Which statement will prevent concurrent application processes from performing anything other than read-only operations against a table named TAB1?
A. LOCK TABLE tab1 IN READ MODE
B. LOCK TABLE tab1 IN SHARE MODE
C. LOCK TABLE tab1 IN EXCLUSIVE MODE
D. LOCK TABLE tab1 IN READ-ONLY MODE
Answer: B
Explanation:
Leading C2090-610 exams:
Q14. What is a function of a table check constraint?
A. To provide a method of avoiding duplicate entries for a column.
B. To provide a method of ensuring a column's values are within a specific range.
C. To ensure that XML columns are properly populated in an associated XML table space.
D. To enforce relationships between tables by checking the existence of rows in one table against another.
Answer: B
Explanation:
Q15. Which statement about system-period temporal tables is true?
A. They store user-based period information.
B. They do not have a separate history table.
C. They can be queried without a time period specification.
D. They manage data based on time criteria specified by users or applications.
Answer: C
Explanation:
Q16. If a user has been granted SYSCTRL authority, which activities can they perform?
A. Load operations
B. Backup/copy table spaces
C. Create and drop databases
D. Monitor database performance
Answer: C
Explanation:
Precise C2090-610 :
Q17. When is an INTENT EXCLUSIVE (IX) lock required?
A. When a transaction intends to read or change data.
B. When a transaction intends to change but not read data.
C. When a transaction intends to read but not change data.
D. When a transaction intends to change the system catalog.
Answer: A
Explanation:
Q18. When a user-defined function (UDF) is created and no schema is specified, what schema is used to store the UDF?
A. The SYSIBM schema.
B. The SYSFUN schema.
C. A schema with the name of the UDF.
D. A schema with the userid of the UDF definer.
Answer: D
Explanation:
Q19. What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?
A. locator
B. pointer
C. address
D. reference
Answer: A
Explanation:
Q20. When a COMMIT statement is executed, what happens?
A. All locks held on the database are automatically released.
B. Data stored in global temporary tables is automatically deleted.
C. Open cursors defined WITH HOLD are closed, but their data is retained.
D. The current transaction is terminated and a new transaction boundary is started.
Answer: D
Explanation: