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

問題1

Which two techniques guarantee that XML document validation will be performed? (Choose two.)

A. Use triggers for INSERT and UPDATE operations with the XMLSERIALIZE() function.

B. Use triggers for INSERT and UPDATE operations with the XMLVALIDATE() function.

C. Implicit use of the XMLCHECK() function in the SQL statements.

D. Implicit use of the XMLVALIDATE() function in SQL statements.

正確答案: B,D

問題2

Which type of join condition specifies that the result table will contain a row for each row from the Table to the left, concatenated with each row from the table to the right?

A. FULL OUTER JOIN

B. INNER JOIN

C. EXCEPTION JOIN

D. CROSS JOIN

正確答案: D

問題3

Which steps are necessary to issue a batch update using a single SQL statement? (Note: The statement has several sets of input parameter markers and is issued from a database application using the IBM Data Server Driver for JDBC.)

A. Create aPreparedStatement object; add the parameter markers to the batch using the addBatch() method; assign values to each set of parameter marker values; execute the statement using the executeQuery() method.

B. Create a Statement object; assign values to each set of parameter marker values; add the parameter markers to the batch using theaddBatch() method; execute the statement using the executeBatch() method.

C. Create aPreparedStatement object; assign values to each set of parameter marker values; add the parameter markers to the batch using the addBatch() method; execute the statement using the executeBatch() method.

D. Create a Statement object; add the parameter markers to the batch using theaddBatch() method; assign values to each set of parameter marker values; execute the statement using the executeQuery() method.

正確答案: C

問題4

When creating a trusted connection in CLI/ODBC, it is necessary to set a connection attribute. What is the connection attribute?

A. SQL_ATTR_ENABLE_TRUSTED_CONTEXT

B. SQL_ATTR_USE_TRUSTED_CONTEXT

C. SQL_ATTR_TRUSTED_CONTEXT_PASSWORD

D. SQL_ATTR_TRUSTED_CONTEXT_USERID

正確答案: B

問題5

The statement below was used to create a cursor named CSR1:
DECLARE csr1 CURSOR FOR SELECT * FROM employee FOR UPDATE OF job;
When the cursor is opened, the result set contains six rows. After fetching all of the rows in the
result set associated with cursor CSR1, application TEST1 needs to fetch the third row of the
result set again.
Which steps will allow application TEST1 to fetch the third row again?

A. REOPEN csr1;
FETCH;
FETCH;
FETCH;

B. CLOSE csr1; OPEN csr1; FETCH; FETCH; FETCH

C. FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;
FETCH PRIOR;

D. FETCH ABSOLUTE 3

正確答案: B

問題6

An existing table has the definition shown below: CREATE TABLE hr.employees (empid INTEGER NOT NULL PRIMARY KEY,deptno INTEGER,authid VARCHAR(255), salary DECIMAL (10,2), commission DECIMAL (5,3) DEFAULT 0,benefits XML ) Only members of the HR_ADMIN group have privilege to SELECT, INSERT, UPDATE, or DELETE from the HR.EMPLOYEES table. A Web-based application is under development that connects to the database with a user's AUTHID and enables a user to see their record. No other records are visible. Which type of database object can be created by a member of the HR_ADMIN that provides the necessary information without changing the privileges on the HR.EMPLOYEES table?

A. alias

B. view

C. index

D. trigger

正確答案: B

問題7

What are two valid values for the PARAMETER STYLE clause in the CREATE PROCEDURE statement? (Choose two.)

A. C

B. JAVA

C. GENERAL WITH NULLS

D. SQL WITH NULLS

正確答案: B,C

問題8

Which statement should be used to obtain the result set shown below?
<Root>
<First>Hello</First>
<Second>World !</Second>
<?Test Pass test?>
</Root>

A. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLATTRIBUTES ( 'Pass test' as "test")
)
)

B. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLPI (NAME "Test", 'Pass test')
)
)

C. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLFOREST(
'Hello' as "First",
'World !' as "Second"
),
XMLCOMMENT ('Test Pass test')
)
)

D. VALUES XMLDOCUMENT(
XMLELEMENT (NAME "Root",
XMLELEMENT(NAME "First", 'Hello'),
XMLELEMENT(NAME "Second", 'World !'),
XMLTEXT ('Test Pass test')
)
)

正確答案: B

問題9

In a query, which clause can reference a CLOB data type?

A. a GROUP BY clause

B. an ORDER BY clause

C. a DISTINCT clause

D. a WHERE clause

正確答案: D

問題10

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 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 FULL OUTER JOIN project ON employee.deptno = project.deptno

正確答案: C

最新的IBM DB2 9.7 Application Development - C2090-543免費考試真題

聯系我們

站內鏈接

最新更新