IBM C2090-543 問題集

質問 1：
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

質問 2：
A PHP Web application uses the ibm_db2 extension to establish a persistent connection to a remote database. What must be true of the connections to make full use of the db2_pconnect() API?
A. The commitment control mode must be set toautocommit mode.
B. The persistent connection must be explicitly closed after the database work has completed.
C. The commitment control mode must be set to manual commit mode.
D. Connections must be established under the same user authentication credentials.
正解：D

質問 3：
.Click the Exhibit button. The database shown below exists on a remote server: Database name: MYDB Host IP: 12.34.56.78 DB2 Port: 56789 User: remote password: password This database has been cataloged on the local server with an alias of MYREMDB. You are developing a CLI/ODBC application that must establish a connection to the remote database shown in the exhibit. What are two ways by which you can connect to the database? (Choose two.)
A. SQLDriverConnect(hdbc, (SQLHWND)NULL, "DSN=mydb;UID=remote;PWD=password",
SQL_NTS,
NULL, 0,
NULL, SQL_DRIVER_NOPROMPT)
B. SQLConnect(hdbc, "myremdb", SQL_NTS, "remote", SQL_NTS, "password", SQL_NTS)
C. SQLDriverConnect(hdbc, (SQLHWND)NULL, "DSN=myremdb;UID=remote;PWD=password",
SQL_NTS, NULL, 0, NULL, SQL_DRIVER_NOPROMPT)
D. SQLConnect(hdbc, "mydb", SQL_NTS, "remote", SQL_NTS, "password", SQL_NTS)
正解：B,C

質問 4：
Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?
A. SELECT * FROMdeptemployees('D11') AS D11dept
B. SELECT * FROM TABLE(deptemployees('D11'))
C. SELECT * FROM TABLE(deptemployees('D11')) AS D11dept
D. SELECT * FROMdeptemployees('D11')
正解：C

質問 5：
An application must perform maintenance on a table named EMPLOYEE. Which SQL statement can be used to restrict all activity on the EMPLOYEE table during maintenance by the application?
A. ALTER TABLE employee LOCK SIZE ROWS
B. LOCK TABLE employee IN EXCLUSIVE MODE
C. ALTER TABLE employee LOCK SIZE TABLE
D. LOCK TABLE employee IN SHARE MODE
正解：B

質問 6：
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

質問 7：
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

質問 8：
Given the table COURSES shown below: COURSES
ID CODE NAME
1 ECE100 Operating Systems
2 ECE101 Programming Languages
3 ECE102 Intro to Databases
User USER1 executes the following statements:
DECLARE GLOBAL TEMPORARY TABLE tempcourses
LIKE db2user.courses;
INSERT INTO session.tempcourses SELECT * FROM db2user.courses;
SELECT max(ID) FROM session.tempcourses;
Assuming autocommit is on, which result will user USER1 obtain?
A. no value
B. value 2
C. value 1
D. value 3
正解：A