다운로드 Oracle : 1Z0-007 질문 & 답 PDF & Test Software

처음 도전하는 1Z0-007 시험이라면 무엇부터 시작해야 할지 막막하실 수 있습니다. PassTIP의 Oracle Introduction to Oracle9i: SQL 모의고사 110문항으로 학습 방향을 잡아 보시기 바랍니다.

Oracle 1Z0-007 시험 개요:

Oracle 1Z0-007 시험 요강 주제:

Oracle 1Z0-007 시험 Q&A 한눈에 보기

최신 9i DBA 1Z0-007 무료샘플문제

문제 #1

What is true about the WITH GRANT OPTION clause?

A. It is required syntax for object privileges.
B. It is used to grant an object privilege on a foreign key column.
C. It allows the grantee to grant object privileges to other users and roles.
D. It allows privileges on specified columns of tables.
E. It allows a grantee DBA privileges.

문제 #2

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows.
Which statement is valid?

A. ALTER TABLE commercials
CHANGE (description CHAR2(2000));
B. You cannot increase the size of a column if the table has rows.
C. ALTER TABLE commercials
MODIFY (description VARCHAR2(2000));
D. ALTER TABLE commercials
MODIFY (description CHAR2(2000));
E. ALTER TABLE commercials
CHANGE (description VARCHAR2(2000));

문제 #3

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. 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;
B. 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;
C. ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
D. You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
E. MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
F. 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;

문제 #4

Which three are true? (Choose three.)

A. A MERGE statement can be used to update existing rows in a table.
B. A MERGE statement can be used to insert new rows into a table.
C. A MERGE statement is used to merge the data of one table with data from another.
D. A MERGE statement replaces the data of one table with that of another.

문제 #5

Examine the data from the EMP table:

The COMMISSION column shows the monthly commission earned by the employee.
Which three tasks would require subqueries or joins in order to perform in a single step? (Choose three)

A. Decreasing the commission by 150 for the employees who are working in department 30 and earning a commission of more then 800.
B. Creating a table called COMMISSION that has the same structure and data as the columns EMP_ID and COMMISSIONS of the EMP table.
C. Increasing the commission of employee 3 by the average commission earned in department 20.
D. Finding the number of employees who do NOT earn commission and are working for department 20.
E. Deleting the records of employees who do not earn commission.
F. Inserting into the table a new employee 10 who works for department 20 and earns a commission that is equal to the commission earned by employee 3.

질문과 대답: