Pass Your Oracle Exam with 1z0-076 Exam Dumps (Updated 111 Questions) [Q64-Q78]

NO.64 Which TWO observations are true about the Far Sync instance?

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

NO.66 A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

NO.67 You must configure on Oracle Data …….
1. A primary database
2. Three Physical Standby Databases
Examine these requirements:
A designated physical standby database should become the primary database automatically whenever the primary database fails.
2. The chosen protection mode should provide the highest level of protection possible without violating the other requirement.
Which redo transport mode and protection mode would you configure to meet these requirements?

NO.68 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?

NO.69 Which two are true about database roles in an Oracle Data Guard configuration?

NO.70 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

NO.71 Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

NO.72 Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

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

NO.74 Suppose that you manage the following databases in your environment:
* boston: Primary database with a single PDB called DEVI
* london: Physical standby database protecting the PDB called DEVI
* orcl: Stand-alone database with a single PDB called PDB1 as a remote clone source You are planning to run the following command to create a remote clone in the primary database (boston) using pdbi in orcl:
Which are the THREE prerequisites for automating instantiation of the PDB in the standby database (london)?

NO.75 The Oracle database 19c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1
2) Disable Fast-Start Failover
3) Update the broker configuration with the new observer hostname
4) Enable Fast-Start Failover
5) Start the Observer on host2
Which contains the minimum required steps to move the observer to host2?

NO.76 Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not available using DGMGRL or by using SQL?

NO.77 Which TWO statements are true about configuring Oracle Net Service in a Data Guard environment?

NO.78 Which four requirements can be met by deploying a logical standby database?