Oracle Introduction to Oracle9i: SQL - 1Z0-007무료 덤프문제 풀어보기

A. cannot be nested

B. act on each row returned

C. accept only one argument and return only one value

D. return one result per row

E. manipulate data items

F. accept arguments which can be a column or an expression

A. CREATE ROLE manager;
GRANT create table, create voew
TO manager;
GRANT manager ROLE TO BLAKE,CLARK;

B. CREATE ROLE manager;
GRANT create table, create view
TO manager;
GRANT manager TO BLAKE,CLARK;

C. GRANT manager ROLE TO BLAKE,CLARK;
GRANT create table, create voew
TO BLAKE CLARK;
***MISSING***

A. CREATE INDEX NAME_IDX (first_name, last_name);

B. CREATE INDEX NAME_IDX
ON (first_name, last_name);

C. CREATE INDEX NAME_IDX
FOR employees(first_name, last_name);

D. CREATE INDEX NAME_IDX (first_name AND last_name);

E. CREATE INDEX NAME_IDX
ON employees(first_name, last_name);

F. CREATE INDEX NAME_IDX
ON employees (first_name AND last_name);

A. SELECT *
FROM DEPT;

B. SELECT *
FROM DBA.SCOTT.DEPT;

C. SELECT *
FROM SCOTT.DEPT;

D. SELECT *
FROM ALL_USERS
WHERE USER_NAME = 'SCOTT'
AND TABLE NAME = 'DEPT';

A. salary,

B. salary,

C. SELECT e.employee_id "Emp_id", e.emp_name "Employee",

D. employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.mgr_id
AND e.salary > 4000;

E. mgr_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.employee_id = m.employee_id
AND e.salary > 4000;

F. salary,

G. SELECT employee_id "Emp_id", emp_name "Employee",
salary,
employee_id "Mgr_id", emp_name "Manager"
FROM employees
WHERE salary > 4000;

H. salary,

I. mgr_id "Mgr_id", m.emp_name "manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;

J. SELECT e.employee_id "Emp_id", e.emp_name "Employee",

K. SELECT e.employee_id "Emp_id", e.emp_name "Employee",

L. employee_id "Mgr_id", m.emp_name "Manager"
FROM employees e, employees m
WHERE e.mgr_id = m.employee_id
AND e.salary > 4000;

M. SELECT e.employee_id "Emp_id", e.emp_name "Employee",

A. The ORDER BY clause is executed first in the query execution.

B. The ORDER BY clause comes last in the SELECT statement.

C. The ORDER BY clause is executed on the client side.

D. The ORDER BY clause must precede the WHERE clause.

E. The sort is in descending order by default.

F. The sort is in ascending by order by default.

A. There is no row with dept_id 90 in the EMPLOYEES table.

B. You cannot specify column names in the DELETE clause of the DELETE statement.

C. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.

D. You cannot delete the JOB_ID column because it is a NOT NULL column.

A. A view cannot be created with a GROUP BY clause in the SELECT statement.

B. A view must have aliases defined for the column names in the SELECT statement.

C. A view can be created as a join on two or more tables.

D. A view cannot have an ORDER BY clause in the SELECT statement.

E. A view can be created as read only.