Free Oracle 1Z0-007 Exam Dumps Questions & Answers

The CUSTOMERS table has these columns:

Which statement finds the rows in the CUSTOMERS table that do not have a postal code?

• A.  SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL;
• B.  SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
• C.  SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
• D.  SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
• E.  SELECT customer_id, customer_name FROM customers WHERE postal_code = '________';

Evaluate the SQL statement:
1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a,
3 (SELECT dept_id, MAX(sal) maxsal
4.FROM employees
5.GROUP BY dept_id) b
6.WHERE a.dept_id = b.dept_id
7.AND a.sal < b.maxsal;
What is the result of the statement?

• A.  The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
• B.  The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
• C.  The statement produces an error at line 6.
• D.  The statement produces an error at line 3.
• E.  The statement produces an error at line 1.

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 HR table that belongs to your schema.
• B.  You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
• C.  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.  You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
• E.  You obtain the results retrieved from the public synonym HR created by the database administrator.

Which two are character manipulation functions? (Choose two.)

• A.  TRUNC
• B.  TO_DATE
• C.  TRIM
• D.  CASE
• E.  REPLACE
• F.  MOD

What is true about sequences?

• A.  Once created, a sequence is automatically available to all users.
• B.  Once created, a sequence is linked to a specific table.
• C.  Once created, a sequence is automatically used in all INSERT and UPDATE statements.
• D.  Only the DBA can control which sequence is used by a certain table.
• E.  Once created, a sequence belongs to a specific schema.