Question 1

Examine the description of the CUSTONERS table

CUSTON is the PRIMARY KEY.

You must derermine if any customers'derails have entered more than once using a different

costno,by listing duplicate name

Which two methode can you use to get the requlred resuit?

Options :

A : RIGHT OUTER JOIN with seif join

B : FULL OUTER JOIN with seif join

C : SUBQUERY

D : seif join

E : LEFT OUTER JOIN with seif join

Answer: C,D

Question 2

Which two statements cause changes to the data dictionary?

Options :

A : DELETE FROM scott. emp;

B : GRANT UPDATE ON scott. emp TO fin manager;

C : AITER SESSION set NLs. _DATE FORMAT = 'DD/MM/YYYY';

D : TRUNCATE TABLE emp:

E : SELECT * FROM user_ tab._ privs;

Answer: B,D

Question 3

Which two statements are true about Oracle databases and SQL?

Options :

A :

Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.

B : The database guarantees read consistency at select level on user-created tablers.

C : When you execute an UPDATE statement, the database instance locks each updated row.

D : A query can access only tables within the same schema.

E : A user can be the owner of multiple schemas In the same database.

Answer: B,C

Question 4

Which two are true about the data dictionary?

Options :

A : Base tables in the data dictionary have the prefix DBA_.

B :

All user actions are recorded in the data dictionary.

C :

The data dictionary is constantly updated to reflect changes to database objects, permissions, and data.

D :

All users have permissions to access all information in the data dictionary by default

E :

The SYS user owns all base tables and user-accessible views in the data dictionary.

Answer: C,E

Question 5

Which two statements are true about a self join?

Options :

A : The join key column must have an index.

B : It can be a left outer join.

C : It must be a full outer join.

D : It can be an inner join.

E : It must be an equijoin.

Answer: B,D

Higher Test Marks with Free Online 1Z0-071 Exam Practice

Buying Options: