Oracle 1Z0007
Title
: Introduction to Oracle9I:SQL
Update : Demo
http://www.KillTest.com
1. W hat does the FORCE option for creating a view do?
A.creates a view with constraints
B.creates a view even if the underlying parent table has constraints
C.creates a view in another schem a even if you don't have privileges D.creates a view regardless of whether or not the base tables exist
Answer: D
2. W hat are two reasons to create synonym s? (Choose two.)
A.You have too many tables.
B.Your tables are too long.
C.Your tables have difficult nam es.
D.You want to work on your own tables.
E.You want to use another schem a's tables.
F.You have too many columns in your tables.
Answer: CE
3. The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest
grade point average to lowest.
W hich statem ent produces a report that displays the student ID and GPA in the sorted order
requested by the registrar?
A.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa ASC; B.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa ASC;
C.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa;
D.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa;
E.SELECT student_id, gpa
FROM student_grades
SORT ORDER BY gpa DESC;
F.SELECT student_id, gpa
FROM student_grades
ORDER BY gpa DESC;
Answer: F
| English | Chinese(Traditional) | Chinese(Sim plified) |
2
KillTest Inform ati on Co., Ltd. All rights reserved.
4. In which three cases would you use the USING clause? (Choose three.)
A.You want to create a nonequijoin.
B.The tables to be joined have multiple NULL columns.
C.The tables to be joined have columns of the sam e nam e and different data types. D.The tables to be joined have columns with the sam e nam e and com patible data types.
E.You want to use a NATURAL join, but you want to restrict the num ber of colum ns in the join condition.
Answer: CDE
5. The CUSTOMERS table has these columns:
CUSTOMER_ID NUMBER(4) NOT NULL
CUSTOMER_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
CITY_ADDRESS VARCHAR2(50)
STATE_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CUSTOMER_PHONE VARCHAR2(20)
The CUSTOMER_ID column is the prim ary key for the table.
You need to determine how dispersed your custom er base is. W hich
expression finds the number of different countries represented in the CUSTOMERS table? A.COUNT(UPPER(country_address))
B.COUNT(DIFF(UPPER(country_address)))
C.COUNT(UNIQUE(UPPER(country_address)))
D.COUNT DISTINCT UPPER(country_address)
E.COUNT(DISTINCT (UPPER(country_address)))
Answer: E
6. Click the Exhibit button and exam ine the data in the EMPLOYEES table.
W hich three subqueries work? (Choose three.)
A.SELECT *
FROM employees
where salary > (SELECT MIN(salary) FROM employees
GROUP BY department_id);
B.SELECT *
| English | Chinese(Traditional) | Chinese(Sim plified) |
3
KillTest Inform ati on Co., Ltd. All rights reserved.
FROM employees
W HERE salary = (SELECT AVG(salary)
FROM employees
GROUP BY department_id);
C.SELECT distinct department_id
FROM employees
W HERE salary > ANY (SELECT AVG(salary)
FROM employees GROUP BY department_id);
D.SELECT department_id
FROM employees
W HERE salary > ALL (SELECT AVG(salary)
FROM employees
GROUP BY department_id);
E.SELECT last_nam e
FROM employees
W HERE salary > ANY (SELECT MAX(salary)
FROM employees
GROUP BY department_id);
F.SELECT department_id
FROM employees
W HERE salary > ALL (SELECT AVG(salary)
FROM employees ...
Regístrate para leer el documento completo.