IBM DB2 9.7 DBA for Linux UNIX and Windows - C2090-541 Exam Practice Test
You are unable to configure a data source using DB2 Discovery. What are three reasons why this is happening? (Choose three.)
Correct Answer: C,D,E
Click the Exhibit button
Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?
Referring to the exhibit, what are the minimum actions necessary to capture the maximum amount of diagnostic information in the db2diag.log file and the administration notification file?
Correct Answer: A
Given the following CREATE TABLE statement:
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));
Which SQL statement will execute successfully?
CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));
Which SQL statement will execute successfully?
Correct Answer: B
A file named db2advise.in contains the text shown below:
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
--#SET FREQUENCY 100
SELECT COUNTO FROM employee;
SELECT * FROM employee WHERE lastname='HAAS';
What does the line -#SET FREQUENCY 100 convey when this file is used as input for the Design
Advisor?
Correct Answer: C
You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?
Correct Answer: C
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?
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?
Correct Answer: C
Click the Exhibit button
Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving log file 1. What will happen when DB2 attempts to create log file 101?
Refer to the logging configuration parameters shown in the exhibit.
If there are currently 100 active log files and there is an error with archiving log file 1. What will happen when DB2 attempts to create log file 101?
Correct Answer: C
When are packages automatically rebound?
Correct Answer: C