IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 91:

  Which of the following best describes the age of the data in an OLTP system?

  A. Current
  B. Projected
  C. Historical
  D. Current and projected
  A. Current

• Question 92:

  Given the following table definition:

  SALES

  SALES_DATE DATE

  SALES_PERSON CHAR(20)

  REGION CHAR(20)

  SALES INTEGER

  Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?

  A. DELETE * FROM sales WHEREYEAR(sales_date) = 1995
  B. DELETE FROM sales WHEREYEAR(sales_date) = 1995
  C. DROP * FROM sales WHEREYEAR(sales_date) = 1995
  D. DROP FROM sales WHEREYEAR(sales_date) = 1995
  B. DELETE FROM sales WHEREYEAR(sales_date) = 1995

• Question 93:

  Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?

  A. BLOB
  B. CLOB
  C. DBCLOB
  D. GRAPHIC
  B. CLOB

• Question 94:

  Given the following query:

  SELECT quantity,

  CASE WHEN itemcode = '099' THEN 'SILVER'

  WHEN itemcode = '788' THEN 'GOLD'

  WHEN itemcode = '899' THEN 'PLATINUM'

  ELSE 'ERROR'

  END

  FROM supplier

  What will be the result of the query if the following data is evaluated by the CASE expression?

  SUPPLIER

  QUANTITY ITEMCODE 3 099 4 099 1 788 1 899 5 009 3 788 1 899

  A. 3,SILVER 4,GOLD 1,SILVER 1,GOLD 5,PLATINUM 3,SILVER 1,GOLD
  B. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM
  C. 3,SILVER 4,SILVER 1,PLATINUM 1,ERROR 5,SILVER 3,GOLD 1,PLATINUM
  D. 3,SILVER 1,GOLD 1,GOLD 5,SILVER 3,ERROR 1,PLATINUM
  B. 3,SILVER 4,SILVER 1,GOLD 1,PLATINUM 5,ERROR 3,GOLD 1,PLATINUM

• Question 95:

  Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?

  A. Design Advisor
  B. Visual Explain
  C. Performance Advisor
  D. Configuration Assistant
  A. Design Advisor

• Question 96:

  Which object may be used during query optimization to improve the performance for a subset of SELECT queries?

  A. MQT
  B. Trigger
  C. Read Only Cursor
  D. Stored Procedure
  A. MQT

• Question 97:

  Given the following information:

  Protocol: TCP/IP Port Number: 5000 Host Name: DB_SERVER Database Name: TEST_DB Database Server Platform: Linux

  A. CATALOG DATABASEtest_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000 OSTYPE LINUX;
  B. CATALOG TCPIP NODE 5000 REMOTE SERVERdb_server OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
  C. CATALOG TCPIP NODEdb_server REMOTE db_server SERVER 5000 OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
  D. CATALOG TCPIP NODEdb_server REMOTE db_server PORT 5000 OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
  C. CATALOG TCPIP NODEdb_server REMOTE db_server SERVER 5000 OSTYPE LINUX; CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;

• Question 98:

  Assuming table TAB1 contains 100 rows, which of the following queries will return only half of the rows available?

  A. SELECT * FROM tab1 FIND FIRST 50 ROWS
  B. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY
  C. SELECT * FROM tab1 WHILE ROW_NUM < 50
  D. SELECT * FROM tab1 MAXROWS 50
  B. SELECT * FROM tab1 FETCH FIRST 50 ROWS ONLY

• Question 99:

  Which of the following statements will catalog the database MYDB on the node MYNODE and assign it the alias MYNEWDB?

  A. CATALOG DATABASEmynewdb AT NODE mynode
  B. CATALOG DATABASEmynewdb AS mydb AT NODE mynode
  C. CATALOG DATABASEmydb AT NODE mynode
  D. CATALOG DATABASEmydb AS mynewdb AT NODE mynode
  D. CATALOG DATABASEmydb AS mynewdb AT NODE mynode

• Question 100:

  Which of the following database objects can be used to raise an error if a table is updated?

  A. Package
  B. Trigger
  C. Stored Procedure
  D. Informational Constraint
  B. Trigger