IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 101:

  Which type of temporal table can be used to store only time-sensitive data?

  A. Bitemporal
  B. Time-period
  C. System-period
  D. Application-period
  D. Application-period

• Question 102:

  Which statement about bitemporal tables is valid?

  A. Bitemporal tables are system tables and can only be queried by the schema owner.
  B. Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.
  C. When data in a bitemporal table is updated, a row is added to it's associated history table.
  D. Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.
  C. When data in a bitemporal table is updated, a row is added to it's associated history table.

• Question 103:

  When a COMMIT statement is executed, what happens?

  A. All locks held on the database are automatically released.
  B. Data stored in global temporary tables is automatically deleted.
  C. Open cursors defined WITH HOLD are closed, but their data is retained.
  D. The current transaction is terminated and a new transaction boundary is started.
  D. The current transaction is terminated and a new transaction boundary is started.

• Question 104:

  What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object?

  A. inline
  B. binary
  C. internal
  D. partitioned
  A. inline

• Question 105:

  Which statement is true regarding constraints?

  A. A table can only have one unique key constraint.
  B. A table can have multiple primary key constraints.
  C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.
  D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreignkey.
  C. Informational constraints tell DB2 what rules the data conforms to, but the rules are not enforced.

• Question 106:

  Which tool allows users to connect to a DB2 database using a wizard?

  A. Control Center
  B. IBM Data Studio
  C. Universal Connection Expert
  D. DB2 Connection Pool Manager
  B. IBM Data Studio

• Question 107:

  User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

  A. DBADM
  B. DBCTRL
  C. SECADM
  D. DBMAINT
  C. SECADM

• Question 108:

  Which type of table should you use if you want to define specific time periods when data is valid?

  A. Materialized query table
  B. System-period temporal table
  C. Declared global temporary table
  D. Application-period temporal table
  D. Application-period temporal table

• Question 109:

  After creating several new indexes and executing RUNSTATS, user USER1 wants to re-create a package that is stored in the database so it will take advantage of the new indexes. Which authority/privilege must user USER1 be granted in order to re-create the package?

  A. BIND
  B. REBIND
  C. BINDADD
  D. BIND_REBIND
  A. BIND

• Question 110:

  Which SQL statement will give user USER1 the ability to assign a comment to a sequence named MYSEQ?

  A. GRANT ALTER ON SEQUENCE myseq TO user1
  B. GRANT USAGE ON SEQUENCE myseq TO user1
  C. GRANT SELECT ON SEQUENCE myseq TO user1
  D. GRANT COMMENT ON SEQUENCE myseq TO user1
  A. GRANT ALTER ON SEQUENCE myseq TO user1