CREATE DISTINCT TYPE kph AS INTEGER WITH COMPARISONS
CREATE DISTINCT TYPE mph AS INTEGER WITH COMPARISONS
CREATE TABLE speed_limits
(route_num SMALLINT,
canada_sl KPH NOT NULL,
us_sl MPH NOT NULL)
Which of the following is a valid query?
A. SELECT route_num FROM speed_limits WHERE canada_sl >; 80
B. SELECT route_num FROM speed_limits WHERE canada_sl >; kph
C. SELECT route_num FROM speed_limits WHERE canada_sl >; us_sl
D. SELECT route_num FROM speed_limits WHERE canada_sl >; kph(80)
?D 27. Given the following UPDATE statement:
UPDATE address2 SET house_building=
(SELECT building FROM address1
WHERE address2.id = address1.id)
WHERE house_building IS NULL
Which of the following describes the result of the statement?
A. The statement will succeed.
B. The statement will fail because a subquery cannot exist in an UPDATE statement.
C. The statement will succeed only if ADDRESS1.ID and ADDRESS2.ID are defined as primary keys.
D. The statement will succeed if the data retrieved from the subquery does not have duplicate values for ADDRESS1.ID.
C 28. A table called EMPLOYEE has the following columns:
NAME
DEPARTMENT
PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A. GRANT INDEX (phone_number) ON TABLE employee TO user1
B. GRANT ALTER (phone_number) ON TABLE employee TO user1
C. GRANT UPDATE (phone_number) ON TABLE employee TO user1
D. GRANT REFERENCES (phone_number) ON TABLE employee TO user1
C 29. A developer is building a Windows embedded SQL application that will access DB2 UDB for OS/390 or OS/400 servers. Which of the following products is required to be installed on the Windows system in order to build the application?
会员注册
会员登录
个人空间