1Z0-007 무료 덤프문제 온라인 액세스

Examine the data of the EMPLOYEES table.
EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID)

Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?

• A.SELECT e.employee_id "Emp_id", e.emp_name "Employee",
• B.mgr_id "Mgr_id", m.emp_name "Manager"
  FROM employees e, employees m
  WHERE e.employee_id = m.employee_id
  AND e.salary > 4000;
• C.SELECT e.employee_id "Emp_id", e.emp_name "Employee",
• D.salary,
• E.SELECT e.employee_id "Emp_id", e.emp_name "Employee",
• F.SELECT employee_id "Emp_id", emp_name "Employee",
  salary,
  employee_id "Mgr_id", emp_name "Manager"
  FROM employees
  WHERE salary > 4000;
• G.salary,
• H.SELECT e.employee_id "Emp_id", e.emp_name "Employee",
• I.employee_id "Mgr_id", m.emp_name "Manager"
  FROM employees e, employees m
  WHERE e.mgr_id = m.mgr_id
  AND e.salary > 4000;
• J.mgr_id "Mgr_id", m.emp_name "manager"
  FROM employees e, employees m
  WHERE e.mgr_id = m.employee_id
  AND e.salary > 4000;
• K.salary,
• L.salary,
• M.employee_id "Mgr_id", m.emp_name "Manager"
  FROM employees e, employees m
  WHERE e.mgr_id = m.employee_id
  AND e.salary > 4000;

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

• A.It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
• B.It allows the MANAGER to pass the specified privileges on to other users.
• C.It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
• D.It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
• E.MANAGER must be a role.
• F.It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

• A.SELECT e.last_name, d.department_name, d.location_id
  FROM employees e, departments D
  WHERE manager_id =manager_id;
• B.SELECT employees.last_name, departments.department_name,
  departments.location_id
  FROM employees e, departments D
  WHERE e.department_id =d.department_id;
• C.SELECT last_name, department_name, location_id
  FROM employees , departments ;
• D.SELECT e.last_name, d.department_name, d.location_id
  FROM employees e, departments D
  WHERE e.department_id =d.department_id;

Which two are true about aggregate functions? (Choose two.)

• A.You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• B.You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C.You can use aggregate functions in any clause of a SELECT statement.
• D.You cannot group the rows of a table by more than one column while using aggregate functions.
• E.You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F.You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

What are two reasons to create synonyms? (Choose two.)

• A.Your tables names are too long.
• B.You have too many tables.
• C.Your tables have difficult names.
• D.You want to work on your own tables.
• E.You have too many columns in your tables.
• F.You want to use another schema's tables.