Free Oracle 1z0-071 Practice Test & Real Exam Questions, Page 2

Question #13

You execute this command:
TRUNCATE TABLE depts;
Which two are true?

A. It retains the indexes defined on the table.

B. A Flashback TABLE statement can be used to retrieve the deleted data.

C. A ROLLBACK statement can be used to retrieve the deleted data.

D. It always retains the space used by the removed rows

E. It drops any triggers defined on the table.

F. It retains the integrity constraints defined on the table.

Discussion 0

Correct Answer: A,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #14

Which three statements are true about indexes and their administration in an Oracle database?

A. A UNIQUE and non-unique index can be created on the same table column

B. A DROP INDEX statement always prevents updates to the table during the drop operation

C. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.

D. An index can be created as part of a CREATE TABLE statement.

E. A descending index is a type of function-based index

F. If a query filters on an indexed column then it will always be used during execution of the query

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #15

Examine this SQL statement
DELETE FROM employees e
WHERE EXISTS
(SELECT' dummy'
FROM emp history
WHERE employee_ id= e. employee id);
Which two are true?

A. The subquery is executed for every row in the EMPLOYEES table.

B. The subquery is not a correlated subquery.

C. The subquery is executed before the DELETE statement is executed.

D. The DELETE statement executes successfully even if the subquery selects multiple rows.

E. All existing rows in the EMPLOYEES table are deleted,

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #16

Which two statements are true about outer Joins?

A. An outer join is used to retrieve only the rows that do not meet the join condition.

B. The outer join operator (+) is used next to the column of the table without the matching rows.

C. The outer join operator (+) can be used on both sides of the join condition in an outer join.

D. The IN operator cannot be used in a condition that Involves an outer join.

E. A condition representing an outer join cannot be linked to another condition using the or logical operator.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #17

Which two are true about the MERGE statement?

A. The WHEN MATCHED clause can be used to specify the updates to be performed.

B. The WHEN NOT MATCHED clause can be used to specify the updates to be performed.

C. The WHEN MATCHED clause can be used to specify the inserts to be performed.

D. The WHEN NOT MATCHED clause can be used to specify the inserts to be performed.

E. The WHEN NOT MATCHED clause can be used to specify the deletions to be performed.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #18

Which two statements are true about CURRENT_TIMEITAMP?

A. The date is in the time zone of DBTIMEZONE.

B. The value varies depending on the setting of SESSIONTIMEZONE.

C. It always returns the same value as SYSTIMESTAMP

D. It returns a value of data type TIMESTAMP

E. The time is in the time zone of DBTIMEZONE.

F. It returns the same date as CURRENT_DATE.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #19

Which three statements are true about views in an Oracle database?

A. Views have no segment.

B. A view can be created that refers to a non-existent table in its defining query.

C. Views can join tables only if they belong to the same schema.

D. Rows inserted into a table using a view are retained in the table if the view is dropped

E. A SELECT statement cannot contain a where clause when querying a view containing a WHERE clause in its defining query

F. Views have no object number.

Discussion 0

Correct Answer: A,B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #20

Examine the description of the countries table:

Examine the description of the departments table:

Examine the description of the locations table:

Which two queries will return a list of countries with no departments?

A.

B.

C.

D.

Discussion 0

Correct Answer: A,C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #21

Which three statements about roles are true?

A. Roles are assigned to roles using the ALTER ROLE statement.

B. Privileges are assigned to a role using the ALTER ROLE statement.

C. A single user can be assigned multiple roles.

D. Privileges are assigned to a role using the GRANT statement.

E. A single role can be assigned to multiple users.

F. Roles are assigned to users using the ALTER USER statement.

G. A role is a named group of related privileges that can only be assigned to a user.

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #22

Which three are true about granting object privileges on tables, views, and sequences?

A. REFERENCES can be granted only on tables and views.

B. UPDATE can be granted only on tables and views.

C. DELETE can be granted on tables, views, and sequences.

D. INSERT can be granted on tables, views, and sequences.

E. SELECT can be granted only on tables and views.

F. ALTER can be granted only on tables and sequences.

Discussion 0

Correct Answer: A,E,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #23

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables.
You have a requirement from the supplies department to give a list containing PRODUCT _ID,SUPPLIER ID, and QUANTITY_ON HAND for all the products where in QUANTITY ON HAND is lessthan five.
Which two SQL statements can accomplish the task? (Choose two)

A. SELECT i.product id, i. quantity on hand, pi. supplier id
FROM product information pi JOIN inventories i
ON (pi.product id=i. product id)WHERE quantity on hand < 5;

B. SELECT i. product id, i. quantity .on hand, pi. supplier_id
FROM product_information pi JOIN inventories i
ON (pi. product. id=i. product id) AND quantity on hand < 5;

C. SELECT i. product_id, i. quantity_on hand, pi. supplier id
FROM product information pi JOIN inventories i USING (product id) AND quantity .on hand < 5;

D. SELECT product id, quantity on hand, supplier id
FROM product information
NATURAL JOIN inventories AND quantity .on hand < 5;

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #24

Which three are true about subqueries?

A. A subquery can be used in a HAVING clause.

B. A subquery can be used in a WHERE clause.

C. A subquery cannot be used in the select list.

D. A subquery cannot be used in a FROM clause.

E. < any returns true if the argument is less than the lowest value returned by the subquery.

F. <ANY returns true if the argument is less than the highest value returned by the subquery.

G. =ANY can only evaluate the argument against a subcjuery if it returns two or more values.

Discussion 0

Correct Answer: A,B,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Free Oracle 1z0-071 Practice Test & Real Exam Questions

Download Free Oracle 1z0-071 Demo