Free IBM C2090-541 Exam Dumps Questions & Answers

A file named db2advise.in contains the following text:
-#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT AVG(bonus), AVG(salary) FROM employee
GROUP BY workdept ORDER BY workdept;
Which command will cause the Design Advisor to make recommendations for a database named
SAMPLE, using the information found in this file?

• A.  db2advis -d sample -i db2advise.in
• B.  db2advis -d sample -f db2advise.in
• C.  db2advis -d sample -g
• D.  db2advis -d sample -f

Click the Exhibit button.

IBM 000-541: Practice Exam
Refer to the logging configuration parameters shown in the exhibit.
What will happen if there are currently 100 active log files and DB2 needs to create log file 101?

• A.  At least one application will receive a "log full" error and at least one transaction will be rolled back because the active log space is full.
• B.  Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.
• C.  The database will appear to be hung since the active log space is full and the BLK_LOG_DSK_FUL parameter is set to YES.
• D.  Log file 101 will go into the OVERFLOWLOGPATH directory since the active log space is full and infinite logging has been enabled.

If a non-recoverable database crashes, how can a DBA successfully restart the database if a table space is damaged and cannot complete crash recovery?

• A.  The database must be restarted using the RESTART DATABASE command with the DROP PENDING TABLESPACES option specified. At that point, the database can be brought on-line and the damaged table space must be dropped and re-created.
• B.  The damaged table space must be restored from the latest backup image. Once restored from the backup image, the RESTART DATABASE command can be issued to apply all the relevant transactions from the active logs. At that point, the database will come on-line and all table spaces will be synchronized.
• C.  The damaged table space will require that the entire database be restored from the latest backup image because the database is non-recoverable and will not be accessible.
• D.  The damaged table space must be restored from the latest backup and any active transaction logs in the log path can then be applied to it using the TABLESPACE ONLINE option of the ROLLFORWARD DATABASE command. This will bring the table space on-line and synchronize it with the rest of the database.

A DBA wants to use Label Based Access Control (LBAC) to protect Individual rows in a table. Which data type must be used to create a column to hold the necessary LBAC security data?

• A.  SYSPR0C.DB2LBACU\BEL
• B.  SYSPR0C.DB2SECURITYU\BEL
• C.  SYSIBM.DB2SECURITYLABEL
• D.  SYSIBM.DB2LBACLABEL

A database administrator created a new database from an existing full database backup image. If the original database resided on a 64-bit AIX server and the new database was created on a different 64-bit AIX server, which two statements are correct? (Choose two.)

• A.  Incremental backups are not allowed until a non-incremental backup is taken.
• B.  Existing SQL procedures must be dropped and re-created in the new database before they can be used.
• C.  Incremental backup images for the original database can be used to restore the new database.
• D.  Existing packages will be copied to the new database and can be used immediately.