IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 1:

  What is the proper set of steps to execute a redirected restore and change the container paths for a database not using automatic storage?

  A. Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;
  B. Issue a RESTORE DATABASE command with the REDIRECT option;issue a RESTORE DATABASE command with the CONTINUE option;
  C. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a RESTORE DATABASE command with the CONTINUE option;
  D. Issue a RESTORE DATABASE command with the ROLLFORWARD option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;
  A. Issue a RESTORE DATABASE command with the REDIRECT option;issue a SET TABLESPACE CONTAINERS command;issue a RESTORE DATABASE command with the CONTINUE option;

• Question 2:

  Given the following statement:

  

  Which statement will successfully add a new partition to table T1 for April 2010?

  A. Export data from the main partitioned table; create a table with the same definition as the partitioned table; attach to the main partitioned table; import data into the main partitioned table; run the SET INTEGRITY statement.
  B. Create a table with the same definition as the partitioned table; attach to the main partitioned table; data will be automatically redistributed across all table partitions.
  C. Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.
  D. Export data from the main partitioned table; drop the main partitioned table; create the main partitioned table with new partitioning range; import data into the main partitioned table.
  C. Create a table with the same definition as the partitioned table; load the new table with data; attach the new table to the main partitioned table; run the SET INTEGRITY statement.

• Question 3:

  What determines the degree of inter-partition parallelism used?

  A. The number of database partitions and the definition of partition groups.
  B. The number of database connections and the definition of partitions groups.
  C. The value of the INTER_PARALLEL Database Manager configuration parameter.
  D. The value of the DFT_DEGREE database configuration parameter.
  A. The number of database partitions and the definition of partition groups.

• Question 4:

  Given a newly created database and sufficient memory. If the following statements are successful: CREATE BUFFERPOOL bp1 SIZE 40MB; CREATE BUFFERPOOL bp2 PAGESIZE 16K SIZE 40000; How much memory will be allocated for buffer pools BP1 and BP2?

  A. 40MB
  B. 80MB
  C. 665MB
  D. 680MB
  C. 665MB

• Question 5:

  Which command CANNOT be used to create the compression dictionary for a table?

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

• Question 6:

  What will the db2audit facility do when a DB2 database instance is stopped?

  A. Stop automatically.
  B. Generate an error stating that the audit facility should be stopped prior to stopping the instance.
  C. Remain active.
  D. Write an error message to the audit log and stop automatically.
  C. Remain active.

• Question 7:

  If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?

  A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'
  B. ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')
  C. ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')
  D. ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')
  A. ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'

• Question 8:

  A database called PRODDB has a weekly full backup taken on Saturday, non-cumulative (delta) backups taken daily, and a midweek cumulative backup that is taken on Wednesday. A database crash occurs on a Saturday prior to the full

  backup being taken.

  What is the fastest way to restore the database?

  A. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
  B. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Monday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Tuesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Wednesday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Thursday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
  C. RESTORE DB proddb TAKEN AT (Friday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Saturday);
  D. RESTORE DB proddb TAKEN AT (Saturday);RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);
  A. RESTORE DB proddb INCREMENTAL AUTOMATIC TAKEN AT (Friday);

• Question 9:

  What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

  A. SECADM authority
  B. EXECUTE privilege on audit routines with DATA
  C. DBADM authority
  D. EXECUTE privilege on audit routines with NO DATA
  E. SYSADM authority
  A. SECADM authority
  B. EXECUTE privilege on audit routines with DATA

• Question 10:

  A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

  A. Configuration Advisor
  B. Partition Assistant
  C. Design Advisor
  D. Workload Manager
  C. Design Advisor