[Q27-Q47] Jun-2024 Realistic 1z1-076 Accurate & Verified Answers As Experienced in the Actual Test!

QUESTION 27
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?

QUESTION 28
Which three are true concerning database states after a successful switchover?

QUESTION 29
Which two are true about database roles in an Oracle Data Guard configuration?

QUESTION 30
Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?

QUESTION 31
Which three types of backups offload …….. with the primary database in a data Guard

QUESTION 32
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)?

QUESTION 33
Which four requirements can be met by deploying a logical standby database?

QUESTION 34
You are planning to perform block comparison using the dbms comp package:

Which TWO statements are true?

QUESTION 35
Which THREE are true about using flashback database in a Data Guard environment?

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

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

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

QUESTION 39
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN.
You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

QUESTION 40
Examine the Data Guard configuration: DGMGRL> show configuration;
Configuration – Animals
Protection Mode: MaxPerformance
Databases:
dogs- Primary database
sheep – Physical standby database
cats- Snapshot 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.
What can you conclude based on this error?

QUESTION 41
Which three statements are true about snapshot standby databases?

QUESTION 42
On your logical standby database, you specified these rules:

After completion of the weekend batch cycle you attempt to delete the SQL Apply filters:

Which is TRUE regarding the execution of the UNSKIP procedure?

QUESTION 43
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?

QUESTION 44
Examine the Data Guard configuration:

Which three will be true after a successful failover to Cats?

QUESTION 45
Which TWO are TRUE about offloading backups to a physical standby database in a Data Guard environment?

QUESTION 46
Which two statements are true regarding asynchronous redo transport in a Data Guard

QUESTION 47
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.