[2024年07月]に更新されたOracle Database 1z1-078試験練習テスト問題集豪華セット！
2024年最新のに更新された1z1-078のPDFは1z1-078本日更新のテスト無料最新！
Oracle 1z1-078 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
質問 # 38
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
- A. They can be applied in-place.
- B. When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
- C. When performing rolling patches, the vips for the node being patched are relocated to another node.
- D. Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
正解：D
質問 # 39
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
- A. Mutexes
- B. Latches
- C. Enqueues
- D. Database block buffers
- E. Redo log buffers
- F. Cursors
正解：A、B、C
質問 # 40
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
- A. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
- B. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
- C. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
- D. Their names can be seen in dice when connected to an ASM instance.
- E. They exist in both ASM and RDBMS instances, and display the same output.
正解：A、C
質問 # 41
Examine this command:
SQL> CREATE PLUGGABLE DATABASE pdb3 FROM pdb1;
Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.)
- A. Oracle Managed Files must be enabled or PD3 file name convert must be set.
- B. It can be executed only by a common user with the create pluggable database system privilege connected to the root container.
- C. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
- D. The source PD3 must be closed on the CDS instance from where the command is executed.
- E. The source pdb must use a global temporary
- F. All running CDB instances must be open in restricted mode.
正解：A、B、D
質問 # 42
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)
- A. An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- B. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
- C. An xcur block image may exist for a specific database block in only one instance.
- D. A CR image may get served from one instance to another to satisfy a read request.
- E. A Pi block image may exist for a specific database block in only one instance.
正解：C、D
質問 # 43
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)
- A. Sessions connected to the failed node could be relocated to one or more surviving nodes.
- B. Cluster resources running on the failed node must be recovered when the node is restarted.
- C. The node is evicted from the cluster
- D. Cluster Resources running on the failed node are suspended until the node is restarted.
- E. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.
正解：A、C、E
質問 # 44
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)
- A. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
- B. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
- C. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
- D. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
- E. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
正解：B、D
質問 # 45
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
質問 # 46
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?
- A. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
- B. Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.
- C. To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".
- D. Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
正解：B
解説：
Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance. This is true because Dynamic Service Fallback is a new feature in Oracle RAC 19c that enables a dynamic database service to automatically relocate to a preferred instance when it is restored, after the service was failed over to an available instance due to the failure of the last preferred instance. This feature improves the availability and performance of the service by minimizing the manual intervention and the number of failovers. To enable Dynamic Service Fallback, you should specify the -failback option for the service as YES when using SRVCTL or DBCA12. Reference:
1: Oracle Database 19c Release 19.3 New Features, Dynamic Services Fallback Option1
2: Automatic Failback of a Service in a Oracle-19c-RAC-Database2
質問 # 47
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
- A. One site of an ACFS replication configuration can host both primary and standby file systems.
- B. Replication is automatically terminated if the primary file system has less than 2 GB free space.
- C. The privilege sysrepl has been introduced for ACFS replication.
- D. Standby redo log files are required on the standby site for synchronous redo transport.
- E. ACFS auditing information is replicated from the primary file system to the standby file system.
正解：A、C、E
質問 # 48
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
質問 # 49
Examine this command:
Which two statements are required for this command to succeed? (Choose two.)
- A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
- B. newtemplate must be defined for the +DATA disk group.
- C. Existing data files in TBS1 must also use the same template.
- D. The +DATA disk group should not be part of Flex ASM.
- E. User-defined subdirectories ORCL and USERS must already exist.
正解：B、E
質問 # 50
For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)
- A. Local resources
- B. Pluggable Databases (PDBs)
- C. Administrator-defined resources
- D. Cluster resources
- E. Database transactions
正解：A、C、D
質問 # 51
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
- A. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.
- B. When a policy is activated, resources cannot be automatically started to comply with the policy definition.
- C. When a policy is first created, it is initially inactive.
- D. An administrator-defined policy may be activated using the srvctl utility.
- E. When a policy is activated, resources can be automatically stopped to comply with the policy definition.
- F. When a policy is first created, it is initially active.
正解：C、D、E
質問 # 52
Zero Downtime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances.
Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching? (Choose three.)
- A. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
- B. When using Zero Downtime Patching, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.
- C. Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
- D. Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched.
- E. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
正解：B、D、E
質問 # 53
Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
- A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
- B. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
- C. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
- D. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
- E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
正解：A、C、E
質問 # 54
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
質問 # 55
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
質問 # 56
Which three statements are true about accessing ASM files? (Choose three.)
- A. ASM instances can write metadata to ASM diskgroups.
- B. Database instances can write metadata to ASM diskgroups.
- C. Database instances perform read I/O directly to ASM Disks.
- D. If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy
- E. Database instances perform read I/O using an ASM instance as an I/O Server.
正解：A、B、C
質問 # 57
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 ERP service
- B. High availability for the CRM service
- C. Load balancing of connection requests across all six database instances
- D. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- E. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- F. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
- G. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
正解：A、B、D、E
質問 # 58
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
- B. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- D. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- E. An ACFS snapshot can be ACFS encrypted.
正解：A、B、E
質問 # 59
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
質問 # 60
......
全幅的な更新された問題集PDFのテスト1z1-078試験問題とアンサー：https://www.passtest.jp/Oracle/1z1-078-shiken.html
100%無料1z1-078試験問題集を試験簡単にパスせよ：https://drive.google.com/open?id=1PWBUnf74VFK2SXwLnCgMGGrx7M_UOovy