最新的IBM C2090-730免費考試真題

問題1

If a view named V1 is created in such a way that it references every column in a table named EMPLOYEE except a column named SALARY, which of the following is NOT an accurate statement?

A. View V1 can be used in the same context as the EMPLOYEE table for all data retrieval operations that do not acquire SALARY information

B. View V1 does not have to reside in the same schema as the EMPLOYEE table

C. View V1 can be used as a data source for other views

D. All data, except SALARY data that is stored in the EMPLOYEE table is copied to the physical location associated with view V1

正確答案: D

問題2

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 RIGHT OUTER JOIN points p ON n.name = p.name

B. SELECT p.name,n.number, p.points FROM names n LEFT OUTER 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 INNER JOIN points p ON n.name = p.name

正確答案: A

問題3

What is the purpose of the Design Advisor?

A. To analyze workloads and make recommendations for indexes and MQTs

B. To replicate data between a DB2 database and another relational database

C. To configure clients so they can access databases stored on remote servers

D. To present a graphical representation of a data access plan and recommend design changes that will improve performance

正確答案: A

問題4

Which of the following statements will catalog the database MYDB on the node MYNODE and assign it the alias MYNEWDB?

A. CATALOG DATABASEmydb AS mynewdb AT NODE mynode

B. CATALOG DATABASEmynewdb AT NODE mynode

C. CATALOG DATABASEmydb AT NODE mynode

D. CATALOG DATABASEmynewdb AS mydb AT NODE mynode

正確答案: A

問題5

A database named TEST_DB resides on a z/OS system and listens on port 446. The TCP/IP address for this system is 192.168.10.20 and the TCP/IP host name is MYHOST. Which of the following commands is required to make this database accessible to a Linux client?

A. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;

B. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446;
CATALOG DATABASE zos_db AS test_db AT NODE zos_srvr;
CATALOG DCS DATABASE zos_db AS test_db;

C. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 446;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;

D. CATALOG TCPIP NODEzos_srvr REMOTE myhost SERVER 192.168.10.20;
CATALOG DCS DATABASE zos_db AS test_db AT NODE zos_srvr;

正確答案: C

問題6

If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING '1/1/2007' ENDING '12/31/2007'
EVERY 3 MONTHS)
Which of the following statements is true?

A. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned

B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement

C. If an index is created for the SALES table, its data must be stored in table space TBSP0

D. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level

正確答案: B

問題7

Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

A. Informational constraint

B. Default constraint

C. Check constraint

D. Unique constraint

正確答案: D

問題8

Application A wants to read a subset of rows from table TAB1 multiple times. Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?

A. Cursor Stability

B. Read Stability

C. Repeatable Read

D. Uncommitted Read

正確答案: C

問題9

When does a view get populated?

A. When it is created

B. Any time an executable SQL statement references it

C. When it is referenced in an INSERT statement

D. The first time any executable SQL statement references it

正確答案: B

最新的IBM DB2 9 Family Fundamentals - C2090-730免費考試真題

聯系我們

站內鏈接

最新更新