Create Next App

Exam contains 149 questions

Page 17 of 25

Question 97 🔥

Which two statements are true about the B-tree Index?

Which database solution meets these requirements?

A. The leaf blocks in the index are doubly linked.

Highly voted

B. The leaf node stores a bitmap for each key value.

Highly voted

C. Rows with a NULL value in key columns also have entries in the Index.

Highly voted

D. The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

Highly voted

Discussion of the question

Question 98 🔥

Which two statements are true about listeners?

Which database solution meets these requirements?

A. Listeners use only the TCP/IP protocol.

Highly voted

B. Multiple listener processes can run simultaneously on a host.

Highly voted

C. Multiple database instances can be registered with a single listener,

Highly voted

D. Listener-related errors can be traced only at the administrative level.

Highly voted

E. Only one database instance can be registered with a single listener at any time.

Highly voted

Discussion of the question

Question 99 🔥

You want to start a global service on your database. Which three conditions must be met?

Which database solution meets these requirements?

A. The database is open and registered with a global service manager.

Highly voted

B. The service has been disabled on that database.

Highly voted

C. The database role is different from the role attribute of the service.

Highly voted

D. The replication lag on the database does not exceed the maximum value specified for the service.

Highly voted

E. The service has reached its cardinality defined by the number of preferred databases.

Highly voted

F. No other database in the pool is a better candidate for starting the service.

Highly voted

Discussion of the question

Question 100 🔥

What must you do to an application for it to take advantage of partitioning?

Which database solution meets these requirements?

A. recompile it

Highly voted

B. rewrite its SQL queries

Highly voted

C. relink

Highly voted

D. rework the applications schema

Highly voted

E. nothing; it is transparent

Highly voted

Discussion of the question

Question 101 🔥

Which three statements about common and local roles are true?

Which database solution meets these requirements?

A. When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

Highly voted

B. Local roles can be granted only to local users.

Highly voted

C. Common roles can be granted to both local and common users.

Highly voted

D. A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

Highly voted

E. Common roles can be created in the root and PDBs.

Highly voted

Discussion of the question

Question 102 🔥

Which statement regarding Oracle Active Data Guard 12c is false?

Which database solution meets these requirements?

A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

Highly voted

B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.

Highly voted

C. It repairs block corruptions detected in the primary or standby database.

Highly voted

D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.

Highly voted

E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_497

Exam contains 149 questions

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

Company

Product

Resources

Follow us