IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 51:

  In which two environments would intra-partition parallelism be used? (Choose two.)

  A. Single database partition, single processor core
  B. Single database partition, multiple processor cores
  C. Multiple database partitions, single processor core
  D. Multiple database partitions, multiple processor cores
  B. Single database partition, multiple processor cores
  D. Multiple database partitions, multiple processor cores

• Question 52:

  A DBA has configured an Oracle data source in a federated database (that references a table named ORA1). How do you update the statistics for table ORA1 at the federated server?

  A. Perform the equivalent of RUNSTATS on ORA1 in Oracle.
  B. Perform RUNSTATS on the ORA1 nickname at the federated server.
  C. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then perform RUNSTATS on the ORA1 nickname.
  D. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.
  D. Perform the equivalent of RUNSTATS on ORA1 in Oracle; then drop and re-create the ORA1 nickname.

• Question 53:

  What would indicate intra-partition parallelism in an Optimizer Plan?

  A. BTQ
  B. LTQ
  C. IP
  D. DTQ
  B. LTQ

• Question 54:

  Which command CANNOT be used to explicitly build a compression dictionary for a table?

  A. REORG
  B. LOAD
  C. INSPECT
  D. IMPORT
  D. IMPORT

• Question 55:

  The RECOVER command is used in an attempt to fix a damaged table space. What will the system do during the RECOVER process?

  A. Create a new temporary table space if the damaged table space is a temporary table space.
  B. Restore the database and attempt to make as much of the database available as possible.
  C. Restore the database and bypass inaccessible containers and make the rest of the table space available.
  D. Prompt the user for new container definitions for damaged or missing containers.
  B. Restore the database and attempt to make as much of the database available as possible.

• Question 56:

  If the shared sort heap threshold parameter SHEAPTHRES_SHR is set to AUTOMATIC, what will happen?

  A. All sorts will be done in a temporary table space.
  B. The shared sort memory allocation will be controlled by DB2.
  C. No shared memory is allocated for sorting.
  D. All sorts will be done in shared memory.
  B. The shared sort memory allocation will be controlled by DB2.

• Question 57:

  Given an HADR pair configured with HADR_PEER_WINDOW set to 300 seconds. If the standby server looses communication with the primary at 11:02:03 am, when can the following command be run so that the standby server will successfully be promoted to be a primary server? TAKEOVER HADR ON DB mydb BY FORCE PEER WINDOW ONLY

  A. Any time after 11:02:03 am
  B. Any time before 11:07:03 am
  C. Any time after 11:07:04 am
  D. Any time after 11:07:03 am
  B. Any time before 11:07:03 am

• Question 58:

  In order for HADR to start, which statement is true when setting the HADR_TIMEOUT database configuration value?

  A. The HADR_TIMEOUT value must be identical on both the primary and the standby server.
  B. Changes to the HADR_TIMEOUT value will take effect immediately.
  C. If the HADR_TIMEOUT value is set to -1, connection timeouts will not occur.
  D. If the HADR_TIMEOUT value is different between the two servers, the lowest value is used.
  A. The HADR_TIMEOUT value must be identical on both the primary and the standby server.

• Question 59:

  What steps, in the correct order, are performed by the SQL and XQuery compilers to generate executable code for non-federated queries?

  A. parse query; rewrite query; check semantics; pushdown predicates; execute access plan
  B. check semantics; parse query; rewrite query; build access plan
  C. parse query; check semantics; rewrite query; build access plan
  D. check semantics; parse query; build access plan; pushdown predicates; execute access plan
  C. parse query; check semantics; rewrite query; build access plan

• Question 60:

  Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

  A. GET CURRENT ACTIVE LOGFILE
  B. LIST LOGFILES
  C. GET DATABASE CONFIGURATION
  D. LIST INDOUBT TRANSACTIONS
  C. GET DATABASE CONFIGURATION