ベストOracle 1z1-078学習ガイドと問題集は2024年更新 [Q47-Q65]

Share

ベストOracle 1z1-078学習ガイドと問題集は2024年更新

トップクラスOracle 1z1-078試験最先端学習ガイド!練習問題バージョン


Oracle 1z1-078 認定試験の出題範囲:

トピック出題範囲
トピック 1
  • 利用可能なパッチとアップグレードの種類の説明
  • Oracle Clusterware の高可用性コンポーネントの説明
トピック 2
  • サーバー側の接続時の負荷分散を構成する
  • DBCA を使用して単一インスタンスのデータベースを RAC One Node データベースに変換する
トピック 3
  • RAC 環境および非 RAC 環境におけるマルチテナント アーキテクチャについて説明する
  • RAC での自動データベース診断モニター (ADDM) の使用
トピック 4
  • オプションのグリッド・インフラストラクチャ管理リポジトリのインストール
  • Oracle Universal Installer (OUI)ユーティリティを使用したパッチセットのインストール
トピック 5
  • グローバル エンキューとインスタンス ロック管理の説明
  • 高速アプリケーション通知 (FAN) の利点の説明
トピック 6
  • グローバル リソース競合を軽減するためのアフィニティの使用について説明する
  • RAC 環境で UNDO テーブルスペースを定義する
トピック 7
  • V$ASM動的パフォーマンス・ビューを使用して、Flex ASM
  • Monitor ASMインスタンスのアーキテクチャとコンポーネントを説明します
トピック 8
  • ASM ディスク グループで継続的なメンテナンス タスクを実行する
  • ASM ファイル、ディレクトリ、エイリアスがどのように作成および管理されるかを説明する
トピック 9
  • RAC 環境での Oracle データベース ソフトウェアのインストール
  • 初期化パラメータの変更

 

質問 # 47
Which two statements are true about load balancing using a database service in a RAC environment? (Choose two.)

  • A. Server-side load balancing connections are always distributed across instances based on the fastest response time for the service.
  • B. Client-side connect time load balancing works only if it uses a tnsnames entry specifying load BALANCE=yes.
  • C. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.
  • D. 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.
  • E. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service.

正解:C、E


質問 # 48
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 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.
  • B. 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.
  • 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. 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. 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.

正解:D


質問 # 49
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 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.
  • 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 can be fully automated by selecting the option to automatically run the root.sh script.
  • D. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
  • E. 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.

正解:A、B、D


質問 # 50
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.)

  • A. The ACFS file system will be permanently removed from the volume.
  • B. The disabling of volume does not destroy data in the file system.
  • C. The volume can be enabled and the file system can be mounted back again to access the existing data.
  • D. The ACFS mount registry with Oracle restart is automatically deleted.
  • E. The ACFS file system will be permanently removed from the volume only if the file system is empty.

正解:B、C


質問 # 51
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC? (Choose two.)

  • A. An xcur block image may exist for a specific database block in only one instance.
  • B. A CR image may get served from one instance to another to satisfy a read request.
  • C. An xcur image is not shipped to another instance until commits occur for updated rows on the block.
  • D. An xcur image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
  • E. A Pi block image may exist for a specific database block in only one instance.

正解:A、B


質問 # 52
Examine this command and output:

Examine this command:

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

  • A. The parent snapshot must be read/write.
  • B. The parent snapshot must be read-only.
  • C. The disk group compatibility attribute for advm must be set to 12. l or higher.
  • D. The underlying advm volume must be configured with high redundancy.

正解:B


質問 # 53
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. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
  • C. acfsucil encr on can be used to specify the encryption key length for a directory or file.
  • D. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
  • E. An ACFS snapshot can be ACFS encrypted.

正解:A、C、E


質問 # 54
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)

  • A. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
  • B. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
  • C. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
  • D. Configure network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
  • E. If network time protocol (NJP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

正解:D、E


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

  • A. Grid Infrastructure must be installed on all cluster nodes.
  • B. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
  • C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
  • D. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
  • E. The Clusterware stack must be up on all cluster nodes.
  • F. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.

正解:A、C


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

  • A. You can open one, several, or all PD3s on one, several, or all cdb instances.
  • B. PDBs must use shared Temporary
  • C. One undo tablespace for each instance is required.
  • 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

正解:A、E、F


質問 # 57
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. a script agent
  • B. A Server Pool
  • C. a resource dependency definition
  • D. an application resource
  • E. an application VIP

正解:A、D


質問 # 58
You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1,PDB_2, and PDB_3.
Server pool prod_pool has a cardinality of three and all six hosts of the cluster are up.
Examine these commands executed on HOST01:

Which two statements are true regarding the AR service? (Choose two.)

  • A. AR can fail over to any other available CDBl instance in prod pool.
  • B. AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.
  • C. AR is available only on the CDBl instance on host01.
  • D. AR is available on any one available CDBl instance in prod pool at any one time.
  • E. AR can fail over to any one of the available CD31 instances.

正解:A、D


質問 # 59
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

  • A. The CLUVFY utility can check the integrity of the OCR but not the OLR.
  • B. The OCRCHECK utility can check the OLRWhich two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability? (Choose two.) in an online fashion with the clusterware running on all nodes.
  • C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
  • D. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
  • E. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.

正解:B、D、E


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

  • A. Specifying the use of Grid Naming Service is optional.
  • B. The Clusterware binaries may be installed without installing ASM binaries.
  • C. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of
  • D. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.
  • E. The Grid Infrastructure Management Repository is only required when using ASM.

正解:A、C


質問 # 61
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

  • A. In a RAC database, there is no LMDO process if only one instance is running.
  • B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
  • C. Global Enqueues may have owners and waiters in the same instance.
  • D. Global Enqueues and Instance Locks replace latches completely in RAC database instances.
  • E. In a RAC One Node database, there is no LMD) process if only one instance is running.
  • F. Global Enqueues may have converters and waiters in the same instance.

正解:A、C


質問 # 62
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

  • A. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
  • B. All ASM Disks belonging to a disk group should be of the same size for optimal performance.
  • C. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
  • D. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
  • E. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.

正解:B、E


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

  • A. The upgrade must be done in-place.
  • B. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
  • C. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
  • D. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
  • E. The oracle SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
  • F. The oracle home environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
  • G. The upgrade must be done out-of-place.

正解:B、C、D、F


質問 # 64
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)

  • A. The CLUVFY utility can check the integrity of the OCR but not the OLR.
  • B. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
  • C. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
  • D. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
  • E. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

正解:B、C、E


質問 # 65
......

有効な1z1-078試験最新問題で2024年最新の学習ガイド:https://www.passtest.jp/Oracle/1z1-078-shiken.html

1z1-078認定で究極のガイド:https://drive.google.com/open?id=1pa7HymzTSmM2FYGqcB-3dE9nZ_npPnfr