1z1-078試験無料問題集（79題）「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration 認定」

出題：1

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. Load balancing of connection requests for ERP across all database instances running on servers in the prod pool

C. High availability for the ERP service

D. High availability for the CRM service

E. Load balancing of connection requests for CRM across all database instances running on servers in the prod pool

F. Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners

G. Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners

正解：C,D,E,F 解答を投票する

出題：2

Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)

A. ACFS auditing information is replicated from the primary file system to the standby file system.

B. The privilege sysrepl has been introduced for ACFS replication.

C. Replication is automatically terminated if the primary file system has less than 2 GB free space.

D. Standby redo log files are required on the standby site for synchronous redo transport.

E. One site of an ACFS replication configuration can host both primary and standby file systems.

正解：A,B,E 解答を投票する

出題：3

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. alter sequence seal cache 10000;

C. alter sequence seql noorder;

D. exec sys.dbms shared pool.keep('SEQ1','Q'>

E. alter sequence seql keep;

正解：B,C 解答を投票する

出題：4

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. Add the DATAFILE '+DATA/CURRENT YR/sales.dbf clause to the command.

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

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

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

E. Add the autoextend on clause to the command.

正解：A,B 解答を投票する

出題：5

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. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

B. Transparent Application Failover (TAF)

C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)

D. Fast Connection Failover (FCF)

正解：D 解答を投票する

出題：6

Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c? (Choose two.)

A. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage

B. an O/S group to own the software inventory

C. an O/S user to own the Grid Infrastructure installation

D. an O/S user to own the Clusterware installation and a different O/S user own the Automatic Storage Management (ASM) installation

E. an 0/S user to own the Oracle Database installation

F. an O/S group called dba

正解：B,C 解答を投票する

出題：7

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, Oracle Grid Infrastructure OS system software, kernel modules and system commands including ACFS, AFD, OLFS, and OKA are not updated.

D. When using Zero Downtime Patching, the root.sh script must be executed manually with -nodriver update option.

E. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script.

正解：B,C,D 解答を投票する

出題：8

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

A. There can be only one node listener per node.

B. They listen only for database instances on the same node.

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

D. They run from the Grid Infrastructure home by default.

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

正解：C,D 解答を投票する

1z1-078試験無料問題集「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration 認定」