IBM DB2 9 Family Fundamentals - 000-730 FREE EXAM DUMPS QUESTIONS & ANSWERS
Which of the following describes the objects of a DB2 database and their relationships?
Correct Answer: D
Vote an answer
A transaction using the Read Stability isolation level scans the same table multiple times before it terminates. Which of the following can occur within this transaction's processing?
Correct Answer: B
Vote an answer
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
Correct Answer: D
Vote an answer
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?
Correct Answer: C
Vote an answer
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?
Correct Answer: B
Vote an answer
Given the following table:
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?
TEMP_DATA
TEMP DATE
45 12/25/2006 51 12/26/2006 67 12/27/2006 72 12/28/2006 34 12/29/2006 42 12/30/2006
And the following SQL statement:
CREATE FUNCTION degf_to_c (temp INTEGER) RETURNS INTEGER LANGUAGE SQL CONTAINS SQL NO EXTERNAL ACTION DETERMINISTIC BEGIN ATOMIC DECLARE newtemp INTEGER; SET newtemp = temp - 32; SET newtemp = newtemp * 5; RETURN newtemp / 9; END
Which two of the following SQL statements illustrate the proper way to invoke the scalar function DEGF_TO_C?
Correct Answer: B,E
Vote an answer
User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges user USER1 holds?
Correct Answer: A
Vote an answer
Which of the following can be viewed with the Journal?
Correct Answer: C
Vote an answer
Which of the following products must be installed on an AIX server in order to build an application for AIX that will access a DB2 for z/OS database?
Correct Answer: B
Vote an answer
Which two of the following privileges is required in order to use a package?
Correct Answer: C,D
Vote an answer
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?
Correct Answer: D
Vote an answer
Which of the following tasks can NOT be performed using the Developer Workbench?
Correct Answer: C
Vote an answer
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?
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?
Correct Answer: D
Vote an answer
Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
Correct Answer: D,E
Vote an answer