IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 71:

  Which two of the following are optional and do not have to be specified when creating a table?

  A. Table name
  B. Column name
  C. Default constraint
  D. Column data type
  E. NOT NULL constraint
  C. Default constraint
  E. NOT NULL constraint

• Question 72:

  When does a view get populated?

  A. When it is created
  B. When it is referenced in an INSERT statement
  C. The first time any executable SQL statement references it
  D. Any time an executable SQL statement references it
  D. Any time an executable SQL statement references it

• Question 73:

  An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?

  A. The application must release the row-level Share lock it holds and acquire an Update lock on the row
  B. The application must release the row-level Share lock it holds and acquire an Update lock on the table
  C. The row-level Share lock will automatically be converted to a row-level Update lock
  D. The row-level Share lock will automatically be escalated to a table-level Update lock
  C. The row-level Share lock will automatically be converted to a row-level Update lock

• Question 74:

  Given the following table definitions:

  DEPARTMENT

  DEPTNO CHAR(3) DEPTNAME CHAR(30) MGRNO INTEGER ADMRDEPT CHAR(3)

  EMPLOYEE

  EMPNO INTEGER FIRSTNAME CHAR(30) MIDINIT CHAR LASTNAME CHAR(30) WORKDEPT CHAR(3)

  Which of the following statements will list every employee number and last name, along with the employee number and last name of their manager, including employees that have not been assigned to a manager?

  A. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
  B. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
  C. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
  D. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e RIGHT INNER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno
  B. SELECTe.empno, e.lastname, m.empno, m.lastname FROM employee e LEFT OUTER JOIN department INNER JOIN employee m ON mgrno=m.empno ON e.workdept=deptno

• Question 75:

  Which of the following modes, when used with the LOCK TABLE statement, will cause the DB2 Database Manager to acquire a table-level lock that prevents other concurrent transactions from accessing data stored in the table while the owning transaction is active?

  A. SHARE MODE
  B. ISOLATED MODE
  C. EXCLUSIVE MODE
  D. RESTRICT MODE
  C. EXCLUSIVE MODE

• Question 76:

  Which of the following strings can NOT be inserted into an XML column using XMLPARSE()?

  A. ""
  B. "John Doe"
  C. ""
  D. ""
  C. ""

• Question 77:

  Which of the following are types of routine objects?

  A. Package and function
  B. Function anduserexit
  C. Procedure and package
  D. Function and procedure
  D. Function and procedure

• Question 78:

  Which two of the following authorities allow a user to create a new database?

  A. SYSADMN
  B. SYSCTRL
  C. SYSMAINT
  D. DBADM
  E. CREATEDB
  A. SYSADMN
  B. SYSCTRL

• Question 79:

  Application A is designed to execute the following SQL statements within a single Unit of Work (UOW).

  UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname =

  'NEW dept' WHERE deptno='A00' Application B is designed to execute the following SQL statements within a

  single Unit of Work (UOW).

  UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary =

  salary * 0.5 WHERE empno='000010'

  Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?

  A. The database managerwill rollback the transaction in both applications.
  B. The database managerwill rollback the transaction in one of the two applications.
  C. Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
  D. Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.
  B. The database managerwill rollback the transaction in one of the two applications.

• Question 80:

  Which of the following CREATE TABLE statements will NOT be successful?

  A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
  B. CREATE TABLE t1 (c1 XML NOT NULL, c2CHAR(20))
  C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
  D. CREATE TABLE t1 (c1 XML, c2 XML)
  A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)