重考一次 C2090-616，等於再付一次報名費，還要再花好幾週重新準備。與其承擔重考成本，不如先用 KaoGuTi 的 65 道練習題，把 IBM DB2 11.1 Fundamentals for LUW 的每個領域練熟再上場。

IBM C2090-616 考試概覽:

認證廠商:	IBM
考試名稱:	IBM DB2 11.1 Fundamentals for LUW
考試代碼:	C2090-616
考試時間:	90 分鐘
證照有效期限:	3 年
考試形式:	單選題, 多選題
實際考試題數:	60-65
相關認證:	IBM Certified Solution Expert - DB2 IBM Certified Advanced Database Administrator - DB2 IBM Certified Database Administrator - DB2
及格分數:	60-65%
支援語言:	英文
考試費用:	USD 200 (因地區而異)
推薦課程:	IBM DB2 培訓課程
考試報名:	IBM 認證註冊 Pearson VUE IBM 考試
範例考題:
考試方式:	線上監考或授權測試中心 (Pearson VUE)
必備條件:	無正式先決條件；建議具備資料庫和 SQL 的基本知識。
官方大綱網址:	https://www.ibm.com/training/certification

IBM C2090-616 考試大綱主題:

C2090-616 認證考試問與答

最新的 IBM Analytics C2090-616 免費考試真題：

問題 #1

Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions?

A. Insert time clustering table
B. Sequence
C. Identity Column
D. Row Identifier

問題 #2

Which of the following is TRUE about indexes on column organized tables?

A. No indexes are allowed
B. An index is only allowed on the synopsis table supporting a column organized table
C. Indexes are only allowed on numeric columns
D. Indexes are automatically created to enforce unique constraints

問題 #3

Which of the following statements about stored procedures is TRUE?

A. There are three types of stored procedures which can be deployed: SQL procedures, external procedures, and sourced procedures
B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database
C. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned
D. Stored procedures can be written in SQL PL, but not in the PL/SQL dialect

問題 #4

The current user wants to produce a list of all user privileges she has been granted. Which table or view can be queried to produce the desired result?

A. SYSCAT.USER_TAB_PRIVS
B. SYSCAT.DBAUTH
C. SYSIBMADM.GRANTS
D. SYSIBMADM.PRIVILEGES

問題 #5

Which of the following statements will successfully create a table that scores index data in a different table space than the table data?

A. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2;
B. CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2;
C. CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1;
D. CREATE TABLE t1 (c1 INT, c2 INT);

問題與答案：