An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary: UPDATE emp SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1; Which statement should be used to define cursor C1?

• A. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11??
• B. DECLARE c1 CURSOR FOR SELECT bonus FROMemp WHERE workdept = 11?FOR UPDATE OF bonus
• C. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE
• D. DECLARE c1 CURSOR FOR SELECT * FROMemp WHERE workdept = ?11? FOR UPDATE OF *

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. view
• B. trigger
• C. index
• D. alias

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. SqlCommand cmd = new SQLCommand("SELECT fname, lname FROM employee WHERE
  empno=55",conn);
  SqlDataReaderreader = cmd.ExecuteReader();
• C. DB2Commandcmd = DB2Context.GetCommand();
  DB2Transaction trans = conn.BeginTransaction();
  cmd.Transaction= trans;
  cmd.CommandText= "INSERT INTO employee (fname,lname) VALUES('Susan','Smith');
  cmd.ExecuteNonQuery();
• D. SqlCommand cmd = new SQLCommand("INSERT INTO employee (fname,lname)
  VALUES('Susan','Smith')",conn);
  cmd.ExecuteNonQuery();

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

A library keeps digital copies of books in the table shown below:
CREATE TABLE library.collection (
bookidINTEGER NOT NULL PRIMARY KEY,
ebook_contentBLOB(2G) )
A CLI/ODBC application is written that retrieves the EBOOK_CONTENT for a given BOOKID in
32K pieces.
Which two APIs can be used to perform the retrieval? (Choose two.)

• A. SQLGetData()
• B. SQLFetchNext()
• C. SQLGetLength()
• D. SQLGetSubString()