IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 221:

  Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?

  A. Define the column MAINID as NOT UPDATABLE.
  B. Define the column MAINID as a PRIMARY KEY.
  C. Define the column MAINID as a FOREIGN KEY.
  D. Define an UPDATE trigger on table TABLEX.
  D. Define an UPDATE trigger on table TABLEX.

• Question 222:

  If the following SQL statements are executed:

  CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY, name VARCHAR(25));

  CREATE TABLE tab2 (empid SMALLINT,

  weekno SMALLINT,

  payamt DECIMAL(6,2),

  CONSTRAINT const1 FOREIGN KEY (empid)

  REFERENCES taba(id) ON UPDATE NO ACTION);

  Which of the following statements is true?

  A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
  B. The updating of values in the ID column of table TAB1 is not allowed
  C. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
  D. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well
  A. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

• Question 223:

  A sequence was created with the DDL statement shown below:

  CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10

  User USER1 successfully executes the following statements in the order shown:

  VALUES NEXT VALUE FOR my_seq INTO :hvar; VALUES NEXT VALUE FOR my_seq INTO :hvar;

  User USER2 successfully executes the following statements in the order shown:

  ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5; VALUES NEXT VALUE FOR my_seq INTO :hvar;

  After users USER1 and USER2 are finished, user USER3 executes the following query:

  SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1

  What value will be returned by the query?

  A. 5
  B. 10
  C. 20
  D. 30
  D. 30

• Question 224:

  Which of the following CREATE TABLE statements will NOT be successful?

  A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)
  B. CREATE TABLE t1 (c1 XML NOT NULL, c2CHAR(20))
  C. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)
  D. CREATE TABLE t1 (c1 XML, c2 XML)
  A. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

• Question 225:

  Which of the following is NOT true about XML columns?

  A. Data can be retrieved by SQL.
  B. Data can be retrieved byXQuery.
  C. XML columns must be altered to accommodate additional parent and child relationships.
  D. Access to any portion of an XML document can be direct, without reading the whole document.
  C. XML columns must be altered to accommodate additional parent and child relationships.

• Question 226:

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

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

• Question 227:

  In which of the following situations should correlation names be used?

  A. A table referenced in the FROM clause has no indexed column.
  B. The table referenced in the FROM clause has more than 200 columns.
  C. Two or more tables in the FROM clause have identical column names.
  D. The FROM clause contains two or more tables in the SELECT statement.
  C. Two or more tables in the FROM clause have identical column names.

• Question 228:

  Given the following DDL for the PARTS table:

  CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));

  All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried.

  Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?

  A. CREATE UNIQUE INDEXidx_partno ON parts(part_no)
  B. CREATE UNIQUE INDEXidx_partno ON parts(part_name ASC)
  C. CREATE UNIQUE INDEXidx_partno ON parts(part_name, part_no ASC)
  D. CREATE UNIQUE INDEXidx_partno ON parts(part_no, part_name ASC)
  A. CREATE UNIQUE INDEXidx_partno ON parts(part_no)

• Question 229:

  A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP address for this system is 192. 168.10.1 and the TCP/IP host name is myhost. Which of the following commands is required to update the local node directory so that a DB2 client can access this DRDA database?

  A. CATALOG TCPIP NODEmyhost REMOTE db2srv SERVER 446
  B. CATALOG TCPIP NODE mydb2srv REMOTEmyhost SERVER 446
  C. CATALOG TCPIP NODEmyhost REMOTE db2srv SERVER 192. 168.10.1
  D. CATALOG TCPIP NODE mydb2srv REMOTEmyhost SERVER 192. 168.10.1
  B. CATALOG TCPIP NODE mydb2srv REMOTEmyhost SERVER 446

• Question 230:

  If the following SQL statement is executed:

  CREATE TABLE sales

  (invoice_no NOT NULL PRIMARY KEY,

  sales_date DATE,

  sales_amt NUMERIC(7,2))

  IN tbsp0, tbsp1, tbsp2, tbsp3

  PARTITION BY RANGE (sales_date NULLS FIRST)

  (STARTING '1/1/2007' ENDING '12/31/2007'

  EVERY 3 MONTHS)

  Which of the following statements is true?

  A. Administrative tasks such as backing up, restoring, and reorganizing data stored in the SALES table must be done at the table level; not at the partition level
  B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement
  C. If an index is created for the SALES table, its data must be stored in table space TBSP0
  D. When resolving queries against the SALES table, each partition used is scanned asynchronously and the results of each partition scan are merged to produce the result data set returned
  B. Data can be quickly rolled in and out of the SALES table by using the ATTACH PARTITION and DETACH PARTITION clauses of the ALTER TABLE statement