Test 1z0-078
Question 1:Which three statements are true about the administration and use of policy sets in Oracle 19c Clusterware? (Choose three.)
A.
All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
B.
Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
C.
A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.
D.
A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
E.
Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used.
Question 2:
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 and Database administrators or cluster administrators do not need to make any configuration changes for this feature.
B.
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.
C.
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.
D.
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.
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.
Question 3:
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
A.
The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).
B.
The diagcollection.pl script must be run from the Grid home directory as the grid infrastructure owner.
C.
There is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
D.
The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM ) repository.
E.
There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
Question 4:
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
A.
A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
B.
An ACFS snapshot can be ACFS encrypted.
C.
acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
D.
acfsutil encr on can be used to specify the encryption key length for a directory or file.
E.
acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
Question 5:
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 CDB1 instances.
B.
AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.
C.
AR can fail over to any other available CDB1 instance in prod_pool.
D.
AR is available only on the CDB1 instance on HOST01.
E.
AR is available on any one available CDB1 instance in prod_pool at any one time.
Question 6:
Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c? (Choose four.)
A.
The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.
B.
The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.
C.
The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.
D.
The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.
E.
The upgrade must be done in-place.
F.
Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.
G.
The upgrade must be done out-of-place.
Question 7:
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.
High availability for the CRM service
B.
Load balancing of connection requests across all six database instances
C.
High availability for the ERP service
D.
Load balancing of client connection requests for CRM across four Single Client Access Name (SCAN) listeners
E.
Load balancing of connection requests for ERP across all database instances running on servers in the prod pool
F.
Load balancing of client connection requests for ERP across three Single Client Access Name (SCAN) listeners
G.
Load balancing of connection requests for CRM across all database instances running on servers in the prod pool
Question 8:
Which three statements are true about the Global Resource Directory (GRD) in Oracle 19c RAC database and in Clustered ASM? (Choose three.)
A.
Only one GRD shadow resource may exist for an Enqueue Resource.
B.
Shadow GRD resources may exist in more than one database instance for a resource.
C.
Clustered ASM has GRD resources distributed among all ASM instances.
D.
All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
E.
All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
F.
RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
G.
RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
Question 9:
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
A.
Replication is automatically terminated if the primary file system has less than 2 GB free space.
B.
ACFS auditing information is replicated from the primary file system to the standby file system.
C.
Standby redo log files are required on the standby site for synchronous redo transport.
D.
The privilege SYSREPL has been introduced for ACFS replication.
E.
One site of an ACFS replication configuration can host both primary and standby file systems.
Question 10:
A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM.
The COMPATIBLE.ASM, COMPATIBLE.RDBMS, and COMPATIBLE.ADVM parameters are currently set to 11.2 for all diskgroups.
You must support these capabilities in all diskgroups:
1. ACFS Replication
2. ACFS Encryption
To what minimum values must the compatible attributes be set?
A.
Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
B.
Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
C.
Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
D.
Set COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
E.
Set COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
Question 11:
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.
2, 3, 4 and 6.
C.
1, 2, 3 and 4.
D.
2, 3, 4, 5 and 6.
E.
1, 2, 3, 4 and 6.
F.
1, 2, 3, 4, 5, 6 and 7.
Question 12:
Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)
A.
2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
B.
2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
C.
3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
D.
3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
E.
3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
Question 13:
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
A.
The disk group compatibility attribute for ADVM must be set to 12.1 or higher.
B.
The parent snapshot must be read-only.
C.
The underlying ADVM volume must be configured with high redundancy.
D.
The parent snapshot must be read/write.
Question 14:
Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?
A.
They can be applied in-place.
B.
When performing rolling patches, the VIPs for the node being patched are relocated to another node.
C.
Some Grid Infrastructure patchsets may not be intalled in a rolling fashion.
D.
When performing rolling patches, crsctl query crs softwareversion always displays the earliest version of the software running anywhere in the cluster.
Question 15:
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
A.
acfsutil audit read marks audit files to indicate that it is safe to purge them.
B.
acfsutil audit init must be run by a system administrator.
C.
acfsutil audit purge can be run by an audit manager.
D.
Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
E.
acfsutil audit archive must be used to archive audit files that are larger than 10 MB.
Question 16:
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
A.
Oracle RAC affinity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings of the partition tables.
B.
Oracle RAC affinity for partitioned tables routes database requests to Oracle RAC instances in such a way that each instance always gets requests for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locality and reduced internode synchronization and block pings.
C.
Oracle RAC affinity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention.
D.
To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.
E.
To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single instance in the cluster to improve cache locality and reduce internode synchronization and block pings.
Question 17:
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.
A database instance on a node can be a client of an ASM instance running on any node.
C.
A database instance on a node cannot be a client of an ASM instance running on other nodes.
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 diskgoups.
F.
An ASM instance and database instances can coexist on the same node.
Question 18:
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 stopped on all nodes.
B.
The Oracle Clusterware stack is prevented from being automatically started on HOST01.
C.
The Oracle Clusterware stack is prevented from being automatically started on all nodes.
D.
The Oracle Clusterware stack is stopped on all nodes except HOST01.
E.
The Oracle Clusterware stack is started on all nodes except HOST01.
F.
The Oracle Clusterware stack is started on all nodes.
Question 19:
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
A.
One UNDO tablespace for each PDB is required.
B.
PDBs can have local temporary tablespaces.
C.
You can open one, several, or all PDBs on one, several, or all CDB instances.
D.
It requires the CDB to use shared UNDO management.
E.
One UNDO tablespace for each instance is required.
F.
PDBs must use shared Temporary tablespace.
Question 20:
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
A.
SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
B.
Grid Infrastructure must be installed on all cluster nodes.
C.
The Clusterware stack must be up on all cluster nodes.
D.
The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
E.
SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
F.
Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
Question 21:
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 LMD0 process if only one instance is running.
F.
In a RAC One Node database, there is no LMD0 process if only one instance is running.
Question 22:
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.
The source PDB must be closed on the CDB instance from where the command is executed.
B.
The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode.
C.
The source PDB must use a global temporary tablespace.
D.
It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
E.
Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
F.
All running CDB instances must be open in restricted mode.
Question 23:
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
A.
Database block buffers
B.
Mutexes
C.
Redo log buffers
D.
Latches
E.
Enqueues
F.
Cursors
Disclaimer:
The content on this webpage is collected from various internet sources. While we strive for accuracy, we cannot guarantee its completeness or correctness. Please use it with caution and conduct further research if needed. We do not claim ownership or copyright over any content. If you find any copyrighted material or content that violates laws, please contact us for removal. By accessing this webpage, you agree to these terms. Thank you for your understanding.
The content on this webpage is collected from various internet sources. While we strive for accuracy, we cannot guarantee its completeness or correctness. Please use it with caution and conduct further research if needed. We do not claim ownership or copyright over any content. If you find any copyrighted material or content that violates laws, please contact us for removal. By accessing this webpage, you agree to these terms. Thank you for your understanding.