Oracle 1Z0-068 Dumps 2021

NEW QUESTION 1
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. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.
• B. The source PDB must use a global temporary tablespace.
• C. The source PDB must be in READ ONLY mode on all CDB instances.
• D. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set.
• E. All running CDB instances must be open in restricted mode.
• F. The source PDB must be closed on the CDB instance from where the command is executed.

Answer: ACD

NEW QUESTION 2
Which three statements are true concerning the behavior of an Oracle Clusterware 12c Flex Cluster in response to hub or leaf node failures? (Choose three.)

• A. Leaf nodes evicted from a Flex Cluster always require a reboot.
• B. Hug node eviction results in the reboot of all leaf nodes that were connected to the evicted hub node.
• C. Hub nodes evicted from a Flex Cluster always require a reboot.
• D. Hub node eviction results in the eviction of all leaf nodes that were connected to the evicted hub node.
• E. Cluster Resources on a leaf node that is evicted from a Flex Cluster are relocated, if possible, to another leaf node that is connected to same hub node to which the failed leaf node was connected.
• F. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to a leaf node that was connected to the evicted hub node.
• G. Cluster Resources on a hub node that is evicted from a Flex Cluster are always relocated to another hub node in the cluster.

Answer: BEG

NEW QUESTION 3
Examine this command:
SQL> ALTER TABLESPACE TBS1 ADD DATAFILE '+DATA(newtemplate)/ORCL/USERS/mytab.dbf' SIZE 100M;
Which two statements are required for this command to succeed? (Choose two.)

• A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
• B. newtemplate must be defined for the +DATA disk group.
• C. Existing data les in TBS1 must also use the same template.
• D. The +DATA disk group should not be part of Flex ASM.
• E. User-defined subdirectories ORCL and USERS must already exist.

Answer: CD

NEW QUESTION 4
Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.)

• A. an operating system version
• B. a version of Oracle database server used in Real Application Cluster (RAC) databases
• C. software required to configure nodes at startup
• D. the GPnP software
• E. a file system version used for the software to be installed
• F. a version of Automatic Storage Management (ASM) used for the cluster

Answer: BDF

NEW QUESTION 5
Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c? (Choose two.)

• A. the Grid Naming Service (GNS) VIP
• B. public IP addresses
• C. High Available VIP (HAIP) addresses
• D. Single Client Access Name (SCAN) VIPs
• E. Storage Network IP addresses

Answer: AD

Explanation: A: To convert a cluster that is not running GNS to a GNS server cluster, run the following command as root, providing a valid IP address and a domain:
# srvctl add gns -vip IP_address -domain domain D: Example:

NEW QUESTION 6
Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create –p snap001 Snap002 /u01/app/grid/ acfsmount/
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.

Answer: C

NEW QUESTION 7
Which three statements are true about the services created when the DBCA is used to create a RAC database?

• A. They can be policy managed for a multitenant database.
• B. Singleton services are not permitted for multitenant databases.
• C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service.
• D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
• E. They can be administrator managed for a multitenant database.

Answer: BCE

Explanation: C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.

NEW QUESTION 8
Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?

• A. It creates the grid user if not already defined.
• B. It modifies the /etc/sysctl.conf Linux file.
• C. It installs kernel modules required for the ASM Cluster File System (ACFS).
• D. It installs the OpenSSH client package.
• E. It creates the oinstall group if not already defined.

Answer: BE

Explanation: When installed, the Oracle Preinstallation RPM does the following:
Note: The Oracle RPMs for your Oracle Linux distributions and Oracle RDBMS releases automatically install any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database, and configure your server operating system automatically, including setting kernel parameters and other basic operating system requirements for installation.
References: https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7493

NEW QUESTION 9
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.
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 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPS.
Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)

• A. Use srvctl stop vip to stop the VIP on host01.
• B. Use oifcfg setif to stop the VIP on host01.
• C. Use srvctl start vip to start the VIP on host01.
• D. Use srvctl modify nodeapps to change the VIP on host01.
• E. Use oifcfg setif to start the VIP on host01.

Answer: ACD

NEW QUESTION 10
Which three components are integral parts of High Availability NFS (HANFS)?

• A. Application VIP
• B. DHCP
• C. ExportFS
• D. HAVIP
• E. NFS
• F. HAIP

Answer: CDE

Explanation: CD: In addition to ACFS/ADVM and ASM, HANFS also relies on new Oracle 12.1 Clusterware (CRS) resources, namely the HAVIP and the ExportFS.
DE: High Availability Network File Storage (NFS) for Oracle Grid Infrastructure provides uninterrupted service of NFS V2/V3/V4 exported paths by exposing NFS exports on Highly Available Virtual IPs (HAVIP) and using Oracle Clusterware agents to ensure that the HAVIPs and NFS exports are always online.
References:
https://docs.oracle.com/database/121/OSTMG/GUID-4D7A5911-8FA6-47DC-98BB-593B2C90D43E.htm#OST
http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/2011281.pdf

NEW QUESTION 11
After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.
Which command, or sequence of commands, should you use?

• A. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2srvctl add db–db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron
• B. srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
• C. srvctl add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server 016n1, 016n2
• D. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2srvctl add db–db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2

Answer: C

Explanation: If your Oracle RAC One Node database did not register automatically with Oracle Clusterware, then use the srvctl add database command to add an Oracle RAC One Node database to your cluster.
For example:
srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]
When you add services to a policy-managed Oracle RAC One Node database, SRVCTL does not accept any placement information, but instead configures those services using the value of the SERVER_POOLS attribute.
Note: Use the srvctl add database command to add an Oracle RAC One Node database to your cluster. For example:
srvctl add database -c RACONENODE [-e server_list] [-i instance_name] [-w timeout]
* -c {RACONENODE | RAC | SINGLE}
The type of database you are adding: Oracle RAC One Node, Oracle RAC, or single instance. References:

NEW QUESTION 12
You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster? Which two elements are required to support this configuration? (Choose two.)

• A. a Grid Management Repository database
• B. a network interface for ASM and private interconnect traffic
• C. a network interface for private interconnect only
• D. a network interface for the public network
• E. a Grid Management Cluster Health Management (CHM) application server

Answer: AC

NEW QUESTION 13
Which three statements are true about opatch version 12?

• A. It can apply patches to a database ORACLE_HOME.
• B. It can apply a patchset to a database ORACLE_HOME.
• C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
• D. It cannot run with root privileges on a Unix-like system.
• E. It can apply some patches without shutting down database instances.
• F. It can only apply patches on the cluster node from where it is issued.

Answer: ABE

NEW QUESTION 14
Which three types of patches and upgrades are supported for Oracle Grid Infrastructure 12c? (Choose three.)

• A. in-place upgrades using the Oracle Universal Installer
• B. out-of-place patching for patch bundles
• C. in-place patching for patch bundles
• D. out-of-place upgrades using the Oracle Universal Installer
• E. in-place patching for one-off patches
• F. in-place patching for patch sets

Answer: BDE

NEW QUESTION 15
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 app. Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 service AR –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service AR
Which two statements are true regarding the AR service?

• A. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each ofthe CDB1 instances.
• B. AR is available on any one available CDB1 instance in prod_pool at any one time.
• C. AR can fail over to any one of the available CDB1 instances.
• D. AR is available only on the CDB1 instance on HOST01.
• E. AR can fail over to any other available CDB1 instance in prod_pool.

Answer: CD

NEW QUESTION 16
Which three statements are true about Oracle Flex ASM? (Choose three.)

• A. It always requires a Flex cluster.
• B. Only three ASM instances are supported in Flex ASM.
• C. The SPFILE and password file for ASM are stored by default an ASM disk group.
• D. An ASM instance can run on a leaf node.
• E. A designated network is used for communication between ASM instances and theirclients.
• F. ASM clients can fail over to other ASM instances.

Answer: CEF

NEW QUESTION 17
You administer an Oracle 12c RAC database whose clients connect to the database instances using SCAN listeners.
Which two statements are true regarding client-side connect-time load balancing? (Choose two.)

• A. You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listenercross-registration.
• B. Client connection requests are automatically load balanced across the IP addresses defined for the SCAN listeners.
• C. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used.
• D. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node.
• E. SCAN listeners redirect connection requests to a node listener for the appropriate instance.

Answer: BE

NEW QUESTION 18
PROD1, PROD2 and PROD3 are three active instances of the PROD database. Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid=’*’;
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid=’PROD1’;
Which statement is true?

• A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.
• B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.
• C. The second statement returns an error because this parameter must be identical for all instances.
• D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

Answer: D

Explanation: First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for PROD1.