Free Oracle 1z0-071 Practice Test & Real Exam Questions

Exam Code/Number: 1z0-071
Exam Name/Title: Oracle Database SQL
Certification Provider: Oracle
Corresponding Certification: Oracle PL/SQL Developer Certified Associate

Exam Questions: 325
Updated On: Jun 27, 2026

Question #25

Which two statements are true about a self join?

A. It must be a full outer join.

B. It must be an equijoin.

C. It can be a left outer join.

D. The join key column must have an index.

E. It can be an inner join.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #26

Which three statements are true about built-in data types?

A. A VARCHAR2 column definition does not require the length to be specified.

B. A VARCHAR2 blank-pads column values only if the data stored is non-numeric and contains no special characters.

C. A BFILE stores unstructured binary data in operating system files.

D. A CHAR column definition does not require the length to be specified.

E. A BLOB stores unstructured binary data within the database.

F. The default length for a CHAR column is always one character.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #27

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?

A. SELECT TO_ CHAR (SYSDATE, ' FMDD, DAY MONTH, YYYY') FROM DUAL;

B. SELECT TO _ CHAR (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

C. SELECT TO _ DATE (SYSDATE, ' FMDAY, DD MONTH, YYYY') FROM DUAL;

D. SELECT TO_ CHAR (SYSDATE, ' FMDAY, DDTH MONTH, YYYY') FROM DUAL;

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #28

Which two join conditions in a from clause are non-equijoins?

A. tablet join table2 ON (table1.column = table2.column) where table2.column LIKE 'A'

B. table1 natural JOIN table2

C. table1 join table2 ON (table1.column >= table2.column)

D. table1 join table2 on (table1.column between table2.column] and table2.column2)

E. table1 join table2 using (column1, column2)

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #29

Evaluate these commands which execute successfully CREATE SEQUENCE ord_seq INCREMENT BY 1 START WITH 1 MAXVALUE 100000 CYCLE CACHE 5000; Create table ord_items( ord_no number(4) default ord_seq.nextval not null, Item_no number(3), Qty number(3), Expiry_date date, Constraint it_pk primary key(ord_no,item_no), Constraint ord_fk foreign key (ord_no) references orders(ord_no)); Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?

A. Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.

B. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO.

C. IF sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS.

D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times

E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #30

Which two statements cause changes to the data dictionary?

A. TRUNCATE TABLE emp:

B. SELECT * FROM user_ tab._ privs;

C. DELETE FROM scott. emp;

D. GRANT UPDATE ON scott. emp TO fin manager;

E. AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #31

Which two are true about self joins?

A. They are always equijoins.

B. They require the NOT EXISTS operator in the join condition.

C. They require table aliases.

D. They have no join condition.

E. They require the EXISTS opnrator in the join condition.

F. They can use INNER JOIN and LEFT JOIN.

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #32

Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

A. SELECT join _ date FROM employees WHERE join date > *10-02-2018';

B. SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

C. SELECT join_ date||''|| salary FROM employees;

D. SELECT join_ date + '20' EROM employees;

E. SELECT salary + '120.50' FROM employees;

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #33

Which two statements are true about the ORDER BY clause?

A. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.

B. NULLS are not included in the sort operation.

C. Column aliases can be used in the ORDER BY clause.

D. Numeric values are displayed in descending order if they have decimal positions.

E. In a character sort, the values are case-sensitive.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #34

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1,
Some sales data is duplicated In both tables.
You want to display the rows from the SALES1 table which are not present in the SALIES2 table.
Which set operator generates the required output?

A. UNION ALL

B. UNION

C. SUBTRACT

D. INTERSECT

E. MINUS

Discussion 0

Correct Answer: E Vote an answer

Question #35

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The foreign key constraint will be enabled and IMMEDIATE.

B. The primary key constraint will be enabled and IMMEDIATE.

C. The foreign key constraint will be enabled and DEFERRED.

D. The foreign key constraint will be disabled.

E. The primary key constraint will be enabled and DEFERRED.

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #36

Which three statements are true about inner and outer joins?

A. A full outer join must use Oracle syntax.

B. Outer joins can only be used between two tables per query.

C. An inner join returns matched rows.

D. Outer joins can be used when there are multiple join conditions on two tables.

E. A left or right outer join returns only unmatched rows.

F. A full outer join returns matched and unmatched rows.

Discussion 0

Correct Answer: C,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1z0-071 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z0-071 exam.