1Z0-071 Exam Questions and Answers | Exam-Dumps.net (Page: 2)

QUESTION: 6

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

A constraint is enforced only for an INSERT operation on a table.
A foreign key cannot contain NULL values.
A column with the UNIQUE constraint can store NULLS.
You can have more than one column in a table as part of a primary key.

Answer(s): C,D

QUESTION: 7

Evaluate the following statement.

Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement?

They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
The insert statement would give an error because the ELSE clause is not present for support in case none of WHEN clauses are true.

Answer(s): A

Reference:

http://psoug.org/definition/WHEN.htm

Reveal Solution Next Question

Examine the structure of the MEMBERS table:

You want to display details of all members who reside in states starting with the letter A followed by exactly one character. Which SQL statement must you execute?

SELECT * FROM MEMBERS WHERE state LIKE '%A_';
SELECT * FROM MEMBERS WHERE state LIKE 'A_';
SELECT * FROM MEMBERS WHERE state LIKE 'A_%';
SELECT * FROM MEMBERS WHERE state LIKE 'A%';

Answer(s): B

Reveal Solution Next Question

QUESTION: 9

You want to display 5 percent of the rows from the SALES table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY WITH TIES;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS WITH TIES ONLY;
SELECT prod_id, cust_id, amount_sold
FROM sales
ORDER BY amount_sold
FETCH FIRST 5 PERCENT ROWS ONLY;

Answer(s): A

Reveal Solution Next Question

QUESTION: 10

Examine the structure of the MEMBERS table:

You execute the SQL statement:
SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members;

What is the outcome?

It fails because the alias name specified after the column names is invalid.
It fails because the space specified in single quotation marks after the first two column names is invalid.
It executes successfully and displays the column details in a single column with only the alias column heading.
It executes successfully and displays the column details in three separate columns and replaces only the last column heading with the alias.

Answer(s): D

Reveal Solution Next Question

Oracle 1Z0-071 Exam (page: 2)
Oracle Database SQL
Updated on: 25-Aug-2025

QUESTION: 6

QUESTION: 7

Reference:

QUESTION: 8

QUESTION: 9

QUESTION: 10

Oracle 1Z0-071 Exam (page: 2) Oracle Database SQL Updated on: 25-Aug-2025

QUESTION: 6

QUESTION: 7

Reference:

QUESTION: 8

QUESTION: 9

QUESTION: 10

Oracle 1Z0-071 Exam (page: 2)
Oracle Database SQL
Updated on: 25-Aug-2025