최신IBM Assessment: DB2 9 Family Fundamentals - A2090-730무료샘플문제
문제1
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?
정답: C
문제2
Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?
Given the following requirements:
Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table.
Which of the following CREATE statements will successfully create this table?
정답: A
문제3
A stored procedure object is created into which DB2 object?
A stored procedure object is created into which DB2 object?
정답: D
문제4
Given the following set of statements:
CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 123;
INSERT INTO tab1 VALUES (789, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = NULL WHERE col1 = 789; COMMIT;
Which of the following records would be returned by the following statement?
SELECT * FROM tab1
Given the following set of statements:
CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20));
COMMIT;
INSERT INTO tab1 VALUES (123, 'Red');
INSERT INTO tab1 VALUES (456, 'Yellow');
SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS;
DELETE FROM tab1 WHERE col1 = 123;
INSERT INTO tab1 VALUES (789, 'Blue');
ROLLBACK TO SAVEPOINT s1;
INSERT INTO tab1 VALUES (789, 'Green');
UPDATE tab1 SET col2 = NULL WHERE col1 = 789; COMMIT;
Which of the following records would be returned by the following statement?
SELECT * FROM tab1
정답: B
문제5
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?
정답: C
문제6
An alias can be an alternate name for which two of the following DB2 objects?
An alias can be an alternate name for which two of the following DB2 objects?
정답: B,E
문제7
Given the following query:
SELECT last_name, first_name, age, hire_date
FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?
Given the following query:
SELECT last_name, first_name, age, hire_date
FROM employee WHERE age > 40 Which of the following clauses must be added to return the rows sorted by AGE, oldest first, and by LAST_NAME, from A to Z?
정답: C
문제8
Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
Given the following CREATE TABLE statement:
CREATE TABLE table2 LIKE table1
Which two of the following will NOT occur when the statement is executed?
정답: D,E
문제9
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?
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?
정답: C
문제10
A declared temporary table is used for which of the following purposes?
A declared temporary table is used for which of the following purposes?
정답: D
문제11
Which of the following events will NOT cause a trigger to be activated?
Which of the following events will NOT cause a trigger to be activated?
정답: C
문제12
Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?
Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?
정답: D