IBM C2090-543 問題集

質問 1：
Which two commands can be used to make use of the latest statistics? (Choose two.)
A. REBIND
B. RUNSTATS
C. FLUSH PACKAGE CACHE
D. INSPECT
正解：A,C

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

質問 3：
Click the Exhibit button.
<personinfo>
<name>John Smith</name>
<address type="private">
<city>New York</city>
<country>US</country>
<phone>850-734-6672</phone>
</address>
<phone type="mobile">796-858-1272 </phone>
<phone type="security">646-252-1053</phone>
</personinfo>
The table PERSON is declared as shown below:
CREATE TABLE person (id BIGINT, info XML)
The document shown in the exhibit is successfully inserted into the table.
How many rows will be returned for the following statement?
SELECT t.* FROM
xmlapp.PERSON,
XMLTABLE (
'$INFO/personinfo'
COLUMNS
name VARCHAR(30) PATH './name',
phone VARCHAR(30) PATH './phone'
) AS t
A. 0
B. 2
C. 4
D. 6
正解：A

質問 4：
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE project (projno CHAR(6), deptno CHAR(3), projname VARCHAR(20));
CREATE TABLE employee (empno CHAR(6), lastname VARCHAR(25), deptno CHAR(3));
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
Which query will produce a list of all projects and all employees assigned to projects and also
include employees that have not been assigned a project?
A. SELECTempno, lastname, workdept, projname FROM employee RIGHT OUTER JOIN project ON employee.deptno = project.deptno
B. SELECTempno,lastname, employee.deptno, projname FROM employee FULL OUTER JOIN project ON employee.deptno = project.deptno
C. SELECTempno, lastname, employee.deptno, projname FROM employee LEFT OUTER JOIN project ON employee.deptno = project.deptno
D. SELECTempno, lastname, employee.deptno, projname FROM employee JOIN project ON employee.deptno = project.deptno
正解：C

質問 5：
.While developing a CLI application, you use the code shown below:
SQLCHAR *stmt = (SQLCHAR *)"DELETE FROM org WHERE deptnumb = ? ";
cliRC= SQLSetStmtAttr(hstmt, SQL_ATTR_DEFERRED_PREPARE,
SQL_DEFERRED_PREPARE_ON )
cliRC= SQLPrepare(hstmt, stmt, SQL_NTS);
Now, the ORG table does not exist in the database.
What will be the value of "cliRC" after executing the SQLPrepare command?
A. SQL_SUCCESS
B. SQL_ERROR
C. SQL_SUCCESS_WITH_INFO
D. SQL_INVALID_HANDLE
正解：A

質問 6：
Which two C# .NET code snippets illustrate the valid execution of a SQL statement through the IBM Data Server Provider for .NET? (Choose two.)
A. DB2Commandcmd = conn.CreateCommand();
cmd.CommandText= "SELECT fname, lname FROM employee WHERE empno=55";
DB2DataReader reader = cmd.ExecuteReader();
B. DB2Commandcmd = DB2Context.GetCommand();
DB2Transaction trans = conn.BeginTransaction();
cmd.Transaction= trans;
cmd.CommandText= "INSERT INTO employee (fname,lname) VALUES('Susan','Smith');
cmd.ExecuteNonQuery();
C. SqlCommand cmd = new SQLCommand("SELECT fname, lname FROM employee WHERE
empno=55",conn);
SqlDataReaderreader = cmd.ExecuteReader();
D. SqlCommand cmd = new SQLCommand("INSERT INTO employee (fname,lname)
VALUES('Susan','Smith')",conn);
cmd.ExecuteNonQuery();
正解：A,B

質問 7：
What are two valid values for the PARAMETER STYLE clause in the CREATE PROCEDURE statement? (Choose two.)
A. SQL WITH NULLS
B. C
C. JAVA
D. GENERAL WITH NULLS
正解：C,D

質問 8：
Click the Exhibit button.
CONNECT TO test;
CREATE TABLE parent (empno CHAR(6), firstname VARCAHR(25), lastname VARCHAR(25));
CREATE TABLE child (childno CHAR(6), firstname VARCHAR(25), lastname VARCHAR(25),
empno
CHAR(6));
CREATE VIEW employee AS SELECT * FROM parent;
CREATE VIEW employee_children AS SELECT * FROM child;
COMMIT;
CONNECT RESET;
A DB2 Command Line Processor script file containing the commands and statements shown in
the exhibit was executed successfully.
Which technique can be used to produce a list of all employees and their children, including
employees who have no children?
A. FULL OUTER JOIN
B. MERGE JOIN
C. LEFT or RIGHT OUTER JOIN
D. INNER JOIN
正解：C