Free Oracle 1Z0-071 Exam Questions

Become Oracle Certified with updated 1Z0-071 exam questions and correct answers

Page: 1 / 109

Total 544 Questions | Updated On: Jan 14, 2025

Add To Cart

Question 1

Which two are SQL features?

A : oviding graphical capabilities

B : oviding variable definition capabilities.

C : oviding database transaction control

D : ocessing sets of data

E : oviding update capabilities for data in external files

Answer: C,D

Question 2

Examine the types and examples of relationships that follow:

Which option indicates correctly matched relationships? (Choose the best answer.)

A : 1-d, 2-b, 3-a, and 4-c

B : 1-c, 2-d, 3-a, and 4-b

C : 1-a, 2-b, 3-c, and 4-d

D : 1-c, 2-a, 3-b, and 4-d

Answer: C

Question 3

Evaluate the following SQL statements that are issued in the given order:

CREATE TABLE emp

(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,

ename VARCHAR2(15),

salary NUMBER (8,2),

mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp(emp_no));

ALTER TABLE emp

DISABLE CONSTRAINT emp_emp_no_pk CASCADE;

ALTER TABLE emp

ENABLE CONSTRAINT emp_emp_no_pk;

What would be the status of the foreign key EMP_MGR_PK?

A : would remain disabled and can be enabled only by dropping the foreign key constraint and recreating it.

B : would remain disabled and has to be enabled manually using the ALTER TABLE command.

C : would be automatically enabled and immediate.

D : would be automatically enabled and deferred.

Answer: B

Question 4

Which two statements are true about the rules of precedence for operators? (Choose two.)

A : concatenation operator | | is always evaluated before addition and subtraction in an expression

B : ltiple parentheses can be used to override the default precedence of operators in an expression

C : ithmetic operators with equal precedence area evaluated from left to right within an expression

D : LLS influence the precedence of operators in an expression

E : + binary operator has the highest precedence in an expression in a SQL statement

Answer: B,C

Question 5

Which two statements are true about * _ TABLES views?

A : u must have SELECT privileges on a table to view it in ALL _TABLES.

B : u must have SELECT privileges on a table to view it in DBA TABLES.

C : ER_ TABLES displays all tables owned by the current user.

D : L TABLES displays all tables owned by the current user.

E : u must have SELECT privileges on a table to view it in USER TABLES.

F : l users can query DBA TABLES successfully.

Answer: A,C

Page: 1 / 109

Total 544 Questions | Updated On: Jan 14, 2025

Add To Cart