Check the Available 1z0-071 Exam Dumps with 308 QA’s UPDATED 2024 [Q137-Q156]

QUESTION 137
View the exhibit and examine the structure of the EMPLOYEES table.

You want to select all employees having 100 as their MANAGER_ID manages and their manager.
You want the output in two columns: the first column should have the employee’s manager’s LAST_NAME and the second column should have the employee’s LAST_NAME.
Which SQL statement would you execute?

QUESTION 138
View and Exhibit and examine the structure and data in the INVOICE table.

Which two statements are true regarding data type conversion in query expressions? (Choose two.)

QUESTION 139
View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)

The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.
The BASED_ON column indicates dependencies between tasks.
Some tasks do not depend on the completion of other tasks.
You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of the employee in charge of the task upon which it depends.
Which query would give the required result?

QUESTION 140
Examine the data in the PRODUCTS table:

Examine these queries:
1. SELECT prod name, prod list
FROM products
WHERE prod 1ist NOT IN(10,20) AND category _id=1;
2. SELECT prod name, | prod _ list
FROM products
WHERE prod list < > ANY (10,20) AND category _id= 1;
SELECT prod name, prod _ list
FROM products
WHERE prod_ list <> ALL (10, 20) AND category _ id= 1;
Which queries generate the same output?

QUESTION 141
View the Exhibit and examine the description of the EMPLOYEEStable.

You want to calculate the total renumeration for each employee. Total renumeration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission.
Which SQL statement would you execute to get the desired output?
SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct,

QUESTION 142
Which two statements are true regarding the DELETEand TRUNCATEcommands? (Choose two.)

QUESTION 143
SCOTT is a user in the database.
Evaluate the commands issued by the DBA:
Which statement is true regarding the execution of the above commands?

QUESTION 144
Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)

QUESTION 145
View the Exhibit and examine the description of the ORDERS table.

QUESTION 146
View the Exhibit and examine the structure of the ORDERStable.

Which UPDATE statement is valid?

QUESTION 147
View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement?

QUESTION 148
Examine this statement:

What is returned upon execution?

QUESTION 149
Examine these statements executed in a single Oracle session:

Which three statements are true?

QUESTION 150
Examine the description of the ENPLYEES table:

Which two queries return all rows for employees whose salary is greater than the average salary in their department?

QUESTION 151
Which two statements are true about a self join?

QUESTION 152
Which statement is true regarding the USINGclause in table joins? (Choose two.)

QUESTION 153
Which three statements are true about defining relations between tables in a relational database?

QUESTION 154
Which statement is true about TRUNCATE and DELETE?

QUESTION 155
Which statement adds a column called SALARY to the EMPLOYEES table having 100 rows, which cannot contain null?

QUESTION 156
You execute the SQL statement:

What is the outcome?