QUESTION: 57

View the exhibit and examine the structure of the CUSTOMERS table.

Which two tasks would require subqueries or joins to be executed in a single statement?

finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'
listing of customers who do not have a credit limit and were born before 1980
finding the number of customers, in each city, whose marital status is 'married'
listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.

Answer(s): A,E

Show Answer Next Question

QUESTION: 58

Which statement is true about transactions?

A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.
Each Data Definition Language (DDL) statement executed forms a single transaction.
A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.

Answer(s): B

Reference:

https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

Show Answer Next Question

View the exhibit and examine the structure in ORDERS and ORDER_ITEMS tables.

You need to create a view that displays the ORDER_ID, ORDER_DATE, and the total number of items in each order.

Which CREATE VIEW statement would create the view successfully?

Option A
Option B
Option C
Option D

Answer(s): C

Show Answer Next Question

QUESTION: 60

Which statement is true about an inner join specified in the WHERE clause of a query?

It must have primary-key and foreign-key constraints defined on the columns used in the join condition.
It requires the column names to be the same in all tables used for the join conditions.
It is applicable for equijoin and nonequijoin conditions.
It is applicable for only equijoin conditions.

Answer(s): C

Show Answer Next Question

Free Oracle 1Z0-071 Exam Braindumps (page: 16)

QUESTION: 57

QUESTION: 58

Reference:

QUESTION: 59

QUESTION: 60

1Z0-071 Exam Discussions & Posts