Free 1Z0-071 Exam Dumps

Question 71

Which statements are true? (Choose all that apply.)

A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views consists of joins of dictionary base tables and user-defined tables.
C. The usernames of all the users including the database administrators are stored in the data dictionary.
D. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
E. Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.
F. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary.

Correct Answer:CDF
References:
https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

Question 72

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)
1Z0-071 dumps exhibit
You executed this UPDATE statement: UPDATE
( SELECT order_date, order_total, customer_id FROM orders) Set order_date = '22-mar-2007'
WHERE customer_id IN
(SELECT customer_id FROM customers
WHERE cust_last_name = 'Roberts' AND credit_limit = 600); Which statement is true regarding the execution?

A. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
B. It would not execute because two tables cannot be referenced in a single UPDATE statement.
C. It would execute and restrict modifications to the columns specified in the SELECT statement.
D. It would not execute because a SELECT statement cannot be used in place of a table name.

Correct Answer:C

Question 73

You need to display the date 11-oct-2007 in words as ‘Eleventh of October, Two Thousand Seven’. Which SQL statement would give the required result?

A. SELECT TO_CHAR (TO_DATE (’11-oct-2007’), ‘fmDdthsp “of” Month, Year’)FROM DUAL
B. SELECT TO_CHAR (‘11-oct-2007’, ‘fmDdspth “of” Month, Year’)FROM DUAL
C. SELECT TO_CHAR (TO_DATE (‘11-oct-2007’), ‘fmDdspth of month, year’)FROM DUAL
D. SELECT TO_DATE (TO_CHAR (’11-oct-2007’), ‘fmDdspth “of” Month, Year’))FROM DUAL

Correct Answer:C

Question 74

Which three statements are true regarding the SQL WHERE and HAVING clauses?

A. The HAVING clause conditions can have aggregating functions.
B. The HAVING clause conditions can use aliases for the columns.
C. The WHERE and HAVING clauses cannot be used together in a SQL statement.
D. The WHERE clause is used to exclude rows before grouping data.
E. The HAVING clause is used to exclude one or more aggregated results after grouping data.

Correct Answer:ADE

Question 75

Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

A. The outer query stops evaluating the result set of the inner query when the first value is found.
B. It is used to test whether the values retrieved by the inner query exist in the result of the outer query.
C. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.
D. The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.

Correct Answer:AC
References:
http://www.techonthenet.com/oracle/exists.php