Free IBM A2090-543 Exam Dumps Questions & Answers

A JDBC application uses the "com.ibm.db2.jcc.DB2Driver" driver.
Which two JDBC code snippets illustrate establishing valid connections to a DB2 database named
MYDB? (Choose two.)

• A.Stringurl = "jdbc:db2://myhost/mydb"
  Connection conn = DriverManager.getConnection (url);
• B.Stringurl = "jdbc:db2://myhost:5021/mydb:user=myuser;password=mypwd;";
  Connection conn = DriverManager.getConnection (url);
• C.// Assume aDataSource object named mydb was created by the system administrator
  DB2SimpleDataSource dbds=new DB2SimpleDataSource();
  DataSourceds = (DataSource)dbds.lookup("jdbc/mydb");
  conn= ds.getConnection();
• D.// Assume aDataSource object named mydb was created by the system administrator
  Context ctx=new InitialContext();
  DataSourceds = (DataSource)ctx.lookup("jdbc/mydb");
  conn= ds.getConnection();

The table shown below exists within a database:
CREATE TABLE s1.t1 ( c1 INTEGER NOT NULL PRIMARY KEY, c2 CLOB( 2G ) )
A CLI/ODBC application uses the SQLGetSubString() API to retrieve the first 1024 and last 1024
bytes of data from column C2.
Which mechanism is used to minimize the amount of data sent to the client for this operation?

• A.locator
• B.module
• C.temp file
• D.log file

Click the Exhibit button. CREATE TABLE s1.mytab (col1 INTEGER GENERATED ALWAYS AS IDENTITY, col2 INTEGER, col3 INTEGER, CHECK (col1+col3 < 500) CREATE VARIABLE s1.var1 INTEGER DEFAULT (99) CREATE FUNCTION s1.add100 (p1 INT, p2 INT) RETURNS INTEGER LANGUAGE SQL DETERMINISTIC NOT FENCED BEGIN SET p1= p2+100; RETURN p1;END Given the table, variable, and function definitions shown in the exhibit, which two statements contain a valid invocation of the add100 function? (Choose two.)

• A.SELECT col1,outcol=add100(col2,col3) FROM mytab
• B.SET var1 = ABS(add100(1,99))
• C.SELECT col1, add100(col2,col3) ASoutcol FROM mytab
• D.SELECT outcol.* FROM TABLE(add100(col2,col3)) ASoutcol

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 * FROM TABLE(deptemployees('D11')) AS D11dept
• B.SELECT * FROMdeptemployees('D11')
• C.SELECT * FROMdeptemployees('D11') AS D11dept
• D.SELECT * FROM TABLE(deptemployees('D11'))

Which two SQL statements demonstrate the correct usage of a parameter marker? (Choose two.)

• A.DELETE FROM employee WHEREempno = ?
• B.SET CURRENT SQLID = ?
• C.SELECT ? FROM employee
• D.VALUES(?) INTO :hvar1