IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 171:

  Which of the following is NOT a difference between a unique index and a primary key?

  A. A primary key is a special form of a unique constraint; both use a unique index.
  B. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.
  C. A table can have many unique indexes but only one primary key.
  D. Unique indexes can be defined over one or more columns that allow null values; primary keys cannot contain null values.
  B. Unique indexes can be defined over one or more columns; primary keys can only be defined on a single column.

• Question 172:

  Given the following statements:

  CREATE TABLE tab1 (col1 INT);

  CREATE TABLE tab2 (col1 INT);

  CREATE TRIGGER trig1 AFTER UPDATE ON tab1

  REFERENCING NEW AS new1

  FOR EACH ROW MODE DB2SQL

  INSERT INTO tab2 VALUES(new1.col1);

  INSERT INTO tab1 VALUES(2),(3);

  What is the result of the following query?

  SELECT count(*) FROM tab2;

  A. 3
  B. 2
  C. 1
  D

• Question 173:

  Which of the following is the major difference between relational data and XML data?

  A. Relational data is self-describing; XML data is not
  B. Relational data has inherent ordering; XML data does not
  C. Relational data must be tabular; XML data does not have to be tabular
  D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates
  C. Relational data must be tabular; XML data does not have to be tabular

• Question 174:

  A sequence was created with the DDL statement shown below:

  CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5

  User1 successfully executes the following statements in Connection1:

  VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar

  After User1 and User2 are finished, User3 executes the following statement in Connection3:

  SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1

  Which value will be returned by the query?

  A. 20
  B. 25
  C. 50
  D. 55
  D. 55

• Question 175:

  Given the following table:

  STOCK

  CATEGORY CHAR(1)

  PARTNO CHAR(12)

  DESCRIPTION VARCHAR(40)

  QUANTITY INTEGER

  PRICE DEC(7,2)

  If items are indicated to be out of stock by setting DESCRIPTION to NULL and QUANTITY and PRICE to zero, which of the following statements updates the STOCK table to indicate that all items except those with CATEGORY of 'S' are

  temporarily out of stock?

  A. UPDATE stock SET description = 'NULL', quantity = 0, price = 0 WHERE category 'S'
  B. UPDATE stock SET description = NULL, SET quantity = 0, SET price = 0 WHERE category 'S'
  C. UPDATE stock SET (description, quantity, price) = ('null', 0, 0) WHERE category 'S'
  D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category 'S'
  D. UPDATE stock SET (description, quantity, price) = (NULL, 0, 0) WHERE category 'S'

• Question 176:

  A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?

  A. Table
  B. Columns
  C. Table and Alias
  D. Columns and Alias
  A. Table

• Question 177:

  A table contains a list of all seats available at a football stadium. A seat consists of a section number, a seat number, and whether or not the seat has been assigned. A ticket agent working at the box office generates a list of all unassigned seats. When the agent refreshes the list, it should only change if another agent assigns one or more unassigned seats.

  Which of the following is the best isolation level to use for this application?

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

• Question 178:

  Given the following two tables:

  NAMES NAME NUMBER

  Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Brett Hull 16 Mario Lemieux 66 Mark Messier 11 POINTS NAME POINTS

  Wayne Gretzky 244 Jaromir Jagr 168 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94

  Which of the following statements will display the player name, number, and points for all players that have scored points?

  A. SELECT p.name,n.number, p.points FROM names n INNER JOIN points p ON n.name = name
  B. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name
  C. SELECT p.name,n.number, p.points FROM names n RIGHT OUTER JOIN points p ON n.name = p.name
  D. SELECT p.name,n.number, p.points FROM names n FULL OUTER JOIN points p ON n.name = p.name
  B. SELECT p.name,n.number, p.points FROM names n LEFT OUTER JOIN points p ON n.name = p.name

• Question 179:

  Given the following SQL statements:

  CREATE TABLE tab1 (col1 INTEGER) INSERT INTO tab1 VALUES (NULL) INSERT INTO tab1 VALUES (1) CREATE TABLE tab2 (col2 INTEGER) INSERT INTO tab2 VALUES (NULL) INSERT INTO tab2 VALUES (1) INSERT INTO tab2 VALUES (2)

  What will be the result when the following statement is executed?

  SELECT * FROM tab1 WHERE col1 IN (SELECT col2 FROM tab2)

  A. COL1 1 record(s) selected.
  B. COL1 NULL 2 record(s) selected.
  C. COL1 -2 record(s) selected.
  D. COL1 -1 record(s) selected.
  A. COL1 1 record(s) selected.

• Question 180:

  Given the following statements:

  CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;

  Which of the following INSERT statements will execute successfully?

  A. INSERT INTO view1 VALUES (50,abc)
  B. INSERT INTO view1VALUES(100, abc)
  C. INSERT INTO view1VALUES(50, 'abc')
  D. INSERT INTO view1VALUES(100, 'abc')
  C. INSERT INTO view1VALUES(50, 'abc')