Actual of C2090-610 exam answers materials and torrent for IBM certification for IT candidates, 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:
Q1. 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:
Q2. If a table named MY_TAB contains 100 rows and the following statement is executed:
What will happen?
A. The last 5 rows in the table will be deleted.
B. The first 5 rows in the table will be deleted.
C. The statement will fail because a subquery cannot be used with a DELETE statement.
D. The statement will fail because a table name was not specified with the DELETE statement.
Answer: A
Explanation:
Q3. What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?
A. Read stability (RS)
B. Cursor stability (CS)
C. Repeatable read (RR)
D. Uncommitted read (UR)
Answer: C
Explanation:
Improved C2090-610 rapidshare:
Q4. 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:
Q5. Application APP_A is performing updates to table TAB1 using the cursor stability (CS) isolation level. If application APP_B wants to retrieve all rows from table TAB1 without waiting for application APP_A to finish making updates, what isolation level must application APP_B use?
A. Read Stability (RS)
B. Repeatable Read (RR)
C. Uncommitted Read (UR)
D. Cursor Stability (CS)
Answer: C
Explanation:
Q6. What factor influences lock escalation?
A. Table size
B. Buffer space
C. Number of locks
D. Available real storage
Answer: C
Explanation:
Exact C2090-610 testing bible:
Q7. Which event will NOT cause a trigger to be fired?
A. Execution of an INSERT statement.
B. Execution of LOAD REPLACE operation.
C. Execution of an INSERT operation of a MERGE statement.
D. Execution of an UPDATE operation of a MERGE statement.
Answer: B
Explanation:
Q8. Which product replaced the Control Center used in versions prior to DB2 v10?
A. IBM Data Studio
B. IBM Administrator
C. IBM Data Manager
D. IBM Command Center
Answer: A
Explanation:
Q9. Which type of constraint can be used to tell the DB2 Optimizer that a parent-child relationship exists between two tables, but that the relationship is not enforced?
A. Check
B. Unique
C. Referential
D. Informational
Answer: D
Explanation:
Q10. If the following result set is desired:
Which SQL statement must be executed?
A. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS ONLY
B. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS ONLY
C. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 FETCH FIRST 5 ROWS
D. SELECT lastname, firstnme, salary, job FROM employee ORDER BY 3 DESC FETCH FIRST 5 ROWS
Answer: B
Explanation: