最新のA2090-543問題集で試験を準備する

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 2 Order A 2 Order B
• C. OID INFO 0 Order A 1 Order B
• D. OID INFO 1 Order A 2 Order B

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 persistent connection must be explicitly closed after the database work has completed.
• B. Connections must be established under the same user authentication credentials.
• C. The commitment control mode must be set toautocommit mode.
• D. The commitment control mode must be set to manual commit mode.

Which set of SQL statements must be run prior to the EXECUTE statement shown below so that
the
INSERT statement can be executed successfully?
EXECUTE s1 USING :v1;

• A. SET :stmt = 'INSERT INTO tab1 VALUES(?v1)'; PREPARE s1 FROM :stmt;
• B. SET :stmt = 'INSERT INTO tab1 VALUES(:v1)'; PREPARE s1 FROM :stmt;
• C. SET :stmt = 'INSERT INTO tab1 VALUES(?)'; PREPARE s1 FROM :stmt
• D. SET :stmt = 'INSERT INTO tab1 VALUES(?)'; PREPARE s1 FROM :stmt DESCRIBE :v1;

For which two database objects can an ALIAS be created? (Choose two.)

• A. trigger
• B. sequence
• C. module
• D. schema

Click the Exhibit button.
CREATE TABLE gradereport(sid INTEGER, info XML);
INSERT INTO gradereport VALUES (1,
'<studentinfo sid="1">
<name>John Smith</name>
<honours>No</honours>
<grades>
<course><name>ECE100</name><grade>80</grade></course>
<course><name>CSC100</name><grade>70</grade></course>
<course><name>MAT100</name><grade>60</grade></course>
</grades>
<phone type="mobile">416-333-8725</phone>
</studentinfo>');
Given the statements shown in the exhibit, which two queries can be used to return the semester
average of the student? (Choose two.)

• A. XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
  let $avg := fn:avg($studinfo/grades/course)
  return $avg
• B. XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
  let $avg := fn:avg($studinfo/grades/course/grade)
  return $avg
• C. XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
  let $sum := fn:sum($studinfo/grades/course/grade),
  $count := fn:count($studinfo/grades/course/grade)
  return $sum div $count
• D. XQUERY for $studinfo in db2-fn:xmlcolumn('GRADEREPORT.INFO')/studentinfo
  let $average := fn:average($studinfo/grades/course/grade)
  return $average