Oracle 1Z0-007 실제 시험문제 및 답변

문제1
Evaluate this SQL statement:
SELECT ename, sal, 12*sal+100 FROM emp;
The SAL column stores the monthly salary of the employee. Which change must be made
to the above syntax to calculate the annual compensation as "monthly salary plus a
monthly bonus of $100, multiplied by 12"?

A. No change is required to achieve the desired results.

B. SELECT ename, sal, 12*(sal+100) FROM emp;

C. SELECT ename, sal+100,*12 FROM emp;

D. SELECT ename, sal, (12*sal)+100 FROM emp;

정답: B

설명: (ExamPassdump 회원만 볼 수 있음)

문제2
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table.
As a user of the database, you created a table called HR in your schema. What happens when you execute this query?
SELECT *
FROM HR;

A. You obtain the results retrieved from the public synonym HR created by the database administrator.

B. You get an error message because you cannot retrieve from a table that has the same name as a public synonym.

C. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

D. You obtain the results retrieved from the HR table that belongs to your schema.

E. You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.

정답: D

설명: (ExamPassdump 회원만 볼 수 있음)

문제3
Which one is a system privilege?

A. DELETE

B. EXECUTE

C. ALTER TABLE

D. SELECT

E. CREATE TABLE

정답: E

문제4
Which are DML statements? (Choose all that apply)

A. MERGE...

B. CREAT..

C. COMMIT...

D. DELETE...

E. UPDATE...

F. DROP...

정답: A,D,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제5
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME.
The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table.
You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables.
How can you accomplish this task?

A. MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);

B. ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);

C. MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;

D. CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;

E. ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department_id = d.department_id;

F. You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.

정답: D

설명: (ExamPassdump 회원만 볼 수 있음)

문제6
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.

Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000? (Choose two)

A. SELECT emp_name, department_name, city
FROM employees e
JOIN departments d
USING (department_id)
JOIN locations 1
USING (location_id)
WHERE salary > 10000;

B. SELECT emp_name, department_name, city FROM employees e NATURAL JOIN departments, locations WHERE salary > 10000;

C. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
JOIN ON (e.department_id = d.department id)
AND (d.location_id =1.location_id)
AND salary > 10000;

D. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
WHERE salary > 10000;

E. SELECT emp_name, department_name, city FROM employees e, departments d, locations 1 WHERE e.department_id = d.department_id AND d.location_id = 1.location_id AND salary > 10000;

정답: A,E

설명: (ExamPassdump 회원만 볼 수 있음)

문제7
Evaluate these two SQL statements:
SELECT last_name, salary , hire_date
FROM EMPLOYEES
ORDER BY salary DESC;
SELECT last_name, salary, hire_date
FROM EMPLOYEES
ORDER BY 2 DESC;
What is true about them?

A. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

B. The two statements produce identical results.

C. The second statement returns a syntax error.

D. There is no need to specify DESC because the results are sorted in descending order by default.

정답: B

설명: (ExamPassdump 회원만 볼 수 있음)

문제8
Examine the statement:
GRANT select, insert, update
ON student_grades
TO manager
WITH GRANT OPTION;
Which two are true? (Choose two.)

A. MANAGER must be a role.

B. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.

C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.

E. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.

F. It allows the MANAGER to pass the specified privileges on to other users.

정답: B,F

설명: (ExamPassdump 회원만 볼 수 있음)

문제9
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.
Which SQL statement would you use to create the view EMP_VU?

A. CREATE FORCE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
NO UPDATE;

B. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
WITH CHECK OPTION;

C. CREATE FORCE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20);

D. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20);

E. CREATE VIEW emp_vu AS
SELECT *
FROM employees
WHERE department_id IN (10,20)
WITH READ ONLY;

정답: B

설명: (ExamPassdump 회원만 볼 수 있음)

최신Oracle Introduction to Oracle9i: SQL - 1Z0-007무료샘플문제

자격증의 중요성:

ExamPassdump 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: