IBM C2090-320 Online Practice Questions and Exam Preparation

IBM C2090-320 Online Questions & Answers

• Question 1:

  Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

  A. TRUNCATE employee;
  B. DELETE FROM employee;
  C. DELETE FROM employee WHERE...;
  D. TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;
  B. DELETE FROM employee;

• Question 2:

  You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

  A. REAL
  B. BIGINT
  C. DECIMAL
  D. INTEGER
  C. DECIMAL

• Question 3:

  Given the following table:

  

  Which of the following INSERT statements will be successful?

  A. INSERT INTO EMPSAMP (empno, name, salary, deptno, level, hiretype, hiredate) VALUES(2,'Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');
  B. INSERT INTO EMPSAMP (`Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');
  C. INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');
  D. INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES(`Mary Smith', 35000.00, 11, `Associate');
  A. INSERT INTO EMPSAMP (empno, name, salary, deptno, level, hiretype, hiredate) VALUES(2,'Mary Smith', 35000.00, 11, `Associate', `existing','05-06-2016');

• Question 4:

  When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following?

  GRANT DBADM ON SYSTEM TO smith;

  A. Tables
  B. Traces
  C. Sequences
  D. Security Objects
  B. Traces

• Question 5:

  Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

  A. Data Facility Storage Management
  B. z/OS Parallel Sysplex Configuration
  C. Workload Manager
  D. z Systems Processor Resource
  B. z/OS Parallel Sysplex Configuration

• Question 6:

  Which of the following can activate a trigger?

  A. A row is inserted
  B. A table or view is created
  C. A check constraint is defined
  D. A referential constraint is violated
  D. A referential constraint is violated

• Question 7:

  How can a stored procedure be invoked?

  A. Via an SQL SELECT statement
  B. Via a CALL statement using SPUFI
  C. Directly via a RUN PROGRAM command
  D. Via a CALL statement from within an application program
  D. Via a CALL statement from within an application program

• Question 8:

  Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

  A. SQLCA
  B. SQLDA
  C. SQLCODE
  D. SQLSTATE
  B. SQLDA

• Question 9:

  Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

  A. BIND
  B. REORG
  C. TRIGGER
  D. EXECUTE
  D. EXECUTE

• Question 10:

  You have created a new index. What is the command to potentially change the access path for a static package?

  A. FREE
  B. RESET
  C. REBIND
  D. REFRESH
  C. REBIND