C2090-730 Online Practice Questions and Answers

What is the purpose of the Design Advisor?

A. To analyze workloads and make recommendations for indexes and MQTs

B. To present a graphical representation of a data access plan and recommend design changes that will improve performance

C. To replicate data between a DB2 database and another relational database

D. To configure clients so they can access databases stored on remote servers

Which of the following is NOT a characteristic of a data warehouse?

A. Summarized queries that perform aggregations and joins

B. Heterogeneous data sources

C. Voluminous historical data

D. Sub-second response time

On which of the following database objects may the SELECT privilege be controlled?

A. Sequence

B. Schema

C. Group

D. View

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?

A. REFERENCES

B. SELECT

C. UPDATE

D. ALTER

While attempting to connect to a database stored on an iSeries server from a Windows client, the following

message was displayed:

SQL1013N The database alias name or database name "TEST_DB" could not be found. Which of the following

actions can be used to help determine why this message was displayed?

A. Execute the LIST REMOTE DATABASES command on the server; look for an entry for the TEST_DB database

B. Execute the LIST DCS DIRECTORY command on the server; look for an entry for the TEST_DB database

C. Execute the LIST REMOTE DATABASES command on the client; look for an entry for the TEST_DB database

D. Execute the LIST DCS DIRECTORY command on the client; look for an entry for the TEST_DB database

Given the following statements:

CREATE TABLE t1 (c1 INTEGER, c2 CHAR(5));

CREATE TABLE t1audit (user VARCHAR(20), date DATE, action VARCHAR(20));

CREATE TRIGGER trig1 AFTER INSERT ON t1

FOR EACH ROW

MODE DB2SQL

INSERT INTO t1audit VALUES (CURRENT USER, CURRENT DATE, 'Insert');

If user USER1 executes the following statements:

INSERT INTO t1 VALUES (1, 'abc'); INSERT INTO t1 (c1) VALUES (2); UPDATE t1 SET c2 = 'ghi' WHERE c1 = 1;

How many new records will be written to the database?

A. 0

B. 2

C. 3

D. 4

Which of the following is NOT an accurate statement about views?

A. Views are publicly referenced names and no special authority or privilege is needed to use them.

B. Views can be used to restrict access to columns in a base table that contain sensitive data

C. Views can be used to store queries that multiple applications execute on a regular basis in a database

D. Views support INSTEAD OF triggers

Given the following CREATE TABLE statement:

CREATE TABLE EMPLOYEE

(EMPNO CHAR(3) NOT NULL,

FIRSTNAME CHAR(20) NOT NULL,

MIDINIT CHAR(1),

LASTNAME CHAR(20) NOT NULL,

SALARY DECIMAL(10, 2))

Which of the following will retrieve the rows that have a missing value in the MIDINIT column?

A. SELECT * FROM employee WHEREmidinit = ' '

B. SELECT * FROM employee WHEREmidinit = NULL

C. SELECT * FROM employee WHEREmidinit = " "

D. SELECT * FROM employee WHEREmidinit IS NULL

Given the following statements:

CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3)); CREATE VIEW view1 AS SELECT col1, col2 FROM table1 WHERE col1 < 100 WITH LOCAL CHECK OPTION;

Which of the following INSERT statements will execute successfully?

A. INSERT INTO view1 VALUES (50,abc)

B. INSERT INTO view1VALUES(100, abc)

C. INSERT INTO view1VALUES(50, 'abc')

D. INSERT INTO view1VALUES(100, 'abc')

Application A issues the following SQL statements within a single transaction using the Uncommitted Read

isolation level:

SELECT * FROM department WHERE deptno = 'A00';

UPDATE department SET mgrno = '000100' WHERE deptno = 'A00';

As long as the transaction is not committed, which of the following statements is FALSE?

A. Other applications not running under the Uncommitted Read isolation level are prohibited from reading the updated row

B. Application A is allowed to read data stored in another table, even if an Exclusive lock is held on that table

C. Other applications running under the Uncommitted Read isolation level are allowed to read the updated row

D. Application A is not allowed to insert new rows into the DEPARTMENT table as long as the current transaction remains active