Free Access Oracle.1z1-071.v2022-04-30.q200 Practice Test (Page 20)

Question 91

View the Exhibit and examine the structures of the employees and departments tables.

You must update the employees table according to these requirements::
-Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
-Set department_id for these employees to the department id corresponding to London (locationid 2100).
-Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
-Set the employees' commission In location_id 2100 to 1.5 times the average commission of their department.
You issue this command:

What is the result?

A.It executes successfully but does not produce the desired update.

B.It generates an error because a subquery cannot have a join condition in an update statement.

C.It generates an error because multiple columns cannot be specified together in an UPDATE statement.

D.It executes successfully and produces the desired update.

Question 92

Which three actions can you perform on an existing table containing data? (Choose three.)

A.Change a DATE column containing data to a NUMBER data type

B.Add a new column as the table's first column

C.Increase the width of a numeric column

D.Define a default value that is automatically inserted into a column containing nulls

E.Change the default value of a column

F.Add a new NOT NULL column with a DEFAULT value

Question 93

Examine the description of the sales table.
The sales table has 55,000 rows.
Examine this statements:
Which two statements are true?

A.SALES1 created with 55, 000 rows

B.SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

C.SALES1 has NOT NULL constraints on any I selected columns which had those constraints I in the SALES table.

D.SALES1 created with no rows.

E.SALES1 created with 1 row.

Question 94

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

You executed this UPDATE statement:

Which statement is true regarding the execution? (Choose the best answer.)

A.It would not execute because two tables cannot be referenced in a single UPDATE statement.

B.It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.

C.It would not execute because a SELECT statement cannot be used in place of a table name.

D.It would execute and restrict modifications to the columns specified in the SELECT statement.

Question 95

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS?

A.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE.

B.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds.

C.CURRENT_DATE returns the current date and time as per the session time zone.

D.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server.

E.SYSDATE can be used in expressions only if the default date format is DD-MON-RR.

F.SYSDATE can be queried only from the DUAL table.

Other Version: 1041Oracle.1z1-071.v2025-05-13.q352; 36Oracle.Prepawayete.1z1-071.v2022-01-25.by.lauren.209q.pdf

Latest Upload: 105OCEG.GRCP.v2025-09-11.q211; 104HP.HPE0-V27.v2025-09-11.q78; 118Oracle.1Z0-1057-23.v2025-09-10.q47; 150Google.Professional-Cloud-Network-Engineer.v2025-09-09.q179; 131SAP.C-S4EWM-2023.v2025-09-08.q83; 165TheSecOpsGroup.CNSP.v2025-09-08.q20; 223CFAInstitute.ESG-Investing.v2025-09-08.q173; 158PECB.ISO-IEC-27001-Lead-Implementer.v2025-09-06.q132; 150Salesforce.Data-Architect.v2025-09-05.q216; 144Adobe.AD0-E605.v2025-09-05.q50

Question 91

Question 92

Question 93

Question 94

Question 95

Download PDF File