IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 1:

  Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?

  A. Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO.
  B. Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO).
  C. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.
  D. Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.
  C. Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table.

• Question 2:

  Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?

  A. REVOKE ACCESS ON DATABASE FROM USER bob
  B. REVOKE CONNECT ON DATABASE FROM USER tom
  C. REVOKE tom FROM ACCESS ON DATABASE BY USER bob
  D. REVOKE tom FROM CONNECT ON DATABASE BY USER bob
  B. REVOKE CONNECT ON DATABASE FROM USER tom

• Question 3:

  Which of the following is the main feature of an OLTP application?

  A. Summarized queries
  B. Granular transactions
  C. Voluminous historical data
  D. Heterogeneous data sources
  B. Granular transactions

• Question 4:

  Application A holds a lock on a row in table TAB1. If lock timeout is set to 20, what will happen when Application B attempts to acquire a compatible lock on the same row?

  A. Application B will acquire the lock it needs
  B. Application A will be rolled back if it still holds its lock after 20 seconds have elapsed
  C. Application B will be rolled back if Application A still holds its lock after 20 seconds have elapsed
  D. Both applications will be rolled back if Application A still holds its lock after 20 seconds have elapsed
  A. Application B will acquire the lock it needs

• Question 5:

  Given the following statement:

  CREATE TABLE tab1

  (col1 SMALLINT NOT NULL PRIMARY KEY,

  col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE,

  col3 DECIMAL(5,2) CHECK (col3 >= 100.00),

  col4 DATE NOT NULL WITH DEFAULT)

  Which of the following definitions will cause the CREATE TABLE statement to fail?

  A. COL1
  B. COL2
  C. COL3
  D. COL4
  B. COL2

• Question 6:

  Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?

  A. Check constraint
  B. Unique constraint
  C. Default constraint
  D. Informational constraint
  B. Unique constraint

• Question 7:

  Given the following tables:

  YEAR_2006 EMPID NAME

  1 Jagger, Mick 2 Richards, Keith 3 Wood, Ronnie 4 Watts, Charlie 5 Jones, Darryl 6 Leavell, Chuck YEAR_1962 EMPID NAME

  1 Jagger, Mick 2 Richards, Keith 3 Jones, Brian 4 Wyman, Bill 5 Chapman, Tony 6 Stewart, Ian If the following SQL statement is executed, how many rows will be returned? SELECT name FROM year_2006 UNION SELECT name FROM year_1962

  B. 6
  C. 10
  D. 12
  C. 10

• Question 8:

  Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?

  A. DB2Enterprise Server Edition
  B. DB2 Personal Developer's Edition
  C. DB2 Universal Developer's Edition
  D. DB2 Universal DatabaseEnterprise Edition and DB2 Connect Enterprise Edition
  C. DB2 Universal Developer's Edition

• Question 9:

  Which of the following privileges permits a user to update the comment on a sequence?

  A. CONTROL
  B. UPDATE
  C. USAGE
  D. ALTER
  D. ALTER

• Question 10:

  Given the following table: TAB1

  COL1 COL2

  A 10 B 20 C 30 A 10 D 40 C 30

  Assuming the following results are desired:

  TAB1

  COL1 COL2

  A 10 B 20 C 30 D 40

  Which of the following statements will produce the desired results?

  A. SELECT UNIQUE * FROM tab1
  B. SELECT DISTINCT * FROM tab1
  C. SELECTUNIQUE(*) FROM tab1
  D. SELECTDISTINCT(*) FROM tab1
  B. SELECT DISTINCT * FROM tab1