IBM 000-543 問題集

質問 1：
A database contains a table and a view declared as shown below:
CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );
CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;
A system administrator successfully executes the following code:
GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;
GRANT INSERT ON TABLE s1.t1 TO user1;
GRANT CONTROL ON s1.v1 TO user1;
Which SQL statement does user USER1 have privileges to execute?
A. UPDATE s1.t1 SET c1 = 2 WHERE c1 IS NULL
B. CREATE PUBLIC ALIAS a1 FOR s1.v1
C. SELECT * FROM s1.t1 WHERE c2 < 100
D. CREATE VIEW user1.v2 AS SELECT * FROM s1.v1
正解：D

質問 2：
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE tab_a (col1 INT);
CREATE TABLE tab_b (col1 INT);
INSERT INTO tab_a VALUES (1), (2), (3), (4);
INSERT INTO tab_b VALUES (1), (2), (2), (3);
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit executed successfully.
If the statement shown below is executed:
DELETE FROM tab_a WHERE col1 IN (SELECT DISTINCT * FROM tab_b);
How many rows will be removed from table TAB_A?
A. 0
B. 2
C. 3
D. 1
正解：C

質問 3：
Given the table shown below:
COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
User USER1 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses
ON COMMIT PRESERVE ROWS;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
INSERT INTO session.tempcourses VALUES (3, 'ECE102', 'Databases');
SELECT max(ID) FROM db2user.courses;
User USER2 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
ON COMMIT PRESERVE ROWS;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
INSERT INTO session.tempcourses VALUES (4, 'ECE103', 'Algorithms');
SELECT max(ID) FROM session.tempcourses;
Which results do USER1 and USER2 obtain?
A. User USER1 obtains the value 3; User USER2 obtains the value 4
B. User USER1 obtains the value 2; User USER2 obtains the value 2
C. User USER1 obtains the value 2; User USER2 obtains the value 4
D. User USER1 obtains the value 2; User USER2 obtains the value 3
E. User USER1 obtains no value; User USER2 obtains no value
正解：C

質問 4：
A table and a sequence were created with the statements shown below: CREATE TABLE orders(oid INTEGER, info VARCHAR(200));
CREATE SEQUENCE order_num AS INTEGER
START WITH 1;
Autocommitis on and the statements shown are executed:
INSERT INTO orders VALUES (NEXT VALUE FOR order_num, 'Order A');
INSERT INTO orders VALUES (PREVIOUS VALUE FOR order_num, 'Order B');
SELECT * FROM orders;
What is the output?
A. OID INFO 1 Order A 1 Order B
B. OID INFO 1 Order A 2 Order B
C. OID INFO 2 Order A 2 Order B
D. OID INFO 0 Order A 1 Order B
正解：A

質問 5：
What are two different types of federated trusted connections? (Choose two.)
A. catalog federated trusted connections
B. proxy federated trusted connections
C. outbound federated trusted connections
D. end-to-end federated trusted connections
正解：C,D

質問 6：
Which SQL procedure will retrieve all the rows from table T1 and make those rows available to the invoker as a result set?
A. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR WITH RETURN FOR SELECT * FROM t1;
OPEN c1;
END
B. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
BEGIN
DECLARE c1 CURSOR FOR SELECT * FROM t1;
RETURN c1;
END
C. CREATE PROCEDURE proc1() DYNAMIC RESULTS SET 1 LANGUAGE SQL SELECT * FROM t1
D. CREATE PROCEDURE proc1()
DYNAMIC RESULTS SET 1
LANGUAGE SQL
RETURN (SELECT * FROM t1)
正解：A

質問 7：
Which two statements are true regarding performing batch updates in JDBC? (Choose two.)
A. TheaddBatch() method can be used to add a set of input parameter values to the batch.
B. ResultSet objects can be used to retrieve values generated by CallableStatement objects in a batch.
C. SELECT statements can be included in batch update operations.
D. TheexecuteBatch() method can be used to execute a batch of statements.
正解：A,D