IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 191:

  Given the requirements to store customer names, billing addresses, and telephone numbers, which of the following would be the best way to define the telephone number column for a table if all customers were located in the same country?

  A. PHONE CHAR(15)
  B. PHONE VARCHAR(15)
  C. PHONE LONG VARCHAR
  D. PHONE CLOB(1K)
  A. PHONE CHAR(15)

• Question 192:

  Given the following statements:

  CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));

  CREATE TABLE t1audit (user VARCHAR(20), date DATE, action VARCHAR(20));

  CREATE TRIGGER trig1 AFTER INSERT ON t1

  FOR EACH ROW

  MODE DB2SQL

  INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE, 'Insert');

  If user USER1 executes the following statements:

  INSERT INTO t1 VALUES (1, 'abc');

  INSERT INTO t1 (c1) VALUES (2);

  UPDATE t1 SET c2 = 'ghi' WHERE c1 = 1;

  How many new records will be written to the database?

  B. 2
  C. 3
  D. 4
  D. 4

• Question 193:

  Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?

  A. DB2 for z/OS
  B. DB2 Run-Time Client for z/OS
  C. DB2 Connect Enterprise Edition for z/OS
  D. z/OS Application Connectivity to DB2 for z/OS and OS/390
  A. DB2 for z/OS

• Question 194:

  Given the following two tables: TAB1 COL_1 COL_2 A 10

  B 12 C 14 TAB2

  COL_A COL_B A 21 C 23 D 25

  Assuming the following results are desired: COL_1 COL_2 COL_A COL_B A 10 A 21 B 12 -

  C 14 C 23 - - D 25 Which of the following joins will produce the desired results?

  A. SELECT * FROM tab1 INNER JOIN tab2 ON col_1 =col_a
  B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON col_1 =col_a
  C. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON col_1 =col_a
  D. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 =col_a
  D. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON col_1 =col_a

• Question 195:

  Given the following table:

  TAB1

  COL1 COL2

  A 10

  B 20

  C 30

  D 40

  E 50

  And the following SQL statements:

  DECLARE c1 CURSOR WITH HOLD FOR

  SELECT * FROM tab1 ORDER BY col_1;

  OPEN c1;

  FETCH c1;

  FETCH c1;

  FETCH c1;

  COMMIT;

  FETCH c1;

  CLOSE c1;

  FETCH c1;

  Which of the following is the last value obtained for COL_2?

  A. 20
  B. 30
  C. 40
  D. 50
  C. 40

• Question 196:

  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')

• Question 197:

  Which of the following is NOT a characteristic of a unique index?

  A. Each column in a base table can only participate in one uniqueindex, regardless of how the columns are grouped (the same column cannot be used in multiple unique indexes)
  B. In order for an index to be used to support a unique constraint, it must have been defined with the UNIQUE attribute
  C. A unique index cannot be created for a populated table if the key column specified contains more than one NULL value
  D. A unique index can only be created for a non-nullable column
  D. A unique index can only be created for a non-nullable column

• Question 198:

  In which situation is shredding XML data recommended?

  A. When the data is naturally tabular
  B. When thenumber of nodes are volatile
  C. When the data by nature has sparse attributes
  D. When the data is of low volume and requires a complex star-schema topology
  A. When the data is naturally tabular

• Question 199:

  If the following statement is executed:

  CREATE TABLE employee

  (empid INT NOT NULL GENERATED BY DEFAULT

  AS IDENTITY (START WITH 1, INCREMENT BY 5),

  name VARCHAR(20),

  dept INT CHECK (dept BETWEEN 1 AND 20),

  hiredate DATE WITH DEFAULT CURRENT DATE,

  salary DECIMAL(7,2),

  PRIMARY KEY(empid),

  CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR

  Salary > 60500));

  Which of the following INSERT statements will fail?

  A. INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
  B. INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
  C. INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
  D. INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
  D. INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)

• Question 200:

  Given the following tables: TABLEA EMPIDNAME 1 USER1

  2 USER2 TABLEB EMPID WEEKNO PAYAMT 1 1 1000.00

  1 2 1000.00

  2 1 2000.00

  and the fact that TABLEB was defined as follows:

  CREATE TABLE tableb (empid SMALLINT,

  weekno SMALLINT,

  payamt DECIMAL(6,2),

  CONSTRAINT const1 FOREIGN KEY (empid)

  REFERENCES tablea(empid)

  ON DELETE NO ACTION)

  If the following command is issued:

  DELETE FROM tablea WHERE empid=2

  How many rows will be deleted from TABLEA and TABLEB?

  A. TABLEA - 0, TABLEB - 0
  B. TABLEA - 0, TABLEB - 1
  C. TABLEA - 1, TABLEB - 0
  D. TABLEA - 1, TABLEB - 1
  A. TABLEA - 0, TABLEB - 0