Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the Oracle Database 19c 1z0-076 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.
Exam 1z0-076 Premium Access

View all detail and faqs for the 1z0-076 exam

Go to Exam

629 Students Passed

85% Average Score

90% Same Questions
Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions
Questions # 11:

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

Options:

A.

To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

B.

To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.

C.

A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.

D.

A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.

E.

The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.

Questions # 12:

Which TWO statements are true about database parameters for databases in a Data Guard environment?

Options:

A.

If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.

B.

The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.

C.

COMPATIBLE must have identical values for primary and standby databases.

D.

LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.

E.

DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.

Questions # 13:

You created two remote physical standby databases using SQL and RMAN.

The primary database is a four-instance RAC database and each physical standby database has two instances.

Roles-based services are used for client connectivity and have been defined in the Grid Infrastructure.

Consider these operational requirements:

• The ability to manage multiple standby databases with a single tool

• The simplification of switchovers, failovers, reinstatements, and conversions to and from snapshot standby databases

• The automation of failovers to a specified target standby database

Which TWO tools can be used to fulfill these requirements7

Options:

A.

RMAN

B.

SQL*Plus

C.

CRSCTL

D.

Enterprise Manager Cloud Control

E.

DGMGRL

F.

SRVCTL

G.

GDCCTL

Questions # 14:

You have a Data Guard broker configuration consisting of:

    A primary database

    One local physical standby database

    One far sync instance

    A remote physical standby database

The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.

What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

Options:

A.

Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard broker configuration will be discovered as targets automatically and be ready to be monitored.

B.

Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.

C.

Discover the primary database as a target in Enterprise Manager Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

D.

Use the DGMGRL utility to register the configuration with the Enterprise Manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.

E.

Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

Questions # 15:

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:

    Data loss is not permitted.

    Read-only applications should not connect to the primary database instance.

Additionally, there are these requirements, only one of which is ever done at any one time:

    It should be possible to apply and test designated patches with a minimum amount of downtime.

    Upgrading to a new database release should be performed with the least possible amount of downtime.

    New application software releases should be tested against an exact up-to-date replica of the production database.

You propose a primary database with one physical standby database configured in Maximum Protection mode.

Which requirements do you meet?

Options:

A.

1 and 2

B.

1, 2, 3, 4, and 5

C.

Only requirement 5

D.

Only requirement 1

E.

2, 3, 4, and 5

Questions # 16:

There are currently 6 applief. and 6 pfepafef processes running and no idle applier processes on y logical standby database.

The max_SERVERS SQL apply parameter and number of archiver processes are both set to 12.

Identify two changes, each of which would allow you to increase the number of applier processes.

Options:

A.

Decrease the number of archiver processes on the standby database.

B.

Increase the processes initialization parameter. D Decrease the number of FREPARER processes.

C.

Increase the value for the MAX_SERVERS SQL apply parameter.

D.

Increase the parallel_max_server initialization parameter.

E.

Increase the RECOVERY_PARALLEL initialization parameter.

Questions # 17:

A customer asks for your recommendation regarding this requirement:

1. We plan to have a Data Guard Configuration with one primary database and one physical standby database.

2. We want zero data loss in case of a disaster involving the loss of one component.

3. We want to do Real Application Testing occasionally on the Standby Database.

Which solution, if any, satisfies these requirements?

Options:

A.

These requirements cannot be met.

B.

A physical standby database with synchronous redo transport that can be converted regularly into a snapshot standby to do real application testing

C.

A snapshot standby database with real time query that can be converted regularly into a physical standby database open read write, to do real application testing

D.

A far sync instance plus a snapshot standby database and real time apply that can be converted regularly into logical standby database to do real application testing

Questions # 18:

Which four statements are true regarding SQL Apply filters for a logical standby database?

Options:

A.

They can be used to skip execution of DML triggers on a table while allowing the DML to execute.

B.

They can be used to skip CREATE TABLE commands.

C.

They can be used to skip ALTE1 STEM and ALTER DATABASE commands.

D.

They can only be used to skip DML statements on a table.

E.

They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB).

F.

They can be used to stop SQL apply if it encounters an error.

G.

They can be used to skip ALTER TABLE commands on specific tables.

Questions # 19:

Which two factors can cause an increase in redo transport lag?

Options:

A.

The size of the online redo log files on the standby database.

B.

The size of the standby redo log files on the primary database.

C.

Increase in network latency between the primary database and a redo transport destination.

D.

The size of the online redo log files on the primary database.

E.

Increase in redo generation rate on the primary database.

Questions # 20:

In Oracle Database 19c, you can set the value of database initialization parameters in a database using

the EDIT DATABASE... SET PARAMETER Command:

DGMGRL> EDIT DATABASE 'boston' SET PARAMETER log_archive_trace - 1;

Which THREE statements are TRUE about the command?

Options:

A.

The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.

B.

The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.

C.

The database must be available when the above command is run.

D.

The value set using this command is directly stored in the broker configuration file.

E.

The value set using this command is directly applied to the boston database.

Viewing page 2 out of 4 pages
Viewing questions 11-20 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.

2V0-11.25
ADM-201
Agentforce-Specialist
CMMC-CCP
Data-Cloud-Consultant
PDI
PSE-Strata-Pro-24
Secure-Software-Design
Sharing-and-Visibility-Architect
Workday-Pro-Integrations
ZDTA