1z0-078別格な問題集をダウンロードして無料で最新の(1z0-078テスト問題集をゲット2024年06月27日)
1z0-078問題集は合格保証します合格できる1z0-078試験問題2024年更新
質問 # 38
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
- A. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
- B. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
- C. Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
- D. Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
- E. Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
正解:A、D
質問 # 39
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
- A. Update the path environment variable on each cluster node to point to the 50RACLE HOME/OPacch directory
- B. Stage the patch on all cluster nodes.
- C. Stage the patch on the cluster node where the OPacch utility will be executed.
- D. Update the path environment variable on the node where you will run the OPatch utility to point to the SORacle HOME/OPacch directory.
正解:B
質問 # 40
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)
- A. It cannot be used to automate the opening of the PDB by the Clusterware.
- B. It is not automatically registered in the OCR.
- C. It is uniformly available on all instances for administrator-managed databases.
- D. It is automatically registered in the OCR.
- E. It is created and started on only one instance when using policy-managed database configuration.
正解:D
質問 # 41
Examine the output of the asmcmd and srvctl commands:
Then you execute this command:
$ srvctl relocate asm -currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown? (Choose three.)
- A. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
- C. It fails because the ASM instance has not been shut down first on HOST03.
- D. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
- E. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- F. It fails because an ASM instance is not configured to run on HOST02.
正解:A、D、F
質問 # 42
Which three statements are true about fully qualified file names in ASM? (Choose three.)
- A. They can be created only if OMF is enabled.
- B. They are the only valid form that can be used for single file creation of a control file.
- C. An alias may be created for an existing file by referring to the fully qualified file name.
- D. They are system Generated at the time of ASM file creation.
- E. They can be used to reference existing ASM files.
正解:D、E
質問 # 43
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
- A. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
- B. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
- C. Shadow GRD resources may exist in more than one database instance for a resource.
- D. Only one GRD shadow resource may exist for an Enqueue Resource.
- E. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
- F. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
- G. Clustered ASM has GRD resources distributed among all ASM instances.
正解:C、F、G
質問 # 44
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. Databases managed by QoS can be administrator managed or policy managed.
- B. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
- C. It supports multiple databases assigned to the same server pool.
- D. It can manage database services only if they are defined as UNIFORM services.
- E. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
正解:A、C、E
質問 # 45
A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible.
Which feature will support this requirement?
- A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- B. Fast Connection Failover (FCF)
- C. Transparent Application Failover (TAF)
- D. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
正解:B
質問 # 46
Examine the output of this command:
The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
- A. It fails to resize the filesystem because it must be unmounted before resizing.
- B. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
- C. It resizes voli.
- D. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
- E. It succeeds but leaves the file system unmounted.
正解:C、D
質問 # 47
Examine this command executed on the first node of a four-node cluster:
$ < DATABASE_ORACLE_HOME >/OPatch/opatch apply 33575673
What does this command do?
- A. It applies a patch to all database oracle homes with the same release on all cluster nodes.
- B. It applies a patch to all database oracle homes with the same release only on the first cluster node.
- C. It applies a patch to one oracle home only on the first cluster node.
- D. It applies a patch to all oracle homes with the same release only on the first cluster node.
- E. It applies a patch to one database ORACLE home on alll cluster nodes.
正解:C
質問 # 48
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)
- A. crsctl disable crs
- B. crsctl config crs
- C. crsctl stop crs
- D. crsctl stop cluster
正解:A、C
質問 # 49
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)
- A. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
- B. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service.
- C. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
- D. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
- E. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.
正解:D、E
質問 # 50
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. 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.
- B. 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.
- C. 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.
- D. 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.
- 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.
正解:E
質問 # 51
Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19c? (Choose two.)
- A. ASM disk groups used for voting files and OCR files require a quorum failqroup.
- B. The Installer permits the creation of a disk group for use by the voting disks and OCR file.
- C. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
- D. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
- E. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
正解:B、D
質問 # 52
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
- A. There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- B. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.
- C. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor
- D. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
- E. The diagcolleccion.pl script must be run from the Grid home directory as the arid infrastructure owner.
正解:B、E
質問 # 53
Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 92c Clusterware? (Choose two.)
- A. an application VIP
- B. A Server Pool
- C. a resource dependency definition
- D. an application resource
- E. a script agent
正解:D、E
質問 # 54
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
- A. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
- B. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
- C. The upgrade must be done out-of-place.
- D. The upgrade must be done in-place.
- E. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
- F. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
- G. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
正解:A、B、F、G
質問 # 55
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)
- A. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
- B. The Clusterware binaries may be installed without installing ASM binaries.
- C. Specifying the use of Grid Naming Service is optional.
- D. The Grid Infrastructure Management Repository is only required when using ASM.
- E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
正解:A、C
質問 # 56
Which two statements are true about server categorization in Oracle 19c Clusterware? (Choose two.)
- A. Server categories can only be used for nodes running an application server.
- B. A server may be added to only one category using the crsctl utility.
- C. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
- D. All nodes in a cluster belong to the same Oracle-supplied category.
- E. All server attributes used for categorization are administrator modifiable.
- F. Different nodes in a cluster may belong to separate administrator-defined categories.
正解:B、F
質問 # 57
......
Oracle 1z0-078 認定試験の出題範囲:
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
検証済みの1z0-078問題集で問題と解答で合格保証試験問題集テストエンジン:https://jp.fast2test.com/1z0-078-premium-file.html