QUESTION: 253

What is true about non-equijoin statement performance?

The BETWEEN condition always performs less well than using the >= and <= conditions.
The join syntax used makes no difference to performance.
Table aliases can improve performance.
The BETWEEN condition always performs better than using the >= and <= conditions.
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

Answer(s): C

Reference:

https://www.academia.edu/17342225/SQL_notes

Show Answer Next Question

QUESTION: 252

Examine this SQL statement:

Which two are true?

The subquery is not a correlated subquery.
The subquery is executed before the DELETE statement is executed.
The DELETE statement executes successfully even if the subquery selects multiple rows.
The subquery is executed for every row in the EMPLOYEES table.
All existing rows in the EMPLOYEES table are deleted.

Answer(s): B,D

Show Answer Next Question

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters. Which query can be used?

SELECT * FROM customers WHERE city = ‘D_%’;
SELECT * FROM customers WHERE city LIKE ‘D_’;
SELECT * FROM customers WHERE city LIKE ‘D_%’;
SELECT * FROM customers WHERE city = ‘%D_’;

Answer(s): C

Show Answer Next Question

QUESTION: 250

Examine the description of the PRODUCT_STATUS table:

The STATUS column contains the values ‘IN STOCK’ or ‘OUT OF STOCK’ for each row.

Which two queries will execute successfully?

Option A
Option B
Option C
Option D
Option E
Option F

Answer(s): B,E

Show Answer Next Question

QUESTION: 249

View the Exhibit and examine the description of the tables.

You execute this SQL statement:

Which three statements are true?

The statement will execute successfully and a new row will be inserted into the SALES table.
A product can have a different unit price at different times.
The statement will fail because a subquery may not be contained in a VALUES clause.
The statement will fail if a row already exists in the SALES table for product 23.
A customer can exist in many countries.
The SALES table has five foreign keys.

Answer(s): A,E,F

Show Answer Next Question

Free Oracle 1Z0-071 Exam Questions (page: 3)

QUESTION: 253

Reference:

QUESTION: 252

QUESTION: 251

QUESTION: 250

QUESTION: 249

1Z0-071 Exam Discussions & Posts