C2090-730 Online Practice Questions and Answers
Which of the following tools can be used to automate table reorganization operations?
A. Control Center
B. Command Center
C. Command Line Processor
D. Task Center
After the following SQL statement is executed:
GRANT ALL PRIVILEGES ON TABLE employee TO USER user1
Assuming user USER1 has no other authorities or privileges, which of the following actions is user USER1 allowed to perform?
A. Drop an index on the EMPLOYEE table
B. Grant all privileges on the EMPLOYEE table to other users
C. Alter the table definition
D. Drop the EMPLOYEE table
Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?
A. CREATE NICKNAME euro FOR DECIMAL (9,3)
B. CREATE ALIAS euro FOR DECIMAL (9,3)
C. CREATE DISTINCT TYPE euro AS DECIMAL (9,3)
D. CREATE DATA TYPE euro AS DECIMAL (9,3)
If the following SQL statements are executed in the order shown:
CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);
INSERT INTO table1 VALUES (123, 456);
UPDATE table1 SET c1 = NULL;
What will be the result of the following statement?
SELECT * FROM table1;
A. C1 C2
123 456
1 record(s) selected.
B. C1 C2
NULL 456
1 record(s) selected.
C. C1 C2 1 record(s) selected.
D. C1 C2 0 456 1 record(s) selected.
Given the following statement:
SELECT hyear, AVG(salary)
FROM (SELECT YEAR(hiredate) AS hyear, salary
FROM employee WHERE salary > 30000)
GROUP BY hyear
Which of the following describes the result if this statement is executed?
A. The statement will return the year and average salary for all employees that have a salary greater than $30,000, sorted by year.
B. The statement will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000.
C. The statement will return the year and average salary for all years that every employee hired had a salary greater than $30,000.
D. The statement will return the year and average salary for all years that any employee had a salary greater than $30,000.
Given the following table definition:
SALES
SALES_DATE DATE
SALES_PERSON CHAR(20)
REGION CHAR(20)
SALES INTEGER
Which of the following SQL statements will remove all rows that had a SALES_DATE in the year 1995?
A. DELETE * FROM sales WHEREYEAR(sales_date) = 1995
B. DELETE FROM sales WHEREYEAR(sales_date) = 1995
C. DROP * FROM sales WHEREYEAR(sales_date) = 1995
D. DROP FROM sales WHEREYEAR(sales_date) = 1995
Which of the following best describes a unit of work?
A. It is a recoverable sequence of operations whose point of consistency is established when a connection to a database has been established or when a mechanism known as asavepoint is created.
B. It is a recoverable sequence of operations whose current point of consistency can be determined by querying the system catalog tables.
C. It is a recoverable sequence of operations whose point of consistency is established when an executable SQL statement is processed after a connection to a database has been established or a previous transaction has been terminated.
D. It is a recoverable sequence of operations whose point of consistency is only established if a mechanism known as asavepoint is created.
Which of the following actions may cause a trigger to be fired?
A. DROP
B. ALTER
C. DELETE
D. ROLLBACK
An application has acquired a Share lock on a row in a table and now wishes to update the row. Which of the following statements is true?
A. The application must release the row-level Share lock it holds and acquire an Update lock on the row
B. The application must release the row-level Share lock it holds and acquire an Update lock on the table
C. The row-level Share lock will automatically be converted to a row-level Update lock
D. The row-level Share lock will automatically be escalated to a table-level Update lock
Which of the following resources can be referenced in the LOCK statement?
A. Row
B. Table
C. Column D. Table space