1z0-078 試験問題を無料オンラインアクセス

You support a RAC database with these characteristics:
1. There are six instances.
2. Server Pool prod has a maximum of four servers.
3. CRM is a policy managed, uniform service using Server Pool prod.
4. ERP is a policy managed, singleton service using Server Pool prod.
5. Grid infrastructure is installed and running in its default configuration.
Which four benefits are provided by this configuration in Oracle 19c? (Choose four.)

• A.High availability for the CRM service
• B.Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
• C.High availability for the ERP service
• D.Load balancing of connection requests across all six database instances
• E.Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
• F.Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
• G.Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)

• A.All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
• B.A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
• C.A thread of redo must be created before starting a fourth instance if a thread is not already available.
• D.A thread of redo must contain at least two log groups before it can be enabled.
• E.A redo log group added using alter database add logfile without the instance clause is added to each instance.

Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members.
Which statement is true about securing cluster interconnect communication?

• A.Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
• B.Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication.
• C.Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto-generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.
• D.Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c.
• E.Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature.

Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?

• A.When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
• B.When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
• C.When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
• D.When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?

• A.Using the rconfig utility to migrate the database to shared storage and then using dbca to start one or more RAC database instances on the cluster
• B.Using dbca to migrate the database to shared storage and then to start one or more RAC database instances on the cluster
• C.Using dbca to create a template from the single-instance database and then to create a RAC database on the cluster using that template
• D.Using the rconfig utility to create a template from the single-instance database and then using dbca to create a RAC database on the cluster using that template