Master the C2090-610 DB2 10.1 Fundamentals content and be ready for exam day success quickly with this Ucertify C2090-610 test questions. We guarantee it!We make it a reality and give you real C2090-610 questions in our IBM C2090-610 braindumps.Latest 100% VALID IBM C2090-610 Exam Questions Dumps at below page. You can use our IBM C2090-610 braindumps and pass your exam.
♥♥ 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
Q1. Which tool allows users to connect to a DB2 database using a wizard?
A. Control Center
B. IBM Data Studio
C. Universal Connection Expert
D. DB2 Connection Pool Manager
Answer: B
Explanation:
Q2. 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:
Q3. 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:
Q4. Given the following statement:
GRANT DELETE ON TABLE sales TO User1 WITH GRANT OPTION;
Which statement is correct?
A. USER1 can only remove the SALES table.
B. USER1 can only remove records from the SALES table.
C. USER1 can remove the SALES table and grant the privilege to remove the SALES table to other users.
D. USER1 can remove records from the SALES table and grant the privilege to remove records from the SALES table to other users.
Answer: D
Explanation:
Q5. Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction?
A. Type-1 connect
B. Type-2 connect
C. Type-3 connect
D. Type-4 connect
Answer: B
Explanation:
Q6. A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?
A. SELECT name, COUNT(*) AS transactions FROM sales
B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales
C. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name
D. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions
Answer: C
Explanation:
Q7. If the following command is executed: CREATE DATABASE test What is the page size (in kilobytes) of the database?
A. 4
B. 8
C. 16
D. 32
Answer: A
Explanation:
Q8. What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?
A. Lock exchange
B. Lock promotion
C. Lock escalation
D. Lock conversion
Answer: C
Explanation:
Q9. You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?
A. CLI
B. XML
C. JDBC
D. RUBY
Answer: C
Explanation:
Q10. What factor influences lock escalation?
A. Table size
B. Buffer space
C. Number of locks
D. Available real storage
Answer: C
Explanation: