Free Access Oracle.1z0-071.v2023-10-02.q276 Practice Test (Page 22)

Question 101

Examine the command:

What does ON DELETE CASCADE imply?

A.When the BOOKStable is dropped, the BOOK_TRANSACTIONStable is dropped.

B.When the BOOKStable is dropped, all the rows in the BOOK_TRANSACTIONStable are deleted but the table structure is retained.

C.When a row in the BOOKStable is deleted, the rows in the BOOK_TRANSACTIONStable whose BOOK_ID matches that of the deleted row in the BOOKStable are also deleted.

D.When a value in the BOOKS.BOOK_IDcolumn is deleted, the corresponding value is updated in the BOOKS_TRANSACTIONS.BOOK_IDcolumn.

Question 102

Which two statements are true regarding constraints? (Choose two.)

A.You can have more than one column in a table as part of a primary key.

B.A constraint is enforced only for an INSERT operation on a table.

C.A foreign key cannot contain NULL values.

D.A column with the UNIQUE constraint can store NULLS.

Question 103

Examine the commands used to create DEPARTMENT_DETAILSand COURSE_DETAILS tables:

You want to generate a list of all department IDs along with any course IDs that may have been assigned to them.
Which SQL statement must you use?

A.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (d.department_id=c. department_id);

B.SELECT d.department_id, c.course_id FROM department_details d LEFT OUTER JOIN course_details c ON (d.department_id=c. department_id);

C.SELECT d.department_id, c.course_id FROM department_details d RIGHT OUTER JOIN course_details c ON (c.department_id=d. department_id);

D.SELECT d.department_id, c.course_id FROM course_details c LEFT OUTER JOIN department_details d ON (c.department_id=d. department_id);

Question 104

View the Exhibit and examine the structure of the CUSTOMERStable.

Using the CUSTOMERStable, you must generate a report that displays a credit limit increase of 15% for all customers.
Customers with no credit limit should have "Not Available" displayed.
Which SQL statement would produce the required result?
SELECT NVL(TO_CHAR(cust_credit_limit*.15),'Not Available') "NEW CREDIT"

A.FROM customers;
SELECT NVL(cust_credit_limit,'Not Available')*.15 "NEW CREDIT"

B.FROM customers;

C.FROM customers;
SELECT TO_CHAR(NVL(cust_credit_limit*.15,'Not Available')) "NEW CREDIT"

D.FROM customers;
SELECT NVL(cust_credit_limit*.15,'Not Available') "NEW CREDIT"

Question 105

You execute the SQL statement:

What is the outcome?

A.It succeeds and an index is created for CITIZEN_ID.

B.It succeeds and CITY can contain only 'SEATTLE' or null for all rows.

C.It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.

D.It fails because the condition for the CNAMES constraint is not valid.

Other Version: 3175Oracle.1z0-071.v2025-03-22.q314; 6682Oracle.1z0-071.v2024-10-24.q196; 2636Oracle.1z0-071.v2023-05-08.q154; 6684Oracle.1z0-071.v2022-09-21.q298; 5538Oracle.1z0-071.v2022-08-30.q239; 25309Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 240PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 335Nokia.4A0-113.v2026-05-01.q69; 346EC-COUNCIL.312-49v11.v2026-04-30.q214; 271Microsoft.MB-820.v2026-04-30.q101; 237Salesforce.MC-202.v2026-04-30.q57; 250BICSI.INSTC_V8.v2026-04-29.q53; 369NMLS.MLO.v2026-04-28.q82; 267NCARB.Project-Management.v2026-04-28.q27; 484EMC.D-AV-DY-23.v2026-04-27.q184; 1240ServiceNow.CSA.v2026-04-27.q483

Question 101

Question 102

Question 103

Question 104

Question 105

Download PDF File