IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 61:

  A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?

  A. DB2 ConnectEnterprise Edition
  B. DB2 Workgroup Server Edition
  C. DB2 Workgroup Server Edition and DB2 ConnectEnterprise Edition
  D. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition
  D. DB2Enterprise Server Edition and DB2 Connect Enterprise Edition

• Question 62:

  Which of the following is NOT true about schemas?

  A. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default
  B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts
  C. A schema enables the creation of multiple objects in a database without encountering namespace collisions
  D. When most database objects are created, they are either implicitly or explicitly assigned to a schema
  B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts

• Question 63:

  Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?

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

• Question 64:

  Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?

  A. View
  B. Alias
  C. Table
  D. Package
  B. Alias

• Question 65:

  Which of the following actions may cause a trigger to be fired?

  A. DROP
  B. ALTER
  C. DELETE
  D. ROLLBACK
  C. DELETE

• Question 66:

  Which of the following product is allowed to access other DB2 servers, but cannot accept a client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following product must be installed on Solaris workstation? requests from other remote clients?

  A. DB2 Personal Edition
  B. DB2 Workgroup Server Edition
  C. DB2 Enterprise Server Edition
  D. DB2 Data Warehouse Edition
  A. DB2 Personal Edition

• Question 67:

  Given the following two tables:

  TAB1 R1

  A A A B B C C D E TAB2 R2

  A A B B C C D Which of the following queries returns the following result set?

  RETVAL E

  A. SELECT r1 ASretval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
  B. SELECT r1 ASretval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
  C. SELECT DISTINCT r1 ASretval FROM tab1, tab2 WHERE r1 r2
  D. SELECT r1 ASretval FROM tab1 UNION SELECT r2 AS retval FROM tab2
  B. SELECT r1 ASretval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2

• Question 68:

  Which two of the following allow you to perform administrative tasks against database objects?

  A. Control Center
  B. Journal
  C. Command Line Processor
  D. Task Center
  E. Health Center
  A. Control Center
  C. Command Line Processor

• Question 69:

  Given the following table: EMPLOYEE EMPID NAME INSTRUMENT 1 Jagger, Mick 01

  2 Richards, Keith 02

  3 Wood, Ronnie 02

  4 Watts, Charlie 03

  5 Jones, Darryl 04

  6 Leavell, Chuck 05

  If the following query is executed:

  SELECT name,

  CASE WHEN instrument = '01' THEN 'HARMONICA'

  WHEN instrument = '02' THEN 'GUITAR'

  WHEN instrument = '03' THEN 'DRUMS'

  ELSE 'UNKNOWN'

  END AS instrument

  FROM employee

  What will be the results?

  A. NAME INSTRUMENT Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl ERROR Leavell, Chuck ERROR
  B. NAME INSTRUMENT Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl 04 Leavell, Chuck 05
  C. NAME INSTRUMENT Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl UNKNOWN Leavell, Chuck UNKNOWN
  D. NAME INSTRUMENT Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl -Leavell, Chuck
  C. NAME INSTRUMENT Jagger, Mick HARMONICA Richards, Keith GUITAR Wood, Ronnie GUITAR Watts, Charlie DRUMS Jones, Darryl UNKNOWN Leavell, Chuck UNKNOWN

• Question 70:

  The following triggers were defined for a table named SALES in the order shown:

  CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 WHERE invoice = n.invoice;

  CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS WHERE invoice = n.invoice; CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005' SET MESSAGE_TEXT = 'Deletes not allowed!';

  Which of the following statements is NOT true?

  A. Once a row has been added to the SALES table, it cannot be removed
  B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today
  C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B
  D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations
  D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations