Free Oracle 1z1-076 Practice Test & Real Exam Questions, Page 4

Question #28

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?

A. Stop redo transport to the logical standby database.

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

C. Change the redo transport mode if necessary to ASYNC.

D. Stop SQL Apply on the logical standby database.

Discussion 0

Correct Answer: D Vote an answer

Question #29

Which TWO statements are true regarding Data Guard Broker?

A. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.

B. It can be used to create and manage standby databases.

C. It can be used to perform failovers and switchovers.

D. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.

E. It can be used to monitor redo transport and log apply services.

Discussion 0

Correct Answer: B,C Vote an answer

Question #30

Your current Data Guard environment consists of:
A primary database containing no abstract data types used for user tables.
Two separate remote physical standby databases used for reporting.
Examine these requirements for adding a new standby database to this Data Guard environment:
The new standby database must provide a disaster recovery solution.
There must be minimal additional performance overheads on the primary database.
The new standby database may require additional indexes and materialized views not present in the primary.
New tables or schemas may be required in the standby database that are not present in the primary.
What would you recommend to fulfill these requirements?

A. A physical standby database with asynchronous redo transport and Real-Time Query enabled.

B. A physical standby database with synchronous redo transport and Real-Time Query enabled.

C. A logical standby database with asynchronous redo transport and SQL apply on.

D. A logical standby database with synchronous redo transport and redo apply on.

E. A logical standby database with synchronous redo transport and SQL apply on.

Discussion 0

Correct Answer: C Vote an answer

Question #31

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?

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

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

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

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

E. The sequence is usable on physt1 and physt2.

Discussion 0

Correct Answer: B,E Vote an answer

Question #32

You must design an Oracle Data Guard configuration for a DSS database that meets these permanent requirements:
1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.
2. Creating and maintaining materialized views should not impact the performance of the primary database.
Additionally, there are these requirements, only one of which is ever done at any one time:
1. It should be possible to apply designated patches with a minimum amount of downtime.
2. Upgrading to a new database release should be performed with the least possible amount of downtime.
3. New application software releases should be tested against an exact and up-to-date replica of the primary database.
Which configuration meets these requirements with the fewest of databases?

A. a primary database with one logical standby database

B. a primary database with one physical standby database

C. a primary database with two physical standby databases

D. A primary database with one logical and one physical standby database

E. a primary database with two logical standby databases

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #33

Your Data Guard environment consists of these components and settings:
1. A primary database
2. A remote physical standby database
3. Real-time query is enabled.
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
You notice that queries executed on the physical standby database receive errors: ORA-03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded. Which two would you recommend to avoid this error?

A. Change the protection mode to Maximum Performance.

B. Reduce I/O latency for the storage used by the primary database.

C. Increase the number of standby redo log files on the primary database.

D. Increase the network bandwidth between the primary and standby databases.

E. Change the protection mode to Maximum Protection.

F. Increase the size of the buffer cache on the standby database instance.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #34

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

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

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

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

D. They can be used to skip CREATE TABLE commands.

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

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

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

Discussion 0

Correct Answer: A,C,D,G Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #35

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

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

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

C. 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.

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

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

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

Discussion 0

Correct Answer: A,D,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #36

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?

A. The redo transport mode is set to async for both standby databases.

B. Cats is a snapshot standby database.

C. The redo transport mode is set to asyn: for the standby database Cats.

D. The redo transport mode is set to async for the standby database Sheep.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Free Oracle 1z1-076 Practice Test & Real Exam Questions

Download Free Oracle 1z1-076 Demo