Free C2090-541 Exam Dumps Preview

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?

For which two purposes would you run the db2look tool? (Choose two.)

What are three default service classes used by Work Load Management? (Choose three.)

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?

Which two data types can be in-lined to enhance compression? ( Choose two.)

Click the Exhibit button.

What is the result after executing the SELECT statement shown below? SELECT COUNTO FROM applicant WHERE gender='C'

What are three implementations for DB2 Workload Management? (Choose three.)

Which administrative authority is needed to run the audit stored procedures and table functions such as the AUDIT_DELIM_EXTRACT stored procedure?

Given the following CREATE TABLE statement: CREATE TABLE applicant (id INTEGER NOT NULL PRIMARY KEY, lastname VARCHAR(50));

Which SQL statement will execute successfully?

Which two tasks can DB2 Workload Management do? (Choose two.)

Click the Exhibit button Given the INSERT statements shown below: INSERT INTO applicant VALUES (1 ,'M' 54);
INSERT INTO applicant VALUES (2, 'F', 38);
INSERT INTO applicant VALUES (3, 'M', 21);
INSERT INTO applicant VALUES (4, 'F', 91);
INSERT INTO applicant VALUES (5, 'C', 50);
INSERT INTO applicant VALUES (6, 'C', 70);
INSERT INTO applicant VALUES (7, 'C', 95);

How many rows will be successfully inserted?

Which method may be used to collect deadlock information in DB2 9.7?

A database named FINANCE must be available to users 24x7x365.

Which command should be used to create a backup image of the FINANCE database without having a significant impact on running applications?

Which HADR feature minimizes the impact of software maintenance on the Standby server?

Which statement is correct when describing the AUTOCONFIGURE command?

Which SQL statement will execute successfully?