IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 81:

  A database and a table space were created using the following commands: Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert the database?

  

  A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?
  B. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
  C. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
  D. ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
  A. ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

• Question 82:

  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 83:

  Click the Exhibit button.

  

  In a DB2 Connect scenario between a Windows client and a z/OS server, the commands in the exhibit produced an SQL30061N error while trying to connect to the BIGDB001 database in the DB2T subsystem on the z/OS server: SQL30061N The database alias or database name name was not found at the remote node. Explanation: The database name is not an existing database at the remote database node. The statement cannot be processed. The z/OS DBA has confirmed that the LOCATION NAME is DB2T. Which change would enable the command in the exhibit to execute correctly?

  A. CATALOG DATABASE bigdb001 AS dsample AT NODE db2t AUTHENTICATION DCS
  B. CATALOG DCS DATABASE dsample AS db2t
  C. CATALOG DCS DATABASE db2t AS dsample
  D. CATALOG DATABASE db2t AS dsample AT NODE node001 AUTHENTICATION DCS
  B. CATALOG DCS DATABASE dsample AS db2t

• Question 84:

  A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?

  A. A RECOVER DATABASE command must be issued with the RESTART option specified.
  B. The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE command must be issued.
  C. A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified.
  D. A RECOVER DATABASE command must be re-issued with the REPLACE option specified.
  A. A RECOVER DATABASE command must be issued with the RESTART option specified.

• Question 85:

  The DBA needs to create a table with key columns YEARMONTH and YEAR. This table needs to be partitioned by column YEARMONTH with three months per data partition. Additionally, data needs to be organized by column YEAR, so that all rows within any three month date range are clustered together based on 12 months of data. Which CREATE TABLE statement will accomplish this objective?

  A. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (yearmonth))
  B. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (year) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (yearmonth))
  C. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 12)ORGANIZE BY DIMENSIONS (year))
  D. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))
  D. CREATE TABLE tab1(yearmonth INT,year CHAR(2))PARTITION BY RANGE (yearmonth) (STARTING 201001 ENDING 201012 EVERY 3)ORGANIZE BY DIMENSIONS (year))

• Question 86:

  Setting the DB2_FMP_COMM_HEAPSZ=0 will result in which the following?

  A. User-defined function calls will be disabled.
  B. In a partitioned environment, infinite communications will be enabled between partitions.
  C. In a partitioned environment, communications will not be buffered.
  D. Non-fenced routines can be invoked, however automatic database maintenance will be disabled.
  D. Non-fenced routines can be invoked, however automatic database maintenance will be disabled.

• Question 87:

  What is the minimum authority required to execute the RUNSTATS command against a table?

  A. SYSMON
  B. SQLADM
  C. DATAACCESS
  D. SECADM
  B. SQLADM

• Question 88:

  Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

  A. SORTHEAPTHRES 10000K, SORTHEAP 250K
  B. SORTHEAPTHRES 10000K
  C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K
  D. SORTHEAP AUTOMATIC, SHEAPTHRES 0
  D. SORTHEAP AUTOMATIC, SHEAPTHRES 0

• Question 89:

  If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

  A. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
  B. Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
  C. Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
  D. Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.
  A. Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.

• Question 90:

  A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?

  A. UPDATE DBM CFG USING NUM_INITAGENTS 200;db2stop;db2start;
  B. UPDATE DBM CFG USING NUM_INITAGENTS 0;db2stop;db2start;
  C. UPDATE DBM CFG USING NUM_POOLAGENTS 200;db2stop;db2start;
  D. UPDATE DBM CFG USING NUM_POOLAGENTS 0;db2stop;db2start;
  C. UPDATE DBM CFG USING NUM_POOLAGENTS 200;db2stop;db2start;