Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Last Attempt 1z0-497 Questions

Page: 3 / 6
Total 150 questions

Oracle Database 12c Essentials Questions and Answers

Question 9

Identify two types of solutions in which you would need to use Active Data Guard and Golden Gate together.

Options:

A.

a solution that provides zero-data-loss protection at any distance without impacting database performance

B.

a solution for disaster protection and database rolling upgrades for a mission-critical OLTP database, where you also want to extract data from a data guard primary database for ETL update o' an enterprise data warehouse

C.

a solution requiring minimal planned downtime and risk, using standby first patching, database rolling upgrades, and select platform migrations

D.

a solution that helps with integrated automatic database and client failover between source and target, where you also need to establish advanced replication (such as multi master and bidirectional replication and data transformations)

Question 10

Which two statements about Automatic Data Optimization (ADO) are true?

Options:

A.

ADO policies can automatically compress data when it qualifies.

B.

ADO policies can automatically move segments when necessary.

C.

ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D.

You cannot compress at block level, but you can compress at segment level.

E.

You can compress at row level only for QUERY LOW.

Question 11

Oracle Database 12c provides new task-specific privileges (SYSBACKUP, SYSDG, and SYSKM) to handle standard administration duties. Which two statements about these standard administration privileges are true?

Options:

A.

These administrative privileges enable you to connect to the database only if the database is open.

B.

After connecting with these privileges, you are connected under a predefined user whose name is the privilege name.

C.

These administrative privileges allow a user to view DBA_xxx, GV$, VS, and SELECT on application tables.

D.

Without being a member of OSBACKUP. OSDG, and OSKM OS groups, users cannot connect as administrative users by using OS authentication.

Question 12

Which command do you use to create a local role while you are connected as the local user?

Options:

A.

create local role l_hr;

B.

create role c##_hr container=current;

C.

create role l_hr container=current;

D.

create role l_hr container=all;

Page: 3 / 6
Total 150 questions