1z0-078無料問題集「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration」

質問 1

You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?

（A）1, 2, 3, 4, 5 and 6.

（B）1, 2, 3, 4 and 6.

（C）2, 3, 4 and 6.

（D）1, 2, 3 and 4.

（E）1, 2, 3, 4, 5, 6 and 7.

（F）2, 3, 4, 5 and 6.

正解：D 解答を投票する

質問 2

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）All running CDB instances must be open in restricted mode.

（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）It can be executed only by a common user with the create pluggable database system privilege connected to the root container.

正解：A、D、F 解答を投票する

質問 3

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

（A）HANFS provides high availability in case of cluster node failure.

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

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

（D）HANFS' performance depends on the characteristics of the underlying ASM disks.

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

正解：A、D 解答を投票する

質問 4

Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC? (Choose three.)

（A）It runs automatically in Instance ADDM mode after each AWR snapshot is created.

（B）It can analyze performance over any given time period.

（C）It can analyze performance using data captured on all instances.

（D）It can diagnose skew in response time.

（E）It can only analyze performance on the instance running the ADDM job.

（F）It can diagnose latency problems in the Cluster Interconnect.

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

質問 5

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

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

（B）Singleton services are not permitted for multitenant databases.

（C）They can be policy managed for a multitenant database.

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

（E）They can be administrator managed for a multitenant database.

正解：A、C、E 解答を投票する

質問 6

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

（A）Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.

（B）Global Enqueues may have converters and waiters in the same instance.

（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 database, there is no LMDO process if only one instance is running.

（F）In a RAC One Node database, there is no LMD) process if only one instance is running.

正解：C、E 解答を投票する

質問 7

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 one of the available CD31 instances.

（B）AR can fail over to any other available CDBl instance in prod pool.

（C）AR is available on any one available CDBl instance in prod pool at any one time.

（D）AR runs as a singleton service in the server pool prod pool and the AR service is available in each of the CDBl instances.

（E）AR is available only on the CDBl instance on host01.

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

質問 8

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

（B）alter sequence seql keep;

（C）alter sequence seql order;

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

（E）alter sequence seql noorder;

正解：A、E 解答を投票する

1z0-078 無料問題集「Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration」

弊社を連絡する

関連リンク

トップ試験