最新的DB2認證 A2090-730考試題庫

問題1

Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?

A. SELECT * FROM t1 INTERSECT SELECT * FROM t2

B. SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)

C. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

D. SELECT * FROM t1 UNION SELECT * FROM t2

正確答案: C

問題2

Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?

A. CREATE TABLEemp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK edlevel VALUES ('C','H','N')
);

B. CREATE TABLEemp (
empno SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3),
edlevel CHAR(1),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY (workdept) REFERENCES department
(deptno),
CONSTRAINT edlevel_ck CHECK (edlevel IN ('C','H','N'))
);

C. CREATE TABLEemp (
empno SMALLINT NEXTVAL GENERATED ALWAYS AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1),
PRIMARY KEY emp_pk (empno),
FOREIGN KEY emp_workdept_fk ON (workdept) REFERENCES department (deptno),
CHECK edlevel_ck VALUES (edlevel IN ('C','H','N')),
);

D. CREATE TABLEemp (
empno SMALLINT NEXTVAL GENERATED BY DEFAULT AS IDENTITY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
workdept CHAR(3) NOT NULL,
edlevel CHAR(1) CHECK IN ('C','H','N')),
CONSTRAINT emp_pk PRIMARY KEY (empno),
CONSTRAINT emp_workdept_fk FOREIGN KEY department (deptno) REFERENCES
(workdept)
);

正確答案: B

問題3

Given the following scenario:
Table TABLE1 needs to hold specific numeric values up to 9999999.999 in column COL1. Once TABLE1 is populated, arithmetic operations will be performed on data stored in column COL1.
Which of the following would be the most appropriate DB2 data type to use for column COL1?

A. INTEGER

B. NUMERIC(7, 3)

C. REAL

D. DECIMAL(10, 3)

正確答案: D

問題4

Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?

A. SELECT * FROM tab1 WHILE ROW_NUM < 50

B. SELECT * FROM tab1 FIND FIRST 50 ROWS

C. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY

D. SELECT * FROM tab1 MAXROWS 50

正確答案: C

問題5

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

A. REVOKE CONNECT ON DATABASE FROM USER tom

B. REVOKE tom FROM CONNECT ON DATABASE BY USER bob

C. REVOKE ACCESS ON DATABASE FROM USER bob

D. REVOKE tom FROM ACCESS ON DATABASE BY USER bob

正確答案: A

問題6

Which kind of non-sourced UDF can be created so that it only returns a single value?

A. Column

B. Scalar

C. Table

D. Row

正確答案: B

問題7

In which situation is shredding XML data recommended?

A. When the data is naturally tabular

B. When the data is of low volume and requires a complex star-schema topology

C. When thenumber of nodes are volatile

D. When the data by nature has sparse attributes

正確答案: A

問題8

The opening of cursor CSR01 produces the following result set:
STUDENT LASTNM FIRSTNM CLASSNO 123 Brown John T100 213 Bailey James T100 312 Carter Arlene T210 465 Chas Devon T305 546 Davis Steven T405
If this Fetch statement is executed:
FETCH csr01 INTO :studnum, :firstname, :lastname, :class
Which of the following DELETE statements will cause this row to be deleted?

A. DELETE FROM tab01 FOR CURRENT csr01 WITH RS

B. DELETE * FROM tab01 WHERE CURRENT csr01 WITH CS

C. DELETE ALL FROM tab01 FOR CURRENT OF csr01

D. DELETE FROM tab01 WHERE CURRENT OF csr01 WITH RR

正確答案: D

問題9

Given the following statements:
CREATE TABLE tab1 (col1 INT);
CREATE TABLE tab2 (col1 INT);
CREATE TRIGGER trig1 AFTER UPDATE ON tab1
REFERENCING NEW AS new1
FOR EACH ROW MODE DB2SQL
INSERT INTO tab2 VALUES(new1.col1);
INSERT INTO tab1 VALUES(2),(3);
What is the result of the following query?
SELECT count(*) FROM tab2;

A. 1

B. 0

C. 3

D. 2

正確答案: B

問題10

Which of the following best describes a unit of work?

A. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as asavepoint is created.

B. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.

C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.

D. It is a recoverable sequence of operations whose point of consistency is established when a connection to a database has been established or when a mechanism known as asavepoint is created.

正確答案: C

問題11

Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

A. DB2Enterprise Server Edition

B. DB2 Universal DatabaseEnterprise Edition and DB2 Connect Enterprise Edition

C. DB2 Universal Developer's Edition

D. DB2 Personal Developer's Edition

正確答案: C

問題12

Given the following DDL and INSERT statements:
CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10;
CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION;
CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;
INSERT INTO v1 VALUES(5);
INSERT INTO v2 VALUES(5);
INSERT INTO v3 VALUES(20);
INSERT INTO v3 VALUES(100);
How many of these INSERT statements will be successful?

A. 1

B. 0

C. 3

D. 2

正確答案: D

問題13

Given the following tables:
YEAR_2006 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Wood, Ronnie 4 Watts, Charlie 5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME
1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Chapman, Tony 6 Stewart, Ian
If the following SQL statement is executed, how many rows will be returned?
SELECT name FROM year_2006 UNION SELECT name FROM year_1962

A. 6

B. 0

C. 10

D. 12

正確答案: C

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

最新更新

站內鏈接

聯系我們