Free Access Oracle.1z0-071.v2022-08-30.q239 Practice Test (Page 36)

Question 171

Which two are true about virtual columns?

A.They can be referenced in the column expression of another virtxial column.

B.They cannot have a data type explicitly specified.

C.They can be referenced In the where clause of an update or debete statement.

D.They can be indexed.

E.They can be referenced in the set clause of an update statement as the name of the column To be updated.

Question 172

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

A.Employees 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

B.Employees 100 and 200 will have the same JOB_ID as before the update command

C.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

D.Employee 100 will have SALARY set to the same value as the SALARY of employee 200

E.Employee 200 will have SALARY set to the same value as the SALARY of employee 100

F.Employees 100 and 200 will have the same SALARY as before the update command

Question 173

Which statement is true about TRUNCATEand DELETE?

A.You can never TRUNCATEa table if foreign key constraints will be violated.

B.For large tables TRUNCATEis faster than DELETE.

C.For tables with multiple indexes and triggers DELETEis faster than TRUNCATE.

D.You can never DELETE rows from a table if foreign key constraints will be violated.

Question 174

Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario? (Choose two.)

A.The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.

B.The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.

C.STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.

D.PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.

E.An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.

Question 175

Table ORDER_ITEMS contains columns ORDER_TO, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:

Statement 2:

Which two statements are true? (Choose two.)

A.Statement 2 may return multiple rows of output.

B.Both statements will return NULLif either UNIT_PRICEor QUANTITYcontains NULL.

C.Statement 2 returns only one row of output.

D.Both the statements give the same output.

E.Statement 1 returns only one row of output.

Other Version: 4126Oracle.1z0-071.v2025-03-22.q314; 7455Oracle.1z0-071.v2024-10-24.q196; 3660Oracle.1z0-071.v2023-10-02.q276; 3039Oracle.1z0-071.v2023-05-08.q154; 7492Oracle.1z0-071.v2022-09-21.q298; 25885Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 123Adobe.AD0-E911.v2026-09-12.q35; 117Google.ADP.v2026-09-11.q22; 130AIChE.CCPSC.v2026-09-11.q41; 130Scrum.PSPO-III.v2026-09-10.q23; 220Scrum.PSPO-I.v2026-09-09.q157; 188ScaledAgile.SAFe-SPC.v2026-09-08.q108; 147Oracle.1Z0-1033-26.v2026-09-08.q43; 220Pegasystems.PEGACPSSA25V1.v2026-09-08.q144; 166BCI.CBCI.v2026-09-07.q89; 210Salesforce.Plat-Admn-202.v2026-09-07.q170

Question 171

Question 172

Question 173

Question 174

Question 175

Download PDF File