C2090-610最も有効な質問と解答で勉強

IBM DB2 10.1 Fundamentalsは業界で広く認知された資格であり、取得はキャリアの信頼性を高める確かな一歩となります。Tech4ExamのC2090-610問題集は138問を収録し、公式の出題範囲に沿って学習を組み立てられます。

IBM C2090-610 試験概要:

IBM C2090-610 試験シラバストピック:

C2090-610試験のQ&A – 受験前に知っておきたいこと

IBM DB2 10.1 Fundamentals 認定 C2090-610 試験問題：

問題 #1

When is an INTENT EXCLUSIVE (IX) lock required?

A. When a transaction intends to change the system catalog.
B. When a transaction intends to read but not change data.
C. When a transaction intends to change but not read data.
D. When a transaction intends to read or change data.

問題 #2

Which DB2 object limits the user's ability to retrieve data from a table by defining a SQL statement in the object?

A. Check constraint
B. View
C. Trigger
D. Index

問題 #3

In a trusted context environment, if a switch request is made with an authorization ID that is not allowed on a trusted connection, what state is the connection placed in?

A. Waiting
B. Locked
C. Pending
D. Unconnected

問題 #4

When a COMMIT statement is executed, what happens?

A. The current transaction is terminated and a new transaction boundary is started.
B. Data stored in global temporary tables is automatically deleted.
C. All locks held on the database are automatically released.
D. Open cursors defined WITH HOLD are closed, but their data is retained.

問題 #5

Which SQL statement should be used to select the minimum and maximum salaries (SALARY), by job code (JOB), from a table EMPLOYEE?

A. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job;
B. SELECT job, MIN(salary), MAX(salary)
FROM employee
GROUP BY job, MIN(salary), MAX(salary);
C. SELECT JOB, MIN(salary), MAX(salary)
FROM employee
ORDER BY job, MIN(salary), MAX(salary);
D. SELECT job, MIN(salary), MAX(salary)
FROM employee
ORDER BY job;

解説：