Oracle 1z0-076 Cert Guide PDF 100% Cover Real Exam Questions [Q40-Q56]

Rate this post

Oracle 1z0-076 Cert Guide PDF 100% Cover Real Exam Questions

Pass 1z0-076 Exam – Real Questions and Answers

Q40. Examine the procedure that you plan to execute on your logical standby:
SQL> EXECUTE DBMS_LOGSTDBY.SKIP(stmt => ‘DML’, schema_name => ‘HR’, object_name => ‘EMPLOYEE’); What is a prerequisite for execution of this procedure?

Change the redo transport mode if necessary to ASYNC.

Stop SQL Apply on the logical standby database.

Execute the DBMS_LOGSTDBY.APPLY_SET procedure to record errors that might cause SQL Apply to stop.

Stop redo transport to the logical standby database.

Q41. 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?

These requirements cannot be met.

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

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

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

Q42. Which THREE are true about using flashback database in a Data Guard environment?

It may be used to flash back a physical standby that receives redo from a far sync instance.

It may not be used to flash back a primary database after a failover to a physical standby.

When a flashback database operation is performed on a primary database, a logical standby database is also flashed back automatically.

You can use it when real-time apply is enabled in case the physical standby suffers from logical corruption.

When a flashback database operation is performed on a primary database, a physical standby database is also flashed back automatically.

You can use it when real-time apply is enabled in case the phylt may not be used to flash back a primary database after a failover to a logical standby.

Q43. Which THREE steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

Configure Oracle Net connectivity on the primary host to the standby database instance.

Establish user equivalence for the database software owner between the primary host and standby host.

startup nomount the standby database instance.

Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME name parameter.

Put the primary database into archivelog mode.

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

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

They can be used to skip CREATE TABLE commands.

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

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

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

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

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

Q45. A Data Guard environment has this configuration and these attributes:
The primary database prima is in the local region.
A physical standby database physt1 is in the local region.
A physical standby database physt2 is in a remote region.
The primary ships redo to physt1.
physt1 ships redo to physt2.
physt1 and physt2 have Real-Time Query enabled.
A sequence has been created with this SQL statement in the primary database:
CREATE SEQUENCE a NOCACHE SESSION;
Which TWO statements are TRUE?

The sequence is usable on physt1 and physt2.

The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternate redo destination has been configured on the primary database.

physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database.

physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1.

The sequence is usable on physt1 but not usable on physt2.

Q46. Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?

Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.

Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.

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

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.

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.

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

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

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

Q48. Which three statements are true……. With no Oracle Streams or Goldengate configured?

It is recommended to have them on the…

Only standby databases can write redo….

The LGWR process writes to them on ….

They are required on a logical standby for real-time apply

They are required on a physical standby for real-time apply.

They are required only for synchronous redo transport

Q49. 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?

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

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

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

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

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

Q50. Which three statements are true about redo transport?

With synchronous redo transport, LGWR ships redo directly to RFS processes on the standby database instances and waits for an acknowledgment.

An RFS process on a standby database instance may receive redo from an archiver process on the primary database instance to perform archive gap resolution.

With asynchronous redo transport, TTnn processes may read redo from the log buffer or from standby redo logs on the primary database.

Multiple RFS processes may receive redo on one standby database instance.

Multiple RFS processes may receive redo on one far sync instance.

Q51. Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxAvailability
Databases:
dogs – Primary database
sheep – Snapshot standby database
cats – Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You receive an error while attempting to raise the protection mode to Maximum Protection:
DGMGRL> edit configuration set protection mode as maxprotection;
Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode Failed.
Which is the minimum statement, or sequence of statements you must execute to enable successful raising of the protection mode to Maximum Protection?

DGMGRL> edit database dogs set property LogxptMode=sync;

DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

DGMGRL> edit database cats set property LogXptMode=sync;

DGMGRL> edit database dogs set property LogxptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;

DGMGRL> edit database dogs set property LogXptMode=sync;
DGMGRL> edit database sheep set property LogxptMode=sync;
DGMGRL> edit database cats set property LogXptMode=sync;

DGMGRL> edit database sheep set property LogXptMode=sync;

Q52. Which three are true about using RMAN in a Data Guard environment?

A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

Backups of data files taken on a physical standby are interchangeable with a primary.

A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Backups of control files taken on a physical standby are not interchangeable with a primary.

Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

Q53. Which three statements are true……. With no Oracle Streams or Goldengate configured?

It is recommended to have them on the…

Only standby databases can write redo….

The LGWR process writes to them on ….

They are required on a logical standby for real-time apply

They are required on a physical standby for real-time apply.

They are required only for synchronous redo transport

Q54. You are licensed to use Oracle Active Data Guard.
Which TWO statements are true after enabling block change tracking on a physical standby database?

It starts the RVWR process on the physical standby database instance.

It starts the CTWR process on the primary database instance.

It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database is converted.

It starts the CTWR process on the physical standby database instance.

It allows fast incremental backups to be offloaded to the physical standby database.

It allows fast incremental backups to be taken on the primary database.

Q55. You notice that the SQL apply lag on your logical standby database has increased but the redo transport lag has not.
Which four could be reasons for the increase in SQL apply lag?

An undersized undo tablespace on the logical standby

Many SQL apply operations do full table scans

An increased number of bulk updates on the primary

An increased number of bulk inserts on the primary

The standby redo log files are undersized on the primary database

An undersized shared pool

Q56. Which three are true concerning database states after a successful switchover?

The new primary database will be open read-write.

If the former primary database became a logical standby database it will be in mount state.

If the former primary database became a logical standby database it will be open read-write.

If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

If the former primary database became a physical standby database it will always be open readonly.

The former primary database will always be open.

Oracle 1z0-076 Exam Syllabus Topics:

Topic	Details
Topic 1	Backup and Recovery Considerations in an Oracle Data Guard Configuration: In this topic, Backup and recovery procedures in a Data Guard configuration are discussed, including RMAN backups, offloading to physical standby, and network-based recovery.
Topic 2	Oracle Data Guard Basics: This topic covers the essential architecture and concepts of Oracle Data Guard. It includes sub-topics such as the physical and logical standby database comparison, benefits of Data Guard, and its integration with multi-tenant databases.
Topic 3	Enhanced Client Connectivity in a Data Guard Environment: This topic focuses on enhancing client connectivity in a Data Guard setup and implementing failover procedures for seamless client redirection. It also covers application continuity to ensure uninterrupted operations during role transitions.
Topic 4	Performing Role Transitions: Here, the concept of database roles is explained, along with the steps for performing switchovers, failovers, and maintaining physical standby sessions during role transitions.
Topic 5	Oracle Data Guard Broker Basics: An overview of the Data Guard broker, its architecture, components, benefits, and configurations, is provided here. It serves as an introduction to the tool used for managing Data Guard configurations.
Topic 8	Patching and Upgrading Databases in a Data Guard Configuration: This section provides guidance on patching and upgrading databases in a Data Guard environment, along with performance optimization techniques and monitoring considerations.