最新の[2026年01月14日]Oracle 1z1-076試験練習テスト最高成績で最速合格をゲットせよ！
これを使えば必ず合格させる問題集でOracle 1z1-076
Oracle 1z1-076 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
質問 # 33
Which three actions are performed by the START PLAN procedure of the DBMS ROLLING package?
- A. creating a guaranteed restore point on the standby databases
- B. building a LogMiner dictionary on the primary database instance
- C. converting the designated physical standby database into a logical standby database
- D. starting media recovery on all the Leading Group Standby databases
- E. creating a guaranteed restore point on the primary database
- F. switching the primary database to the logical standby role
正解：A、B、E
解説：
The DBMS_ROLLING package facilitates a rolling upgrade process across a Data Guard configuration. The START PLAN procedure in particular handles several critical actions, including:
Creating a guaranteed restore point on the standby databases (B): This ensures that the standby databases can be reverted to their state before the rolling upgrade process in case of any issues.
Building a LogMiner dictionary on the primary database instance (C): This is necessary for logical standby databases to interpret redo data during the SQL Apply process.
Creating a guaranteed restore point on the primary database (D): Similar to the standby databases, this ensures that the primary database can be reverted to a known good state if necessary.
Reference:
Oracle Database PL/SQL Packages and Types Reference
Oracle Data Guard Concepts and Administration Guide
質問 # 34
Which four factors can influence the rate of SQL apply on a logical standby database?
- A. the size of the shared pool
- B. the number of applier processes
- C. the number of PREPAER processes
- D. the size of the undo tablespace on the logical standby database
- E. the number of coordinator processes on the standby database instance
- F. the number of full table scans performed by SQL apply
正解：B、C、E、F
解説：
The rate of SQL apply on a logical standby database can be influenced by:
A: The number of PREPARER processes (which seems to be a typographical error and should read as PREPARER or similar) which prepare the redo data for the applier processes.
B: The number of coordinator processes on the standby database instance which coordinate the SQL apply activities.
C: The number of full table scans performed by SQL apply since full table scans can be resource-intensive and slow down the apply rate.
E: The number of applier processes which apply the redo data to the logical standby database.
Option D is incorrect as the size of the undo tablespace on the logical standby database is more likely to affect the SQL apply lag rather than the rate of SQL apply.
Option F is incorrect because the size of the shared pool would typically not influence the rate of SQL apply. The shared pool is more related to the caching of shared SQL and PL/SQL code and control structures.
質問 # 35
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?
- A. The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
- B. The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
- C. The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.
- D. The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.
- E. The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.
- F. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.
正解：A、B、E
解説：
The command executed (CREATE CONFIGURATION 'DGConfig' AS PRIMARY DATABASE IS ' PROD' CONNECT IDENTIFIER IS PROD;) is used to create a Data Guard Broker configuration named
'DGConfig'. The successful execution of this command depends on several conditions:
* A: The DG_BROKER_START parameter must be set to TRUE on the primary database to start the Data Guard Broker processes. Without the broker processes running, the configuration cannot be created.
* D: Oracle Net connectivity to the PROD database instance must be established on the primary host. This is because the Data Guard Broker requires network accessibility to communicate with the primary database and manage the configuration.
* E: When the configuration is created, the Data Guard Broker configuration files are indeed automatically created in the locations specified by the DG_BROKER_CONFIG_FILEn parameters on the primary database.
It's important to note that the command will not automatically add the PRODSBY1 standby database to the configuration (thus B and C are not correct), and there is no requirement for the standby database to have Oracle Net connectivity defined on the primary host for the execution of this command (making F incorrect as well).
References: This information can be validated in Oracle's Data Guard Broker documentation, which outlines the requirements for setting up and managing a Data Guard configuration using the Data Guard Broker.
質問 # 36
Which THREE statements are true........ open in real time query mode, which becomes a new.
- A. All sessions are disconnected and all
- B. User sessions can be retained.
- C. Sessions that have long running queries can be retained.
- D. All current buffers can be retained.
- E. User sessions and Current Buffers are maintained by default.
- F. Sessions that are using database links
正解：A、B、D
解説：
When a physical standby database is opened in real-time query mode, which may be referred to as real-time apply when using Active Data Guard, certain operations can disrupt ongoing sessions. However, with features like Application Continuity and the proper configuration of initialization parameters such as STANDBY_DB_PRESERVE_STATES, user sessions and current buffers may be preserved during role transitions such as a switchover or failover. Specifically, the STANDBY_DB_PRESERVE_STATES parameter can be set to preserve none, all, or only user sessions during such transitions. This ensures that in-flight transactions are not lost and that users do not experience disruptions during the role transitions of a physical standby database.
Reference
Oracle Data Guard Concepts and Administration
Oracle Database Licensing Information User Manual
Oracle Data Guard Broker User Manual
質問 # 37
Which THREE statements are true........ open in real time query mode, which becomes a new.
- A. All sessions are disconnected and all
- B. User sessions can be retained.
- C. Sessions that have long running queries can be retained.
- D. All current buffers can be retained.
- E. User sessions and Current Buffers are maintained by default.
- F. Sessions that are using database links
正解：A、B、D
解説：
When a physical standby database is opened in real-time query mode, which may be referred to as real-time apply when using Active Data Guard, certain operations can disrupt ongoing sessions. However, with features like Application Continuity and the proper configuration of initialization parameters such as STANDBY_DB_PRESERVE_STATES, user sessions and current buffers may be preserved during role transitions such as a switchover or failover. Specifically, the STANDBY_DB_PRESERVE_STATES parameter can be set to preserve none, all, or only user sessions during such transitions. This ensures that in-flight transactions are not lost and that users do not experience disruptions during the role transitions of a physical standby database.
References
* Oracle Data Guard Concepts and Administration
* Oracle Database Licensing Information User Manual
* Oracle Data Guard Broker User Manual
質問 # 38
Examine this query and its output:
Which two statements are true?
- A. Cats is a bystander database.
- B. The master observer is not connected to the database on which the query was executed.
- C. The master observer is not running, but should run on ol7.example.com.
- D. The master observer is connected to the database on which the query was executed.
- E. The master observer is currently running on ol7.example.com.
正解：A、B
解説：
D: The database role indicated by FS_FAILOVER_STATUS as BYSTANDER implies that the database is a standby database in the Data Guard configuration. This means the database is neither a primary database nor an active failover target.
E: Since the FS_FAILOVER_OBSERVER_HOST column shows cats, it suggests that this is the host on which the observer would run. However, because the FS_FAILOVER_OBSERVER_PRESENT column is not shown, we cannot definitively state if the observer is currently connected or not. If FS_FAILOVER_OBSERVER_PRESENT is 'YES', the observer is connected, if 'NO', then it's not. In the absence of this column's output, the best assumption based on the available data is that the observer is not connected.
The output shows that the FS_FAILOVER_STATUS is BYSTANDER, which indicates that the database in question is not actively involved in a fast-start failover configuration as a primary or standby. It is in a bystander role, meaning that while it is part of a Data Guard configuration, it is neither a target for failover nor actively participating in failover operations. Additionally, FS_FAILOVER_OBSERVER_HOST shows
'cats', which indicates the host where the observer process is expected to run. However, since there is no information about the observer being present, we can infer that although 'cats' is designated for the observer to run, the observer is not currently connected to this database.
ReferencesOracle documentation on Data Guard configurations and the V$DATABASE view which provides information about the fast-start failover status and observer host.
質問 # 39
You are planning to perform block comparison using the dbms comp package:
Which TWO statements are true?
- A. You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS.
- B. Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.
- C. It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys.
- D. The databases should be at least mounted before block comparison.
- E. It requires that the DB_LOST_WKITE_protect initialization parameter be enabled.
正解：A、D
解説：
The DBMS_COMPARISON package, used for comparing and converging data objects within a single database or between databases, requires that the databases involved in the block comparison be at least mounted (A). This allows the procedure to access the data blocks for comparison. Additionally, the progress of long-running operations such as block comparison can be monitored using the dynamic performance view V$SESSION_LONGOPS (D), which provides information on the operation's progress and estimated completion time.
References:Oracle Database PL/SQL Packages and Types Reference provides comprehensive details on the DBMS_COMPARISON package, including its procedures and how to monitor their progress. Additionally, Oracle Database Reference explains the V$SESSION_LONGOPS view, which is commonly used for monitoring long operations in the database.
質問 # 40
Which three are prerequisites for using Data Guard Broker?
- A. DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.
- B. If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.
- C. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.
- D. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.
- E. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.
- F. The primary and standby databases must run the same version of the Oracle Database server.
正解：B、D、F
解説：
Data Guard Broker is a management tool that simplifies the configuration, management, and monitoring of Data Guard environments. The prerequisites for using Data Guard Broker include:
* The primary and standby databases must run the same version of the Oracle Database server (A):
This ensures compatibility between the primary and standby databases and enables seamless role transitions and data synchronization.
* Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances (B): Proper network connectivity is essential for communication between the primary and standby databases, allowing for the replication of data and the synchronization of changes.
* If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration (D): In Real Application Clusters (RAC) environments, shared storage ensures that all instances of the RAC database can access the broker configuration files, facilitating the management of the Data Guard environment across all instances.References:
* Oracle Data Guard Broker documentation
* Oracle Real Application Clusters Administration and Deployment Guide
質問 # 41
Which TWO statements are true about database parameters for databases in a Data Guard environment?
- A. DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.
- 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. If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.
- E. LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.
正解：B、C
質問 # 42
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances?
- A. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
- B. The LOCAL_LISTENER parameter on the primary database instance must always be set.
- C. A service name is registered with the local listener of each database instance.
- D. The standby database services must be defined statically with the Listeners running on the standby database hosts.
- E. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
- F. Client TNS entries for the databases use the correct service names for the intended service.
- G. The client applications must use the correct TNS entries when requesting connections to the database instances.
正解：D、F、G
解説：
Based on Oracle Database 19c: Data Guard Administration documents, the three measures that can prevent clients from connecting to the wrong database instances during switchovers, failovers, or regular operations in a Data Guard environment are:
B . The standby database services must be defined statically with the Listeners running on the standby database hosts.
D . The client applications must use the correct TNS entries when requesting connections to the database instances.
E . Client TNS entries for the databases use the correct service names for the intended service.
In an Oracle Data Guard configuration, correctly configuring Oracle Net Services (including TNS entries and listeners) is crucial for ensuring that clients connect to the appropriate database instance, whether it's the primary or standby. Defining services on the standby database and associating them with listeners ensures that client applications can connect to the standby when needed, especially useful in a role transition or when the standby is open for read-only access or real-time query. It's essential that TNS entries used by client applications specify the correct service names that correspond to the intended database roles, such as primary or standby. This setup facilitates seamless connectivity to the appropriate instance based on the role, especially critical during switchovers and failovers when the roles of the databases change.
Reference:
Oracle's Data Guard concepts and administration guide provides extensive information on configuring network services for Data Guard environments, ensuring that applications connect to the correct database instance based on the current role of the databases in the Data Guard configuration.
質問 # 43
Which four requirements can be met by deploying a logical standby database?
- A. Support for workloads requiring additional indexes.
- B. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
- C. It can be used to create additional tables.
- D. It must have the same physical structure as the primary database.
- E. It can be used to create additional schemas.
- F. Support for workloads requiring additional materialized views.
- G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.
正解：A、C、F、G
解説：
A logical standby database is part of Oracle Data Guard and allows the standby database to be open for read-write operations, providing additional flexibility. The requirements met by a logical standby database include:
* Support for workloads requiring additional materialized views (A): Logical standby databases can support materialized views, allowing for complex data summarization and reporting workloads.
* It can be used to create additional tables (C): Unlike physical standby databases, logical standby databases allow for the creation of additional tables that do not exist in the primary database, enabling custom workloads and reporting.
* It can be used for Real Application Testing without affecting the disaster recovery capabilities (E):
Logical standby databases can be used to test application changes, patches, and upgrades while still maintaining their role as part of the disaster recovery strategy.
* Support for workloads requiring additional indexes (F): Logical standby databases allow for the creation of additional indexes to optimize query performance for reporting and analytical workloads.
References:
* Oracle Data Guard Concepts and Administration
* Oracle Database High Availability Overview
質問 # 44
Which two statements are true regarding Data Guard environments in an Oracle Muti-tenant architecture?
- A. PDB_FILE_NAME CONVERT must be set to enable creation of standby databases if they are created on the same host as the primary.
- B. The Data Guard broker may be used for multi-tenant databases.
- C. Different redo transport methods can be configured for different pluggable databases within one Data Guard environment.
- D. A Data Guard environment with a multi-tenant primary database can operate in any Protection mode.
- E. Standby redo log files are required for each pluggable database that is protected with Data Guard.
正解：B、D
解説：
Oracle Multi-tenant architecture and Data Guard have several interactions, but specific aspects hold true in such environments:
* The Data Guard broker may be used for multi-tenant databases (B): Data Guard Broker simplifies the management and monitoring of Data Guard configurations and is fully compatible with the Oracle Multi-tenant architecture, allowing for easy management of Data Guard configurations that include multi-tenant container databases (CDBs) and their pluggable databases (PDBs).
* A Data Guard environment with a multi-tenant primary database can operate in any Protection mode (E): Data Guard can be configured to operate in Maximum Performance, Maximum Availability, or Maximum Protection mode, regardless of whether the primary database is a multi-tenant database.
This flexibility ensures that Data Guard can meet various data protection and availability requirements in multi-tenant environments.References:
* Oracle Data Guard Broker documentation
* Oracle Multitenant Administrator's Guide
質問 # 45
Which THREE statements are TRUE about Global Sequences when connected to a physical standby database with Real-Time Query enabled?
- A. They must have the NOORDEK and CACHE options set.
- B. Their usage will always have a performance impact on the primary database.
- C. Their creation requires that a LOG archive_dest_n parameter be defined in the standby that points back to the primary.
- D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small.
- E. If the CACHE option is set then the size of the cache must be at least 100.
正解：A、B、D
解説：
Global Sequences are Oracle sequences that generate unique values across multiple instances in an Oracle RAC or a Data Guard configuration. Regarding their behavior and performance when connected to a physical standby database with Real-Time Query enabled:
A: The usage of Global Sequences can indeed have a performance impact on the primary database due to the need to generate unique values that are consistent across both primary and standby databases.
D: The performance impact on the physical standby database may occur if the CACHE size is too small. This is because the standby database will frequently have to access the primary database to replenish the cache, which can increase the load and potentially lead to performance degradation.
E: Global Sequences should have the NOORDER and CACHE options set. The NOORDER option ensures that sequence numbers are provided without guaranteeing sequence order, thus improving scalability and performance. The CACHE option is used to specify how many sequence values will be held in memory for faster access.
Option B is incorrect as the LOG_ARCHIVE_DEST_n parameter's definition for standbys pointing back to the primary does not directly pertain to the creation of sequences.
Option C is incorrect because there is no requirement that the size of the cache for a sequence must be at least 100. The CACHE size can be set to a different number based on specific use cases or performance considerations.
質問 # 46
Which three statements are true....... With no Oracle Streams or Goldengate configured?
- A. The LGWR process writes to them on ....
- B. They are required only for synchronous redo transport
- C. They are required on a physical standby for real-time apply.
- D. Only standby databases can write redo....
- E. It is recommended to have them on the...
- F. They are required on a logical standby for real-time apply
正解：A、C、F
解説：
C . The LGWR (Log Writer) process is responsible for writing redo entries from the redo log buffer to the online redo log files on the primary database. This is a fundamental process in the Oracle Database architecture, ensuring that all changes made to the database are captured for purposes such as recovery, replication, and high availability.
D . Real-time apply on a logical standby database requires standby redo log files. The standby redo log files are used to store redo data received from the primary database before it is applied to the logical standby database. This enables the logical standby to apply changes as they are received, without waiting for the current redo log file to be archived.
E . Similarly, on a physical standby database, standby redo log files are used for real-time apply. They store redo data from the primary database, allowing the physical standby to apply redo data concurrently as it is received, rather than waiting for redo log files to be archived. This capability is crucial for maintaining a physical standby database that is closely synchronized with the primary database with minimal lag.
These functionalities are integral to Oracle Data Guard configurations and are not dependent on Oracle Streams or Oracle GoldenGate, which are separate technologies for data replication and integration.
質問 # 47
Which THREE statements are true about snapshot standby databases?
- A. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled.
- B. A snapshot standby database may be opened read-only.
- C. A snapshot standby database can have Real-Time apply enabled.
- D. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.
- E. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled.
- F. A snapshot standby database may be opened read-write.
正解：A、E、F
解説：
Snapshot standby databases are a feature of Oracle Data Guard that allows a physical standby database to be temporarily converted into a read-write database for testing or other purposes. The true statements about snapshot standby databases are:
* FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled (B): When a physical standby is converted to a snapshot standby, FLASHBACK DATABASE is automatically enabled to allow the database to be easily reverted back to its original state.
* FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled (C): As part of the conversion process, FLASHBACK DATABASE is turned on to ensure that changes made while the database is in snapshot standby mode can be undone.
* A snapshot standby database may be opened read-write (E): Once a physical standby is converted to a snapshot standby, it can be opened for read-write operations, allowing for testing and other tasks that require a writable database.
References:
* Oracle Data Guard Concepts and Administration
* Oracle Database Backup and Recovery User's Guide
質問 # 48
You are using Data Guard in conjunction with Global Database Services.
You have a Data Guard Broker configuration called Sales and a GDS pool called Prod.
Which three are true concerning the management of the broker configuration when using GDS?
- A. DGMGRL may be used to add the Sales configuration to the Prod pool in gds.
- B. Adding a database to the Sales configuration with DGMGRL requires that the Sales configuration be disabled first. It must then be enabled after the new database is added to the configuration.
- C. Adding a database to the Sales configuration with DGMGRL automatically adds the database to the Prod Pool.
- D. Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services.
- E. DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool.
正解：A、D、E
解説：
In the context of Oracle Data Guard and Global Database Services (GDS):
DGMGRL may be used to add the Sales configuration to the Prod pool in gds (A): Data Guard Broker's command-line interface DGMGRL can be utilized to manage configurations with GDS, allowing the addition of Data Guard Broker configurations to GDS pools.
Performing a role change with DGMGRL automatically notifies GDS which in turn activates the appropriate services (B): When a role change is executed using DGMGRL, GDS is automatically notified, and it then activates the services that are appropriate for the new database roles.
DGMGRL may be used to add a single database to the Sales configuration even if Sales is a member of the Prod pool (C): DGMGRL provides the capability to manage individual databases within a broker configuration, including adding databases to a configuration that is already part of a GDS pool.
Reference:
Oracle Data Guard Broker documentation
Oracle Global Data Services documentation
質問 # 49
Which TWO statements are true about Real-Time Query?
- A. A standby database enabled for Real-Time Query cannot be the Fast-Start Failover target of the Data Guard configuration.
- B. Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby databases opened read only.
- C. Real-Time Query has no limitations regarding the protection level of the Data Guard environment.
- D. Real-Time Query sessions can be connected to a Far Sync instance.
- E. Setting standby_max_data_delay=0 requires synchronous redo transport.
正解：B、E
解説：
Real-Time Query is a feature that allows queries to be run on a physical standby database while it is applying redo data. The relevant truths about it are:
Setting standby_max_data_delay=0 requires synchronous redo transport (A): For the real-time apply feature to function with no data delay (zero delay), synchronous redo transport must be used. This setting ensures that the data on the standby database is as current as possible before queries are executed against it.
Disabling Real-Time Query prevents the automatic start of redo apply when a physical standby database is opened read-only (C): If Real-Time Query is disabled, opening the standby database in read-only mode will not start the redo apply process automatically. Redo apply needs to be manually started to synchronize the standby database with the primary.
Reference:
Oracle Data Guard Concepts and Administration Guide
質問 # 50
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?
- A. The value set using this command is directly stored in the broker configuration file.
- B. The EDIT DATABASE PARAMETER command can be used to set the value of a static parameter in a database.
- C. The value set using this command is directly applied to the boston database.
- D. The database must be available when the above command is run.
- E. The edit database parameter command can only be used to modify the value of a dynamic parameter in a database.
正解：C、D、E
解説：
The EDIT DATABASE...SET PARAMETER command in Data Guard Management (DGMGRL) is used to modify the value of initialization parameters for a database within a Data Guard configuration. This command can be used to modify both static and dynamic parameters, but if a static parameter is changed, the new value will take effect only after the database is restarted. The database must be up and running for the command to execute, and the values set using the command are directly applied to the specified database (in this case, 'boston') .
質問 # 51
Which four requirements can be met by deploying a logical standby database?
- A. Support for workloads requiring additional indexes.
- B. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
- C. It can be used to create additional tables.
- D. It must have the same physical structure as the primary database.
- E. It can be used to create additional schemas.
- F. Support for workloads requiring additional materialized views.
- G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.
正解：A、C、F、G
解説：
A logical standby database is part of Oracle Data Guard and allows the standby database to be open for read-write operations, providing additional flexibility. The requirements met by a logical standby database include:
Support for workloads requiring additional materialized views (A): Logical standby databases can support materialized views, allowing for complex data summarization and reporting workloads.
It can be used to create additional tables (C): Unlike physical standby databases, logical standby databases allow for the creation of additional tables that do not exist in the primary database, enabling custom workloads and reporting.
It can be used for Real Application Testing without affecting the disaster recovery capabilities (E): Logical standby databases can be used to test application changes, patches, and upgrades while still maintaining their role as part of the disaster recovery strategy.
Support for workloads requiring additional indexes (F): Logical standby databases allow for the creation of additional indexes to optimize query performance for reporting and analytical workloads.
Reference:
Oracle Data Guard Concepts and Administration
Oracle Database High Availability Overview
質問 # 52
......
正真正銘のベスト問題集資料を使おう1z1-076オンライン練習試験：https://www.goshiken.com/Oracle/1z1-076-mondaishu.html
最大一年間毎日更新される1z1-076ブレーン問題集：https://drive.google.com/open?id=1jgYE7o_cmsYDqMofHOjGW9KNqJGJtHlI