IBM A2090-541 Actual Tests : Assessment: DB2 9.7 DBA for Linux UNIX and Windows

IBM A2090-541 Exam Syllabus Topics:

IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows Sample Questions:

1. Which statement is true about unique constraints?

A) A unique constraint is identical to a unique index.
B) There can be multiple unique constraints per table.
C) There can be only one unique constraint key per table
D) A foreign key can only reference a unique constraint.

2. 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) Log file 101 will be successfully created in the primary log path since infinite logging has been enabled. Applications will continue processing normally.
B) 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.
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.

3. Given the DDL shown below:
CREATE TABLE tab1 (coll SMALLINT );
CREATE VIEW v1 AS SELECT coll FROMtabl WHERE coll > 25 ;
CREATE VIEW V2 AS SELECT COI1 FROM v1 WITH CASCADED CHECK
OPTION
CREATE VIEW v3 AS SELECT coll FROM v2 WHERE coll < 100 ;
Which statement will fail?

A) INSERT INTO v3 VALUES (200)
B) INSERT INTO v1 VALUES (5)
C) INSERT INTO v3 VALUES (25)
D) INSERT INTO v2 VALUES (35)

4. A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

A) BACKUP DATABASE payroll USE XBSA
B) BACKUP DATABASE payroll USE SNAPSHOT
C) BACKUP DATABASE payroll USE MIRROR
D) BACKUP DATABASE payroll USE FU\SHCOPY

5. You want to federate communication between two databases. What are two key requirements? (Choose two.)

A) Enable the server for federation.
B) Enable the client for federation.
C) Define nicknames for the tables of a federated server.
D) Use the JDBC Type 4 driver.

Solutions: