100% Correct of C2090-610 actual exam materials and preparation exams for IBM certification for IT specialist, Real Success Guaranteed with Updated C2090-610 pdf dumps vce Materials. 100% PASS DB2 10.1 Fundamentals exam Today!
2021 May C2090-610 Study Guide Questions:
Q21. Which statement about bitemporal tables is valid?
A. Bitemporal tables are system tables and can only be queried by the schema owner.
B. Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.
C. When data in a bitemporal table is updated, a row is added to it's associated history table.
D. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.
Answer: C
Explanation:
Q22. Which statement is true regarding constraints?
A. A table can only have one unique key constraint.
B. A table can have multiple primary key constraints.
C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.
D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.
Answer: C
Explanation:
Q23. When is it appropriate to use a sequence?
A. When you want to control the order in which triggers are fired.
B. When you want to control the order in which stored procedures can be invoked.
C. When you want to automatically generate a numeric value that is not tied to any specific column or table.
D. When you want to automatically generate a numeric value for each row that is added to a specific table.
Answer: C
Explanation:
Latest C2090-610 download:
Q24. Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
A. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON employees.id = sales.emp_id
B. SELECT employees.name, sales.revenue FROM employees INNER JOIN sales ON sales.emp_id = employees.id
C. SELECT employees.name, sales.revenue FROM sales LEFT OUTER JOIN employees ON employees.id = sales.emp_id
D. SELECT employees.name, sales.revenue FROM sales RIGHT OUTER JOIN employees ON employees.id = sales.emp_id
Answer: D
Explanation:
Q25. Which two DB2 objects can a view be derived from? (Choose two.)
A. View
B. Index
C. Table
D. Trigger
E. Procedure
Answer: A,C
Explanation:
Q26. Which type of lock allows the lock owner and all concurrent applications to read, but not update, the locked data?
A. Share (S)
B. Update (U)
C. Exclusive (X)
D. Intent Exclusive (IX)
Answer: A
Explanation:
Precise C2090-610 Q&A:
Q27. What factor influences lock conversion/promotion?
A. Lock size
B. Number of locks
C. Lock mode needed
D. Available real storage
Answer: C
Explanation:
Q28. By default, a column defined as a TIMESTAMP includes which attributes?
A. No fractional digits or time zone.
B. 6 fractional digits and no time zone.
C. 12 fractional digits plus a time zone.
D. 12 fractional digits and no time zone.
Answer: B
Explanation:
Q29. 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:
Q30. Which statement regarding triggers is true?
A. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
B. Triggers cannot be modified, they must be dropped and recreated with new definitions.
C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.
D. Triggers can only be fired one time per statement irrespective of the number of rows affected.
Answer: B
Explanation: