Free 1Z0-071 Exam Dumps

Question 31

View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?
1Z0-071 dumps exhibit

A. SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
B. SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
C. SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
D. SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;

Correct Answer:A

Question 32

Which statements are correct regarding indexes? (Choose all that apply.)

A. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically attempts to creates a unique index.
B. Indexes should be created on columns that are frequently referenced as part of any expression.
C. When a table is dropped, the corresponding indexes are automatically dropped.
D. For each DML operation performed, the corresponding indexes are automatically updated.

Correct Answer:ACD
References:
http://viralpatel.net/blogs/understanding-primary-keypk-constraint-in-oracle/

Question 33

A non-correlated subquery can be defined as . (Choose the best answer.)

A. A set of one or more sequential queries in which generally the result of the inner query is used as the search value in the outer query.
B. A set of sequential queries, all of which must return values from the same table.
C. A set of sequential queries, all of which must always return a single value.
D. A SELECT statement that can be embedded in a clause of another SELECT statement only.

Correct Answer:A

Question 34

Which three statements are true regarding the usage of the WITH clause in complex correlated subqueries: (Choose three.)

A. It can be used only with the SELECT clause.
B. The WITH clause can hold more than one query.
C. If the query block name and the table name are the same, then the table name takes precedence.
D. The query name in the WITH clause is visible to other query blocks in the WITH clause as well as to the main query block

Correct Answer:ABD

Question 35

Which three statements are true regarding subqueries?

A. Multiple columns or expressions can be compared between the main query and subquery.
B. Subqueries can contain ORDER BY but not the GROUP BY clause.
C. Main query and subquery can get data from different tables.
D. Subqueries can contain GROUP BY and ORDER BY clauses.
E. Main query and subquery must get data from the same tables.
F. Only one column or expression can be compared between the main query and subquery.

Correct Answer:ACD
References:
http://docs.oracle.com/javadb/10.6.2.1/ref/rrefsqlj13658.html