IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 161:

  Which of the following DB2 data types can NOT be used to create an identity column?

  A. SMALLINT
  B. INTEGER
  C. NUMERIC
  D. DOUBLE
  D. DOUBLE

• Question 162:

  Which two of the following privileges is required in order to use a package?

  A. BINDADD
  B. BIND
  C. CONNECT
  D. EXECUTE
  E. USE
  C. CONNECT
  D. EXECUTE

• Question 163:

  A table named DEPARTMENT has the following columns:

  DEPT_ID DEPT_NAME MANAGER AVG_SALARY

  Which of the following is the best way to prevent most users from viewing AVG_SALARY data?

  A. Encrypt the table's data
  B. Create a view that does not contain the AVG_SALARY column
  C. Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
  D. Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users
  B. Create a view that does not contain the AVG_SALARY column

• Question 164:

  Application A wants to read a subset of rows from table TAB1 multiple times.

  Which of the following isolation levels should Application A use to prevent other users from making modifications and additions to table TAB1 that will affect the subset of rows read?

  A. Repeatable Read
  B. Read Stability
  C. Cursor Stability
  D. Uncommitted Read
  A. Repeatable Read

• Question 165:

  In which of the following scenarios would a stored procedure be beneficial?

  A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa
  B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables
  C. An application running on a remote client needs to track every modification made to a table that contains sensitive data
  D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number
  B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

• Question 166:

  Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?

  A. SELECT * FROM t1 UNION SELECT * FROM t2
  B. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2
  C. SELECT * FROM t1 INTERSECT SELECT * FROM t2
  D. SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
  B. SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2

• Question 167:

  A number of applications issue the following SQL statement:

  SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptno A database administrator wishes to store this query within the database.

  Which of the following database objects can be used to accomplish this?

  A. Alias
  B. View
  C. Schema
  D. Trigger
  B. View

• Question 168:

  If the following SQL statements are executed:

  CREATE TABLE make (makeid SMALLINT NOT NULL PRIMARY KEY, make VARCHAR(25));

  CREATE TABLE model (modelid SMALLINT,

  model VARCHAR(25),

  makeid SMALLINT,

  CONSTRAINT const1 FOREIGN KEY (makeid)

  REFERENCES make(makeid) ON DELETE RESTRICT);

  And each table created is populated as follows: MAKE MAKEID MAKE 1 Ford

  2 Chevrolet 3 Toyota MODEL

  MODELID MODEL MAKEID 1 Mustang 1 2 Escort 1 3 Malibu 2 4 Camry 3

  If the following SQL statement is executed:

  DELETE FROM make WHERE makeid = 1

  What is the total number of rows that will be deleted?

  B. 1
  C. 2
  D. 3
  A

• Question 169:

  Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?

  A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
  B. CREATE DISTINCT TYPE currency AS SMALLINT
  C. CREATE DISTINCT TYPE currency AS BIGINT
  D. CREATE DISTINCT TYPE currency AS DOUBLE
  A. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)

• Question 170:

  Given the following table:

  CURRENT_EMPLOYEES

  EMPID INTEGER NOT NULL

  NAME CHAR(20)

  SALARY DECIMAL(10,2)

  PAST_EMPLOYEES

  EMPID INTEGER NOT NULL

  NAME CHAR(20)

  SALARY DECIMAL(10,2)

  Assuming both tables contain data, which of the following statements will NOT successfully add data to table CURRENT_EMPLOYEES?

  A. INSERT INTOcurrent_employees (empid) VALUES (10)
  B. INSERT INTOcurrent_employees VALUES (10, 'JAGGER', 85000.00)
  C. INSERT INTOcurrent_employees SELECT empid, name, salary FROM past_employees WHERE empid =
  D. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)
  D. INSERT INTOcurrent_employees (name, salary) VALUES (SELECT name, salary FROM past_employees WHERE empid = 20)