PassTest 1z1-078問題集でリアル試験問題でテストエンジン問題集でトレーニング
Oracle 1z1-078テスト問題集とオンライン試験エンジン
Oracle 1z1-078 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
質問 # 20
Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture? (Choose three.)
- A. Each leaf node must be connected to storage shared across all leaf nodes.
- B. Each hub node must be connected to storage shared across all hub nodes.
- C. Leaf nodes require direct access to the voting disks.
- D. Each leaf node must be connected to storage shared across all cluster nodes.
- E. Hub nodes require direct access to the voting disks.
- F. Hub nodes require direct access to the OCR file.
正解：B、E、F
質問 # 21
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
- A. An ACFS snapshot can be ACFS encrypted.
- B. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
- C. acfsucil encr on can be used to specify the encryption key length for a directory or file.
- D. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
- E. acfsutil encr inic is used to establish role separation between encryption managers and encryption auditors.
正解：A、C、E
質問 # 22
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
- A. PDBs can have local temporary
- B. One undo tablespace for each instance is required.
- C. PDBs must use shared Temporary
- D. You can open one, several, or all PD3s on one, several, or all cdb instances.
- E. It requires the cdb to use shared undo management.
- F. One undo tablespace for each pdb is required.
正解：A、D、E
質問 # 23
Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances? (Choose three.)
- A. Services support the balancing of client connections across RAC database instances.
- B. Client-side connect-time load balancing can balance connection requests across SCAN listeners.
- C. Load balancing can be done by the client, the listener, or both, for any one connection request.
- D. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance.
- E. Load balancing can be done by the client or the listener, but not both, for any one connection request.
正解：A、C、D
質問 # 24
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 downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
- D. An xcur image is not shipped 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
質問 # 25
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
- A. The underlying advm volume must be configured with high redundancy.
- B. The disk group compatibility attribute for advm must be set to 12. l or higher.
- C. The parent snapshot must be read/write.
- D. The parent snapshot must be read-only.
正解：D
質問 # 26
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 pdb must use a global temporary
- D. The source PD3 must be closed on the CDS instance from where the command is executed.
- E. All running CDB instances must be open in restricted mode.
- F. The source PD3 must be in read only mode on all CD3 instances if the CDB is in No Archive mode.
正解：A、B、D
質問 # 27
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
- A. acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
- B. acfsutil audit init must be run by a system administrator.
- C. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
- D. acfsutil audit read marks audit files to indicate that it is safe to purge them.
- E. acfsutil audit purge can be run by an audit manager.
正解：B、C、E
質問 # 28
Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware? (Choose two.)
- A. Set the environment variable _USR_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
- B. Use the cluvfy comp command for the specific resource within a component.
- C. Use the crsct1 set log res "resource_name=debugging_level2" command.
- D. Use the crsct1 set trace res "resource_name=debugging_level" command.
正解：A、D
質問 # 29
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 started on all nodes.
- B. The Oracle Clusterware stack is prevented from being automatically started on all nodes.
- C. The Oracle Clusterware stack is stopped on all nodes.
- D. The Oracle Clusterware stack is prevented from being automatically started on host01.
- E. The Oracle Clusterware stack is started on all nodes except host01.
- F. The Oracle Clusterware stack is stopped on all nodes except host01.
正解：A、C、D
質問 # 30
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 and shuts down the ASM instance on HOST03.
- B. It fails because the ASM instance has not been shut down first on HOST03.
- C. It fails because an ASM instance is not configured to run on HOST02.
- D. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
- E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
- F. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
正解：C、E、F
質問 # 31
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- B. The OCRCONFIG utility can be used to repair a corrupt OCR file 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 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.
- E. The CLUVFY utility can check the integrity of the OCR but not the OLR.
正解：A、C、D
質問 # 32
Which two statements are true about Transparent Application Continuity in Oracle RAC 19c? (Choose two.)
- A. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.
- B. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes.
- C. Recovery of the user database session is done safely by enabling auto recover within the user database session.
- D. Transparent Application Continuity is enabled when failover type=auto.
- E. Transparent Application Continuity is enabled when failover type=All
正解：B、D
質問 # 33
Which statement describes the purpose of colocation_tag for client routing with Oracle database 19c?
- A. When possible, clients with the same colocation_tag are routed to the same available instance even if a preferred instance is available.
- B. When possible, clients with the same colocation_tag are routed to the same instance that offers a given service.
- C. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a specific load balancing option.
- D. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available.
正解：B
質問 # 34
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. Load balancing of connection requests across all six database instances
- B. High availability for the ERP service
- C. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
- D. High availability for the CRM service
- E. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
- F. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
- G. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
正解：B、C、D、E
質問 # 35
Which three statements are true about an Oracle Database RAC software installation? (Choose three.)
- A. SSH user equivalence for the Oracle user can be set up before the software installation.
- B. Fix-up scripts generated during the installation must be run as root on UNIX platforms.
- C. The software must be installed into a local file system on each node.
- D. The software can be installed into an ACFS file system.
- E. RAC installations require Oracle Enterprise Edition.
- F. The software must be installed into a cluster file system.
- G. The software must be installed on all nodes in the cluster.
正解：A、B、E
質問 # 36
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.)
- A. alter sequence seql order;
- B. exec sys.dbms shared pool.keep('SEQ1','Q'>
- C. alter sequence seal cache 10000;
- D. alter sequence seql keep;
- E. alter sequence seql noorder;
正解：C、E
質問 # 37
Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPs.
Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)
- A. Use oifcfg setif to start the VIP on host01.
- B. Use oifcfg setif to stop the VIP on host01.
- C. Use srvctl modify nodeapps to change the VIP on host01.
- D. Use srvctl start vip to start the VIP on host01.
- E. Use srvctl stop vip to stop the VIP on host01.
正解：B、C、E
質問 # 38
Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)
- A. It can analyze performance using data captured on all instances.
- B. It can analyze performance over any given time period.
- C. It can only analyze performance on the instance running the ADDM job.
- D. It can diagnose skew in response time.
- E. It runs automatically in Instance ADDM mode after each AWR snapshot is created.
- F. It can diagnose latency problems in the Cluster Interconnect.
正解：A、B、D
質問 # 39
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
- A. ASM Cluster File System (ACFS) can be deployed on any nodes.
- B. An ASM instance and database instances can coexist on the same node.
- C. A database instance on a node can be a client of an ASM instance running on any node.
- D. A database instance on a node can only be a client of an ASM instance running on the same node.
- E. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups.
- F. A database instance on a node cannot be a client of an ASM instance running on other nodes.
正解：B、C、E
質問 # 40
Which three statements are true about diagnostic reporting for the OCR and OLR files? (Choose three.)
- A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
- B. The OCRCHECK utility can check the OLR 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 CLUVFY utility can check the integrity of the OCR but not the OLR.
- E. The OCRCONFIG utilty can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
正解：A、B、C
質問 # 41
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. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
- B. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
- C. Fast Connection Failover (FCF)
- D. Transparent Application Failover (TAF)
正解：C
質問 # 42
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 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.
- B. 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.
- C. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.
- D. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.
- E. 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.
正解：B、C、E
質問 # 43
Which three statements are true about Quality of Service Management (QoS)? (Choose three.)
- A. It can manage database services only if they are defined as UNIFORM services.
- B. Databases managed by QoS can be administrator managed or policy managed.
- C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
- D. It supports multiple databases assigned to the same server pool.
- E. A server pool can be managed by QoS even if it does have database instances running on any server in the pool.
正解：B、C、D
質問 # 44
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.)
- A. Create the current yr directory in the +data disk group.
- B. lAdd the DATAFILE '/CURRENT YR/sales.dbf clause to the command.
- C. Add the autoextend on clause to the command.
- D. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.
- E. Create the current yr directory in the root directory (+).
正解：A、D
質問 # 45
......
Oracle 1z1-078問題を提供していますOracle Database問題集と完璧な解答付き：https://www.passtest.jp/Oracle/1z1-078-shiken.html
信頼され続ける1z1-078試験のコツとPDF試験材料：https://drive.google.com/open?id=1PWBUnf74VFK2SXwLnCgMGGrx7M_UOovy