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.)
AThe Oracle Clusterware stack is stopped on all nodes.
BThe Oracle Clusterware stack is prevented from being automatically started on HOST01.
CThe Oracle Clusterware stack is prevented from being automatically started on all nodes.
DThe Oracle Clusterware stack is stopped on all nodes except HOST01.
EThe Oracle Clusterware stack is started on all nodes except HOST01.
FThe Oracle Clusterware stack is started on all nodes.
Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database? (Choose three.)
ADatabase block buffers
BMutexes
CRedo log buffers
DLatches
EEnqueues
FCursors
Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware? (Choose two.)
AThe clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM).
BThe diagcollection.pl script must be run from the Grid home directory as the grid infrastructure owner.
CThere is one ologgerd service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
DThe oclumon utility may be used to get and set parameters for the cluster health monitor (CHM ) repository.
EThere is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
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.)
AThe source PDB must be closed on the CDB instance from where the command is executed.
BThe source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive mode.
CThe source PDB must use a global temporary tablespace.
DIt can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
EOracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
FAll running CDB instances must be open in restricted mode.
For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)
ACluster resources
BDatabase transactions
CLocal resources
DAdministrator-defined resources
EPluggable Databases (PDBs)
Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)
AGlobal Enqueues and Instance Locks replace mutexes completely in RAC database instances.
BGlobal Enqueues may have converters and waiters in the same instance.
CGlobal Enqueues may have owners and waiters in the same instance.
DGlobal Enqueues and Instance Locks replace latches completely in RAC database instances.
EIn a RAC database, there is no LMD0 process if only one instance is running.
FIn a RAC One Node database, there is no LMD0 process if only one instance is running.
Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)
AOne UNDO tablespace for each PDB is required.
BPDBs can have local temporary tablespaces.
CYou can open one, several, or all PDBs on one, several, or all CDB instances.
DIt requires the CDB to use shared UNDO management.
EOne UNDO tablespace for each instance is required.
FPDBs must use shared Temporary tablespace.
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
ASSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
BGrid Infrastructure must be installed on all cluster nodes.
CThe Clusterware stack must be up on all cluster nodes.
DThe Clusterware stack must be up on all cluster nodes where the Database software will be installed.
ESSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
FGrid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
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.)
AUse srvctl start vip to start the VIP on host01.
BUse oifcfg setif to start the VIP on host01.
CUse oifcfg setif to stop the VIP on host01.
DUse srvctl modify nodeapps to change the VIP on host01.
EUse srvctl stop vip to stop the VIP on host01.
Which two statements are true regarding the default service that is automatically created upon PDB creation in a RAC database environment? (Choose two.)
AIt is uniformly available on all instances for administrator-managed databases.
BIt cannot be used to automate the opening of the PDB by the Clusterware.
CIt is automatically registered in the OCR.
DIt is created and started on only one instance when using policy-managed database configuration.
EIt is not automatically registered in the OCR.
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c? (Choose two.)
AIf 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.
BConfigure 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.
CIf network time protocol (NTP) 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.
DConfigure 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.
EDeactivate 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.
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.)
AIt fails because the ASM instance has not been shut down first on HOST03.
BIt succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.
CIt succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
DIt succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
EIt succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
FIt fails because an ASM instance is not configured to run on HOST02.
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.)
AAR can fail over to any one of the available CDB1 instances.
BAR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances.
CAR can fail over to any other available CDB1 instance in prod_pool.
DAR is available only on the CDB1 instance on HOST01.
EAR is available on any one available CDB1 instance in prod_pool at any one time.
Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)
AWhen a policy is activated, resources can be automatically stopped to comply with the policy definition.
BAn administrator-defined policy may be activated using the srvctl utility.
CWhen a policy is first created, it is initially inactive.
DWhen a policy is first created, it is initially active.
EWhen a policy is activated, resources cannot be automatically started to comply with the policy definition.
FWhen a policy is activated, nodes may be reassigned to server pools based on the policy definition.
Which two benefits are obtained by using Affinity to reduce global resource contention? (Choose two.)
AOracle 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.
BOracle 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.
COracle 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.
DTo 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.
ETo 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.
Examine this command and output:
Examine this command:
Which statement must be true for the successful execution of the second command?
AThe disk group compatibility attribute for ADVM must be set to 12.1 or higher.
BThe parent snapshot must be read-only.
CThe underlying ADVM volume must be configured with high redundancy.
DThe parent snapshot must be read/write.
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:
ACFS Replication
ACFS Encryption
To what minimum values must the compatible attributes be set?
ASet COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2.
BSet COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
CSet COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1.
DSet COMPATIBLE.ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1.
ESet COMPATIBLE.ASM to 11.2, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.
Examine these descriptions of ASM instance shutdown behavior:
The ASM instance shuts down immediately without an orderly dismount of disk groups.
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.
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.)
A2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
B2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
C3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
D3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
E3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
Which three statements are true about ASM Cloud File System (ACFS) replication? (Choose three.)
AReplication is automatically terminated if the primary file system has less than 2 GB free space.
BACFS auditing information is replicated from the primary file system to the standby file system.
CStandby redo log files are required on the standby site for synchronous redo transport.
DThe privilege SYSREPL has been introduced for ACFS replication.
EOne site of an ACFS replication configuration can host both primary and standby file systems.
Which two statements are true about initialization parameters for Clustered ASM instances? (Choose two.)
AThe maximum value of ASM_POWER_LIMIT is 1024.
BThe default value of INSTANCE_TYPE is ASM.
CA change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
DThe ASM_DISKGOUPS parameter is optional.
EASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.
Which three statements are true regarding ASM on a four-node cluster? (Choose three.)
AASM Cluster File System (ACFS) can be deployed on any nodes.
BA database instance on a node can be a client of an ASM instance running on any node.
CA database instance on a node cannot be a client of an ASM instance running on other nodes.
DA database instance on a node can only be a client of an ASM instance running on the same node.
EA database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgoups.
FAn ASM instance and database instances can coexist on the same node.
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:
Apply a Grid Infrastructure interim patch.
Apply a Grid Infrastructure Patch Set Update (PSU).
Apply a database on-line patch.
Apply a Grid Infrastructure patchset.
Apply a database patchset.
Upgrade Grid Infrastructure from one release to another.
Upgrade databases from one release to another.
Your plan is to perform these tasks:
Install and configure Oracle Grid Infrastructure on a local file system.
Install Oracle Database software on an ACFS file system.
Create several RAC One Node databases.
Which of the seven requirements are met by your plan?
A1, 2, 3, 4, 5 and 6.
B2, 3, 4 and 6.
C1, 2, 3 and 4.
D2, 3, 4, 5 and 6.
E1, 2, 3, 4 and 6.
F1, 2, 3, 4, 5, 6 and 7.
Which three statements are true about ASM Cloud File System (ACFS) auditing? (Choose three.)
Aacfsutil audit read marks audit files to indicate that it is safe to purge them.
Bacfsutil audit init must be run by a system administrator.
Cacfsutil audit purge can be run by an audit manager.
DAudit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
Eacfsutil audit archive must be used to archive audit files that are larger than 10 MB.
Which task must be performed before running the OPatch utility to patch Oracle Grid Infrastructure 19c?
AUpdate the PATH environment variable on each cluster node to point to the $ORACLE_HOME/OPatch directory.
BStage the patch on the cluster node where the OPatch utility will be executed.
CUpdate the PATH environment variable on the node where you will run the OPatch utility to point to the $ORACLE_HOME/OPatch directory.
DStage the patch on all cluster nodes.
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
AA copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
BAn ACFS snapshot can be ACFS encrypted.
Cacfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
Dacfsutil encr on can be used to specify the encryption key length for a directory or file.
Eacfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
Preview
