IBM DB2 9 Family Fundamentals - C2090-730무료 덤프문제 풀어보기
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?
정답: B
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?
정답: D
Which of the following DB2 data types CANNOT be used to create an identity column?
정답: C
Given the following tables:
CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43
6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West
How many rows would be returned using the following statement?
SELECT location FROM continents, region
CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43
6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West
How many rows would be returned using the following statement?
SELECT location FROM continents, region
정답: D
Which of the following strings can be inserted into an XML column using XMLPARSE?
정답: C
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?
정답: B
Which of the following DB2 data types can NOT be used to create an identity column?
정답: C
Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
정답: B
A table was created using the following DDL:
CREATE TABLE employee
(id SMALLINT NOT NULL,
name VARCHAR(9),
dept SMALLINT CHECK (dept BETWEEN 10 AND 100),
job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')),
hiredate DATE,
salary DECIMAL(7,2),
comm DECIMAL(7,2),
PRIMARY KEY (id),
CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500)
);
Which of the following INSERT statements will fail?
CREATE TABLE employee
(id SMALLINT NOT NULL,
name VARCHAR(9),
dept SMALLINT CHECK (dept BETWEEN 10 AND 100),
job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')),
hiredate DATE,
salary DECIMAL(7,2),
comm DECIMAL(7,2),
PRIMARY KEY (id),
CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500)
);
Which of the following INSERT statements will fail?
정답: A
What is the purpose of the Design Advisor?
정답: D