IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 51:

  Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

  A. rootdbs.
  B. Thedbspace the database was created in.
  C. One of thedbspaces listed in the DBSPACETEMP environment variable.
  D. One of thedbspaces listed in the DBSPACETEMP configuration parameter.
  C. One of thedbspaces listed in the DBSPACETEMP environment variable.

• Question 52:

  What are the main administrative roles involved in secure auditing and role separation?

  A. Database Security Administrator (DBSA), Audit Analysis Officer (AAO), Database Separation Officer (DBSO).
  B. Database Security Administrator (DBSA), Audit Trail Officer (ATO), Database System Security Officer (DBSSO).
  C. Database Server Administrator (DBSA), Audit Reader Admin (ARA), Database System Stability Officer (DBSSO).
  D. Database Server Administrator (DBSA), Audit Analysis Officer (AAO), Database System Security Officer (DBSSO).
  D. Database Server Administrator (DBSA), Audit Analysis Officer (AAO), Database System Security Officer (DBSSO).

• Question 53:

  Which storage space should be used to store columns defined as a BLOB or a CLOB?

  A. sbspace
  B. dbspace
  C. extspace
  D. blobspace
  A. sbspace

• Question 54:

  How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

  A. By limiting the size ofdbspaces.
  B. By removing specific databases.
  C. By removing specific product features.
  D. By removing all free space at the end of a chunk.
  C. By removing specific product features.

• Question 55:

  Given the SQL explain output of this star join query, which is the fact table?

  

  A. sales
  B. product
  C. region
  D. customer
  A. sales

• Question 56:

  Which role can create, alter, or delete trusted context objects?

  A. DBA
  B. DBSA C. DBSSO
  D. DBSECADM
  D. DBSECADM

• Question 57:

  When a SELECT statement is executed which statement is true?

  A. The number and duration of the locks is dependent on the ISOLATION LEVEL.
  B. If COMMITTED READ isolation is in place then the SELECT will never encounter any locking errors.
  C. Within a transaction the database server will place row or page locks on anonlogging table.
  D. If the SELECT is part of an UPDATE cursor then the database server will place an exclusive lock on the entire dataset.
  A. The number and duration of the locks is dependent on the ISOLATION LEVEL.

• Question 58:

  Which statement about temporary dbspaces is FALSE?

  A. Temporarydbspaces are not backed up.
  B. A raw table can be created in a temporarydbspace.
  C. Tables stored in temporarydbspaces are not logged.
  D. Temporarydbspaces can have non-default page sizes.
  B. A raw table can be created in a temporarydbspace.

• Question 59:

  By default, the alarm program gets executed for which event(s)?

  A. All events.
  B. Only for events with Severity code 1.
  C. Only for events with Severity code 5.
  D. Only for events with Severity code greater than 1.
  D. Only for events with Severity code greater than 1.

• Question 60:

  Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed changing data in that table. What statement about replication of the changes is true?

  A. The changes cannot be replicated.
  B. The changes are replicated by default.
  C. You have to callifx_set_erstate( ) to replicate changes.
  D. Only changes to primary key columns can be replicated.
  C. You have to callifx_set_erstate( ) to replicate changes.