
VERCO.JSC CÔNG TY CỔ PHẦN TÁI CẤU TRÚC DOANH NGHIỆP VIỆT
Trụ sở : Tầng 1 tòa Sunrise Building 2, KĐT Sài Đồng, Long Biên, Hà Nội
Điện thoại: 0438.533 533 – Fax: 0436.525 808 – Web: verco.vn
Số:……………
Hà Nội, ngày…….tháng……..năm 2017
Oracle SQL Exam No. 1
Question 1:
Examine the description of the EMPLOYEES table:
EMP_ID
NUMBER(4)
NOT NULL
LAST_NAME
VARCHAR2(30)
NOT NULL
FIRST_NAME
VARCHAR2(30)
DEPT_ID
NUMBER(2)
JOB_CAT
VARCHAR2(30)
SALARY
NUMBER(8,2)
Which statement shows the department ID, minimum salary, and maximum
salary paid in that department, only of the minimum salary is less then 5000
and the maximum salary is more than 15000?
A. SELECT dept_id, MIN(salary(, MAX(salary)
FROM employees
WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
WHERE MIN(salary) < 5000 AND MAX(salary) > 15000
GROUP BY dept_id;
C. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
GROUP BY dept_id
HAVING MIN(salary) < 5000 AND MAX(salary) < 15000;
E. SELECT dept_id, MIN(salary), MAX(salary)
FROM employees
GROUP BY dept_id, salary
HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
Question 2:
You added a PHONE_NUMBER column of NUMBER data type to an existing
EMPLOYEES table. The EMPLOYEES table already contains records of 100
employees. Now, you want to enter the phone numbers of each of the 100
employees into the table.
Some of the employees may not have a phone number available. Which data
manipulation operation do you perform?
A. MERGE
B. INSERT
C. UPDATE
D. ADD
E. ENTER
Oracle SQL Exam No.1 - 2005
Page 1 of 17
Bình luận