2026 New 1z1-071 Dumps – Real Oracle Exam Questions [Q182-Q202]

NEW QUESTION 182
You must create a table EMPLOYEES in which the values in the columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. (Choose two.) Which two SQL statements would create the required table?

NEW QUESTION 183
Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

NEW QUESTION 184
Examine the description of the CUSTOMERStable:

Which two SELECTstatements will return these results (Choose two.):

SELECT customer_name FROM customers WHERE customer_name = ‘*Ma*’;

NEW QUESTION 185
The SQL statements executed in a user session are as follows:

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT acommand in the session? (Choose two.)

NEW QUESTION 186
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? (Choose two.)

NEW QUESTION 187
Examine the description of the CUSTOMERS table:

Which two SELECT statements will return these results:
CUSTOMER_ NAME
——————–
Mandy
Mary

NEW QUESTION 188
View the exhibit and examine the data in the PROJ_TASK_DETAILS table.

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? (Choose the best answer.)

NEW QUESTION 189
Examine this statement:

Which two statements are true?

NEW QUESTION 190
The SYSDATE function displays the current Oracle Server date as:
21 -MAY-19
You wish to display the date as:
MONDAY, 21 MAY, 201 9
Which statement will do this?

NEW QUESTION 191
Which three statements are true about single-row functions? (Choose three.)

NEW QUESTION 192
Examine the BRICKS table:

You write this query:
SELECT
FROM bricks b1 CROSS JOIN bricks b2
WHERE b1. Weight < b2. Weight:
How many rows will the query return?

NEW QUESTION 193
Which statement is true about the Oracle SQL, DELETEand TRUNCATEstatements?

NEW QUESTION 194
Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMStable and the ORD_SEQsequence? (Choose two.)

NEW QUESTION 195
View the exhibit and examine the ORDERStable.

The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

NEW QUESTION 196
View the exhibit and examine the structure of ORDERSand CUSTOMERStables.
ORDERS
Name
Null? Type
ORDER_ID NOT NULL NUMBER(4)
ORDER_DATE NOT NULL DATE
ORDER_MODE VARCHAR2(8)
CUSTOMER_ID NOT NULL NUMBER(6)
ORDER_TOTAL NUMBER(8, 2)
CUSTOMERS
Name Null? Type
CUSTOMER_ID NOT NULL NUMBER(6)
CUST_FIRST_NAME NOT NULL VARCHAR2(20)
CUST_LAST_NAME NOT NULL VARCHAR2(20)
CREDIT_LIMIT NUMBER(9,2)
CUST_ADDRESS VARCHAR2(40)
Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAMEis Robertsand CREDIT_LIMITis 600? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

NEW QUESTION 197
Examine the description of the CUSTOMERS table:

Which three statements will do an implicit conversion?

NEW QUESTION 198
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?

NEW QUESTION 199
Examine the structure of the employees table:

There is a parent/child relationship between EMPLOYEE_ID and MANAGER_ID.
You want to display the name, joining date, and manager for all the employees. Newly hired employees are yet to be assigned a department or a manager. For them, ‘No Manager1 should be displayed in the manager column.
Which SQL query gets the required output?

NEW QUESTION 200
Which three statements are true about Structured Query Language (SQL)?

NEW QUESTION 201
You execute this query:
SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),’MON’ ),’ dd”Monday for” fmMonth rrr’) FROM DUAL; What is the result?

NEW QUESTION 202
Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers’ details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?