IBM C2090-730 Online Practice Questions and Exam Preparation

IBM C2090-730 Online Questions & Answers

• Question 141:

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

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

• Question 142:

  Which of the following can be viewed with the Journal?

  A. Historical information about tasks, database changes, messages, and notifications
  B. Information about licenses associated with each DB2 9 product installed on a particular system
  C. Graphical representations of data access plans chosen for SQL statements
  D. Warning and alarm thresholds for database indicators
  A. Historical information about tasks, database changes, messages, and notifications

• Question 143:

  Given the following UPDATE statement:

  UPDATE employees SET workdept =

  (SELECT deptno FROM department WHERE deptno = 'A01') WHERE workdept IS NULL

  Which of the following describes the result if this statement is executed?

  A. The statement will fail because an UPDATE statement cannot contain asubquery.
  B. The statement will only succeed if the data retrieved by thesubquery does not contain multiple records.
  C. The statement will succeed; if the data retrieved by thesubquery contains multiple records, only the first record will be used to perform the update.
  D. The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.
  B. The statement will only succeed if the data retrieved by thesubquery does not contain multiple records.

• Question 144:

  Given the following tables:

  CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2West

  How many rows would be returned using the following statement?

  SELECT location FROM continents, region

  A. 2
  B. 7
  C. 9
  D. 14
  D. 14

• Question 145:

  Given that tables T1 and T2 contain the following rows:

  Table T1: C1 C2

  5 4 5 2 5 5 Table T2: C1 C2

  5 1 5 2 5 3

  Which of the following queries will return only those rows that exist in T1 and not in T2 ?

  A. SELECT * FROM T1 MINUS SELECT * FROM T2
  B. SELECT * FROM T1 EXCEPT SELECT * FROM T2
  C. SELECT * FROM T2 UNION EXCEPT SELECT * FROM T1
  D. SELECT * FROM T1 NOT EXISTS SELECT * FROM T2
  B. SELECT * FROM T1 EXCEPT SELECT * FROM T2

• Question 146:

  Which of the following is NOT a characteristic of a declared temporary table?

  A. Declared temporary tables are not persistent and can only be used by the application that creates them
  B. It is possible for many applications to create declared temporary tables that have the same name
  C. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified
  D. Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed
  C. Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified

• Question 147:

  Which of the following is a characteristic of a schema?

  A. Foreign key references cannot cross schema boundaries.
  B. A DB2 user must be created before a schema with the same name can be created.
  C. If no schema is specified when an object is created, the default schema PUBLIC is used.
  D. A schema enables the creation of multiple objects in a database without encountering namespace collisions.
  D. A schema enables the creation of multiple objects in a database without encountering namespace collisions.

• Question 148:

  Which of the following describes the objects of a DB2 database and their relationships?

  A. Instance
  B. Table space
  C. System catalog
  D. Schema repository
  C. System catalog

• Question 149:

  The following SQL statement: DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR

  Is used to perform which type of delete operation?

  A. Positioned
  B. Searched
  C. Embedded
  D. Dynamic
  A. Positioned

• Question 150:

  A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?

  A. User ID/password file
  B. Communications layer
  C. Client applications
  D. Operating system
  D. Operating system