Free Access Oracle.1z0-071.v2023-05-08.q154 Practice Test (Page 19)

Question 86

Examine the command to create the BOOKS table.
SQL> create table books(book id CHAR(6) PRIMARY KEY,
title VARCHAR2(100) NOT NULL,
publisher_id VARCHAR2(4),
author_id VARCHAR2 (50));
The BOOK ID value 101 does not exist in the table.
Examine the SQL statement.
insert into books (book id title, author_id values
('101','LEARNING SQL','Tim Jones')

A.It executes successfully and the row is inserted with a null PLBLISHER_ID.

B.It executes successfully onlyif NULL PUBLISHER ID column name is added to the columns list and NULL is explicitly specified In the INSERT statement.

C.It executes successfully only NULL PUBLISHER_ID column name is added to the columns list in the INSERT statement.

D.It executes successfully only if NULL is explicitly specified in the INSERT statement.

Question 87

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A.When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

B.When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

C.Creating an external table creates a dump file that can be used only by an external table in the same database.

D.Creating an external table creates a dump file that can be used by an external table in the same or a different database.

E.Creating an external table creates a directory object.

Question 88

Examine the structure of the MARKStable:

Which two statements would execute successfully? (Choose two.)
SELECT SUM(DISTINCT NVL(subject1,0)), MAX(subject1)

A.FROM marks
WHERE subject1 > AVG(subject1);
SELECT SUM(subject1+subject2+subject3)

B.FROM marks
WHERE student_name IS NULL;
SELECT student_name,SUM(subject1)

C.FROM marks
WHERE student_name LIKE 'R%';

D.FROM marks
WHERE subject1 > subject2;
SELECT student_name subject1

Question 89

In which three situations does a new transaction always start? (Choose three.)

A.when issuing a TRUNCATEstatement after a SELECT statement was issued in the same session

B.when issuing a CREATE INDEXstatement after a CREATE TABLEstatement completed successfully in the same session

C.when issuing a CREATE TABLEstatement after a SELECTstatement was issued in the same session

D.when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session

E.when issuing a DML statement after a DML statement failed in the same session

F.when issuing a SELECT FOR UPDATEstatement after a CREATE TABLE AS SELECTstatement was issued in the same session

Question 90

You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

A.INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.

B.INSERT INTO rate_list VALUES (-10) produces an error.

C.INSERT INTO rate_list VALUES (0.551) inserts the value as .55.

D.INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.

E.INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

F.INSERT INTO rate_list VALUES (0.999) produces an error.

Other Version: 3116Oracle.1z0-071.v2025-03-22.q314; 6657Oracle.1z0-071.v2024-10-24.q196; 2997Oracle.1z0-071.v2023-10-02.q276; 6662Oracle.1z0-071.v2022-09-21.q298; 5485Oracle.1z0-071.v2022-08-30.q239; 25225Oracle.1z0-071.v2022-02-20.q161; 85Oracle.Prepawaypdf.1z0-071.v2022-01-02.by.miles.211q.pdf

Latest Upload: 201PaloAltoNetworks.NGFW-Engineer.v2026-05-01.q43; 298Nokia.4A0-113.v2026-05-01.q69; 253EC-COUNCIL.312-49v11.v2026-04-30.q214; 228Microsoft.MB-820.v2026-04-30.q101; 210Salesforce.MC-202.v2026-04-30.q57; 205BICSI.INSTC_V8.v2026-04-29.q53; 334NMLS.MLO.v2026-04-28.q82; 243NCARB.Project-Management.v2026-04-28.q27; 461EMC.D-AV-DY-23.v2026-04-27.q184; 1115ServiceNow.CSA.v2026-04-27.q483

Question 86

Question 87

Question 88

Question 89

Question 90

Download PDF File