IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 241:

  Given the following DDL and INSERT statements:

  CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100;

  INSERT INTO v1 VALUES(5);

  INSERT INTO v2 VALUES(5);

  INSERT INTO v3 VALUES(20);

  INSERT INTO v3 VALUES(100);

  How many of these INSERT statements will be successful?

  B. 1
  C. 2
  D. 3
  C. 2

• Question 242:

  Which of the following DB2 data types does NOT have a fixed length?

  A. INT
  B. CHAR
  C. XML
  D. DOUBLE
  C. XML

• Question 243:

  Given the following table and XML data stored in the CONTACTINFO column:

  CREATE TABLE clients(

  id INT PRIMARY KEY NOT NULL,

  name VARCHAR(50),

  status VARCHAR(10),

  contactinfo XML)

  25 EastCreek

  Toronto

  Ontario

  M8X-3T6

  4165551358

  9051112222

  9051112222

  by fax

  What is the result of the following XQuery expression?

  for $y in db2-fn:xmlcolumn('CLIENTS.CONTACTINFO')/Client//fax return $y

  A. 9051112222
  B. 9051112222
  C. No results because there is no child element of
  D. No results because theXQuery expression is not a valid FLWOR expression
  B. 9051112222

• Question 244:

  If the following SQL statements are executed in the order shown:

  CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);

  INSERT INTO table1 VALUES (123, 456);

  UPDATE table1 SET c1 = NULL;

  What will be the result of the following statement?

  SELECT * FROM table1;

  A. C1 C2 123 456 1 record(s) selected.
  B. C1 C2 NULL 456 1 record(s) selected.
  C. C1 C2 1 record(s) selected.
  D. C1 C2 0 456 1 record(s) selected.
  C. C1 C2 1 record(s) selected.

• Question 245:

  Given the following requirements:

  Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique.

  Which of the following CREATE statements will successfully create this table?

  A. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
  B. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))
  C. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
  D. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))
  D. CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

• Question 246:

  How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?

  CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END

  A. CALLgetratews11('USA','CANADA')
  B. CALLexpenses.getratews11('USA','CANADA')
  C. SELECTgetratews11('USA','CANADA') FROM expenses
  D. SELECT * FROMTABLE(getratews11('USA','CANADA')) AS convert_currency
  C. SELECTgetratews11('USA','CANADA') FROM expenses

• Question 247:

  If application A issues the following SQL statement, which of the following statements about concurrency is true? SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = 'A00' FOR READ ONLY WITH RS

  A. Rows accessed by application A can be seen by other applications.
  B. Rows accessed by application A cannot be seen by other applications.
  C. Application A can see uncommitted changes made by other applications.
  D. Results produced by re-execution of the statement by application A will not be affected by other applications.
  B. Rows accessed by application A cannot be seen by other applications.

• Question 248:

  Which of the following is the lowest cost DB2 product that can be legally installed on a Linux server that has 6 CPUs?

  A. DB2 Express Edition
  B. DB2 Personal Edition
  C. DB2 Workgroup Server Edition
  D. DB2Enterprise Server Edition
  D. DB2Enterprise Server Edition

• Question 249:

  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 250:

  Which of the following is NOT an attribute of Declared Global Temporary Tables (DGTTs)?

  A. Each application that defines a DGTT has its own instance of the DGTT
  B. Two different applications cannot create DGTTs that have the same name
  C. DGTTs can only be used by the application that creates them, and only for the life of the application
  D. Data stored in a DGTT can exist across transaction boundaries
  B. Two different applications cannot create DGTTs that have the same name