IBM Assessment: DB2 9.7 DBA for Linux UNIX and Windows - A2090-541 Exam Practice Test
Which operating system has client side Kerberos support enabled by default?
Correct Answer: C
Vote an answer
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: A
Vote an answer
What are three system and database level authorizations available with DB2? (Choose three.)
Correct Answer: B,D,E
Vote an answer
Which two actions can you perform when using Optim Database Administrator? (Choose two.)
Correct Answer: B,D
Vote an answer
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
Vote an answer
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?
Correct Answer: B
Vote an answer
If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?
Correct Answer: D
Vote an answer