[2024年更新]1z0-078試験問題集でテストエンジン練習テスト問題 [Q16-Q33]

5/5 - (1 vote)

[2024年更新]1z0-078試験問題集でテストエンジン練習テスト問題

合格できる1z0-078試験[2024年08月14日]最新79問題

質問 16
You performed these steps to disable an ADVM volume containing an ACFS file system:
1. Dismount the file system.
2. Disable the volume with the ASMCMD voldisable command.
Which two statements are true regarding the actions performed? (Choose two.)

The ACFS file system will be permanently removed from the volume.

The ACFS mount registry with Oracle restart is automatically deleted.

The disabling of volume does not destroy data in the file system.

The volume can be enabled and the file system can be mounted back again to access the existing data.

The ACFS file system will be permanently removed from the volume only if the file system is empty.

質問 17
You want to create a tablespace, SALES, with these requirements:
1. Its data file has an alias name sales.dbf.
2. Its data file is stored in the directory CURRENT_YR in the disk group DATA.
Examine this command:
SQL> CREATE TABLESPACE sales;
Which two tasks must you perform to meet these requirements? (Choose two.)

Create the current yr directory in the root directory (+).

Create the current yr directory in the +data disk group.

Add the DATAFILE ‘+DATA/CURRENT YR/sales.dbf clause to the command.

Add the autoextend on clause to the command.

lAdd the DATAFILE ‘/CURRENT YR/sales.dbf clause to the command.

質問 18
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)

ASM Cluster File System (ACFS) can be deployed on any nodes.

A database instance on a node can be a client of an ASM instance running on any node.

A database instance on a node cannot be a client of an ASM instance running on other nodes.

A database instance on a node can only be a client of an ASM instance running on the same node.

A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.

An ASM instance and database instances can coexist on the same node.

質問 19
Examine this command and output:

Examine this command:

Which statement must be true for the successful execution of the second command?

The disk group compatibility attribute for advm must be set to 12. l or higher.

The parent snapshot must be read-only.

The underlying advm volume must be configured with high redundancy.

The parent snapshot must be read/write.

質問 20
Examine this query and output:

Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention? (Choose two.)

exec sys.dbms shared pool.keep(‘SEQ1′,’Q’>

alter sequence seal cache 10000;

alter sequence seql noorder;

alter sequence seql keep;

alter sequence seql order;

質問 21
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)

They listen only for database instances on the same node.

They listen on behalf of any ASM instance and all database instances on the same node.

They listen only for the ASM instance on the same node.

There can be only one node listener per node.

They run from the Grid Infrastructure home by default.

質問 22
Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.

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.

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

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.

質問 23
Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)? (Choose two.)

An ADVM volume is individually named and can contain only one file system.

ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

File systems contained in ADVM volumes may only contain database files.

Only one ADVM volume can be created in an ASM disk group.

To create an ADVM volume, disk group attributes COMPATIBLE.ASM and COMPATIBLE.ADVM must be minimally set to 12.1.<.span>.

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

When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.

When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.

When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.

When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.

質問 25
Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 19.0
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-

The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.

New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

Transactions on database objects stored in tablespaces in the dgrpi disk group fail.

質問 26
Which three events occur when a node fails in an Oracle Clusterware 19c Cluster? (Choose three.)

Cluster resources running on the failed node must be recovered when the node is restarted.

Cluster Resources running on the failed node are relocated to one or more surviving hub nodes.

Cluster Resources running on the failed node are suspended until the node is restarted.

Sessions connected to the failed node could be relocated to one or more surviving nodes.

The node is evicted from the cluster

質問 27
Which three statements are true about the services created when the DBCA is used to create a RAC database? (Choose three.)

A server pool must be created with srvct1 before creating a policy-managed RAC database that uses that server pool for a service.

They can be policy managed for a multitenant database.

Policy-managed services specified for a database allow the creation of a new server pool using dbca.

They can be administrator managed for a multitenant database.

Singleton services are not permitted for multitenant databases.

質問 28
Examine this command:

Which two statements are required for this command to succeed? (Choose two.)

The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).

newtemplate must be defined for the +DATA disk group.

Existing data files in TBS1 must also use the same template.

User-defined subdirectories ORCL and USERS must already exist.

The +DATA disk group should not be part of Flex ASM.

質問 29
Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster? (Choose two.)

The Grid Infrastructure Management Repository is only required when using ASM.

Specifying the use of Grid Naming Service is optional.

Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of

The Clusterware binaries may be installed without installing ASM binaries.

High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

質問 30
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)

ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.

Grid Infrastructure must be installed on all cluster nodes.

The Clusterware stack must be up on all cluster nodes.

The Clusterware stack must be up on all cluster nodes where the Database software will be installed.

SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.

Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

質問 31
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)

Use the crsct1 set trace res “resource_name=debugging_level” command.

Use the crsct1 set log res “resource_name=debugging_level2” command.

Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.

Use the cluvfy comp command for the specific resource within a component.

質問 32
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?

They can be applied in-place.

When performing rolling patches, the vips for the node being patched are relocated to another node.

Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.

When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.

質問 33
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

HANFS provides high availability in case of an NFS client failure.

HANFS’ performance depends on the characteristics of the underlying ASM disks.

HANFS does not depend on NFS services provided by the underlying operating system.

HANFS provides high availability in case of cluster node failure.

NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS