下載最新試用版
788位客戶反饋
我們對我們的產品非常有信心，所以我們不提供会给客户带去麻煩的產品。
IBM A2090-730 考試概覽:
| 認證廠商: | IBM |
|---|---|
| 考試名稱: | IBM DB2 9 系列基礎知識 |
| 考試代碼: | C2090-730 |
| 考試時間: | 90 分鐘 |
| 支援語言: | English |
| 考試形式: | 選擇題 |
| 相關認證: | IBM 認證資料庫助理師 - DB2 9 基礎知識 |
| 實際考試題數: | 55 |
| 推薦課程: | IBM 訓練課程（DB2 基礎知識課程） |
| 考試報名: | IBM 認證入口網站 |
| 範例考題: | IBM A2090-730 範例考題 |
| 考試方式: | 監考式考試（視供應商提供情況，可選擇線上應考或實體考場應考） |
| 必備條件: | 無正式先修要求；建議具備資料庫基礎概念 |
| 官方大綱網址: | https://www.ibm.com/certify |
IBM A2090-730 考試大綱主題:
| 章節 | 目標 |
|---|---|
| 主題 1: 資料庫作業與工具程式 | - 監控與維護
|
| 主題 2: DB2 架構與元件 | - 記憶體與處理程序模型
|
| 主題 3: 資料庫管理基礎 | - 備份與復原基礎知識
|
| 主題 4: 資料庫基礎概念 | - 關聯式資料庫概念
|
最新的 DB2 A2090-730 免費考試真題：
Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11
POINTS
NAME POINTS
Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
Which of the following statements will display the player name, number, and points for all players that have scored points?
- A. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name
- B. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = p.name
- C. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name
- D. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name
答案：D 🗳️
If table TAB1 is created using the following statement:
CREATE TABLE tab1 (col1 INTEGER NOT NULL,
col2 CHAR(5),
CONSTRAINT cst1 CHECK (col1 in (1, 2, 3)))
Which of the following statements will successfully insert a record into table TAB1?
- A. INSERT INTO tab1 VALUES (ABS(2), 'abc')
- B. INSERT INTO tab1 VALUES (NULL, 'abc')
- C. INSERT INTO tab1 VALUES (0, 'abc')
- D. INSERT INTO tab1 VALUES (DEFAULT, 'abc')
答案：A 🗳️
Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
- A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
- B. CREATE DISTINCT TYPE currency AS SMALLINT
- C. CREATE DISTINCT TYPE currency AS DOUBLE
- D. CREATE DISTINCT TYPE currency AS BIGINT
答案：A 🗳️
Which of the following is NOT a difference between a unique index and a primary key?
- A. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.
- B. A table can have many unique indexes but only one primary key.
- C. Unique indexes can be defined over one or more columns that allow null values; primary keys cannot contain null values.
- D. A primary key is a special form of a unique constraint; both use a unique index.
答案：A 🗳️
118.171.149.* -
很感谢 VCESoft 為我提供了 A2090-730 考試最新相關資料，讓我順利的通過了考試，你們是很有用的題庫提供網站。