Create Next App

Exam contains 267 questions

Page 3 of 45

Question 13 🔥

You own table DEPARTMENTS, referenced by views, indexes, and synonyms.Examine this command which executes successfully:DROP TABLE departments PURGE;Which three statements are true? (Choose three.)

Which database solution meets these requirements?

A. It will remove the DEPARTMENTS table from the database.

Highly voted

B. It will drop all indexes on the DEPARTMENTS table.

Highly voted

C. It will remove all views that are based on the DEPARTMENTS table.

Highly voted

D. It will remove all synonyms for the DEPARTMENTS table.

Highly voted

E. Neither can it be rolled back nor can the DEPARTMENTS table be recovered.

Highly voted

F. It will delete all rows from the DEPARTMENTS table, but retain the empty table.

Highly voted

Discussion of the question

Question 14 🔥

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

Which database solution meets these requirements?

A. It requires that data be contained in hierarchical data storage.

Highly voted

B. It best supports relational databases.

Highly voted

C. It provides independence for logical data structures being manipulated from the underlying physical data storage.

Highly voted

D. It is the only language that can be used for both relational and object-oriented databases.

Highly voted

E. It guarantees atomicity, consistency, isolation, and durability (ACID) features.

Highly voted

F. It is used to define encapsulation and polymorphism for a relational table.

Highly voted

Discussion of the question

Question 15 🔥

Which two statements are true about Oracle synonyms? (Choose two.)

Which database solution meets these requirements?

A. Any user can create a PUBLIC synonym.

Highly voted

B. A synonym has an object number.

Highly voted

C. All private synonym names must be unique in the database.

Highly voted

D. A synonym can be created on an object in a package.

Highly voted

E. A synonym can have a synonym.

Highly voted

Discussion of the question

Question 16 🔥

Which is true about the ROUND, TRUNC and MOD functions?

Which database solution meets these requirements?

A. TRUNC(MOD(25,3),-1) is invalid.

Highly voted

B. ROUND(MOD(25,3),-1) is invalid.

Highly voted

C. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid and give the same result.

Highly voted

D. ROUND(MOD(25,3),-1) and TRUNC(MOD(25,3),-1) are both valid but give different results.

Highly voted

Discussion of the question

Question 17 🔥

Which two are true about transactions in the Oracle Database? (Choose two.)

Which database solution meets these requirements?

A. DML statements always start new transactions.

Highly voted

B. DDL statements automatically commit only data dictionary updates caused by executing the DDL.

Highly voted

C. A session can see uncommitted updates made by the same user in a different session.

Highly voted

D. A DDL statement issued by a session with an uncommitted transaction automatically commits that transaction.

Highly voted

E. An uncommitted transaction is automatically committed when the user exits SQL*Plus.

Highly voted

Discussion of the question

Question 18 🔥

Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.)

Which database solution meets these requirements?

A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

Highly voted

B. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

Highly voted

C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Highly voted

D. SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;

Highly voted

E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_071

Exam contains 267 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us