最新的Oracle 1z1-078免費考試真題

問題1

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. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.

C. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.

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 for use by the voting disks and OCR file.

正確答案: D,E

問題2

Examine this command:

Which two statements are true about this disk group, created using Grid Infrastructure 19c? (Choose two.)

A. It can contain ASM Dynamic Volume Manager (ADVM) volumes.

B. The ASM compatible attributes can be changed to 12. l for this disk group.

C. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.

D. Any database instance with the COMPATIBLE parameter set to 12.2 or later can access it.

E. Files created in this disk group always have two copies for each allocation unit: one primary and one secondary.

正確答案: A,D

問題3

You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?

A. 2, 3, 4 and 6.

B. 1, 2, 3 and 4.

C. 1, 2, 3, 4, 5, 6 and 7.

D. 1, 2, 3, 4 and 6.

E. 1, 2, 3, 4, 5 and 6.

F. 2, 3, 4, 5 and 6.

正確答案: B

問題4

Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)

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

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

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

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

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

正確答案: B,C

問題5

Which three statements are true about an Oracle Database RAC software installation? (Choose three.)

A. The software must be installed into a local file system on each node.

B. The software can be installed into an ACFS file system.

C. The software must be installed on all nodes in the cluster.

D. The software must be installed into a cluster file system.

E. SSH user equivalence for the Oracle user can be set up before the software installation.

F. RAC installations require Oracle Enterprise Edition.

G. Fix-up scripts generated during the installation must be run as root on UNIX platforms.

正確答案: E,F,G

問題6

Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

A. One undo tablespace for each instance is required.

B. You can open one, several, or all PD3s on one, several, or all cdb instances.

C. PDBs must use shared Temporary

D. One undo tablespace for each pdb is required.

E. It requires the cdb to use shared undo management.

F. PDBs can have local temporary

正確答案: B,E,F

問題7

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)

A. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

B. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

C. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

D. The upgrade must be done out-of-place.

E. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

F. The upgrade must be done in-place.

G. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

正確答案: B,C,E,G

問題8

Examine this sequence of commands:

The cluster consists of nodes HOST01, HOST02, HOST03 and HOST04, and the clusterware is running on all four nodes.
Which three statements are true about the result of the root user running these commands on HOST01? (Choose three.)

A. The Oracle Clusterware stack is stopped on all nodes except host01.

B. The Oracle Clusterware stack is prevented from being automatically started on all nodes.

C. The Oracle Clusterware stack is started on all nodes except host01.

D. The Oracle Clusterware stack is stopped on all nodes.

E. The Oracle Clusterware stack is prevented from being automatically started on host01.

F. The Oracle Clusterware stack is started on all nodes.

正確答案: D,E,F

最新的Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration - 1z1-078免費考試真題

聯系我們

站內鏈接

最新更新