Curious about Actual Oracle Database (1Z0-071) Exam Questions?

Here are sample Oracle Database SQL (1Z0-071) Exam questions from real exam. You can get more Oracle Database (1Z0-071) Exam premium practice questions at TestInsights.

Page: 1 /
Total 321 questions

Want more questions? Get Premium Access.

Question 1

Examine the description of the EMPLOYEES table

You write this failing statement:

SELECT dept_no AS department_id, MAX (salary) As max_sal

FROM employees

WHERE salary >10000

GROUP BY department_id

ORDER BY max_sal;

Which clause causes the error?

AORDER BY

BWHERE

CGROUP BY

DSELECT

Correct : C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AORDER BY

BWHERE

CGROUP BY

DSELECT

0 / 1500

Question 2

Examine the description of the EMPLOYEES table

Which two queries return the highest salary in the table?

ASELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

BSELECT MAX (salary)
FROM employees;

CSELECT MAX (salary)
FROM employees
GROUP BY department_id;

DSELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

ESELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

Correct : B, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

BSELECT MAX (salary)
FROM employees;

CSELECT MAX (salary)
FROM employees
GROUP BY department_id;

DSELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

ESELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

0 / 1500

Question 3

Which two statements are true about Entity Relationships?

AA Relationship can be mandatory for both entities

BA one-to-one relationship is always a self-referencing relationship

CA many-to-many relationship can be implemented only by using foreign keys

DA table name can be specified just once when selecting data from a table having a selfreferencing relationship

EA one-to-many relatonship in one direction is a one-to-one relationship in the other direction

Correct : A, C

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AA Relationship can be mandatory for both entities

BA one-to-one relationship is always a self-referencing relationship

CA many-to-many relationship can be implemented only by using foreign keys

DA table name can be specified just once when selecting data from a table having a selfreferencing relationship

EA one-to-many relatonship in one direction is a one-to-one relationship in the other direction

0 / 1500

Question 4

You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table:

1. SELECT

2. INSERT

3. UPDATE

4. DELETE

You connect to the database instance an perform an update to some of the rows in

EMPLOYEE_RECORDS, but don't commit yet.

Andrew connects to the database instance and queries the table

No othet user are accessing the table

Which two statements ate true at this point?

AAndrew will be able to modify any rows in the table that have not been modified by your transaction

BAndrew will be unable to see the changes you have made

CAndrew will be able to see the changes you habe made

DAndrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

EAndrew will be able to SELECT from the table, but be unable to modify any existing rows.

Correct : A, B

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

AAndrew will be able to modify any rows in the table that have not been modified by your transaction

BAndrew will be unable to see the changes you have made

CAndrew will be able to see the changes you habe made

DAndrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

EAndrew will be able to SELECT from the table, but be unable to modify any existing rows.

0 / 1500

Question 5

Examine the description of the EMPLOYEES table:

Which two queries return rows for employees whose manager works in a different department?

ASELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

BSELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

CSELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

DSELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

ESELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

Correct : D, E

Options Selected by Other Users:

Mark Question:

Start a Discussions

Submit Your Answer:

ASELECT emp. *
FROM employees emp
WHERE manager_ id NOT IN (
SELECT mgr.employee_ id
FROM employees mgr
WHERE emp. department_ id < > mgr.department_ id
);

BSELECT emp.*
FROM employees emp
WHERE NOT EXISTS (
SELECT NULL
FROM employees mgr
WHERE emp.manager id = mgr.employee_ id
AND emp.department_id<>mgr.department_id
);

CSELECT emp.*
FROM employees emp
LEFT JOIN employees mgr
ON emp.manager_ id = mgr.employee_ id
AND emp. department id < > mgr. department_ id;

DSELECT emp. *
FROM employees emp
RIGHT JOIN employees mgr
ON emp.manager_ id = mgr. employee id
AND emp. department id <> mgr.department_ id
WHERE emp. employee_ id IS NOT NULL;

ESELECT emp. *
FROM employees emp
JOIN employees mgr
ON emp. manager_ id = mgr. employee_ id
AND emp. department_ id<> mgr.department_ id;

0 / 1500

Page: 1 / 65
Total 321 questions

Unlock Full
1Z0-071 Exam Features

In Just $49 You can Access

All Official Question Types
Interactive Web-Based Practice Test Software
No Installation or 3rd Party Software Required
Customize your practice sessions (Free Demo)
24/7 Customer Support

Get Full Access Now

Marked Questions
1Z0-071 Exam

1Z0-071 Exam Question 1
1Z0-071 Exam Question 2
1Z0-071 Exam Question 3
1Z0-071 Exam Question 4
1Z0-071 Exam Question 5

Download PDF File Demo

Try Web-Based Exam Practice Software Demo

Commenting

In order to participate in the comments you need to be logged-in.
You can sign-up or login