Exam2pass
0 items Sign In or Register
  • Home
  • IT Exams
  • Guarantee
  • FAQs
  • Reviews
  • Contact Us
  • Demo
Exam2pass > Oracle > Oracle Certifications > 1Z0-068 > 1Z0-068 Online Practice Questions and Answers

1Z0-068 Online Practice Questions and Answers

Questions 4

You just added an ASM disk to the DATA diskgroup.

Which two can be used to monitor the rebalancing?

A. ams_cmd lsop

B. v$asm_disk

C. v$asm_operation

D. v$asm_diskgroup

E. v$session_longops

F. amscmd lsdg

Buy Now

Correct Answer: CD

Section: (none)

C: Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query the V$ASM_OPERATION view to

monitor the status of this operation.

D: Verify that the rebalance is waiting:

SQL> select * from v$asm_operation

where group_number = (select GROUP_NUMBER from v$asm_diskgroup where NAME='BDT');

References: https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm

Questions 5

Examine the output of the asmcmd and srvctl commands:

$ asmcmd showclustermode

ASM cluster : Flex mode enabled

$ srvctl status asm 璬etail

ASM is running on host01, host03

ASM is enabled.

$ srvctl config asm

ASM home: /u01/app/12.1.0/grid

Password file: +DATA/orapwASM

ASM listener: LISTENER

ASM instance count: 2

Cluster ASM listener: ASMNET1LSNR_ASM

Then you execute this command:

$ srvctl relocate asm ?currentnode host03 璽argetnode host02

Which three statements are true regarding the execution of this command based on the output shown?

A. It fails because an ASM instance is not configured to run on HOST02.

B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.

C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.

D. It fails because the ASM instance has not been shut down first on HOST03.

E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.

F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.

Buy Now

Correct Answer: CEF

Section: (none)

Questions 6

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.

Buy Now

Correct Answer: BCE

Section: (none)

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. Incorrect Answers:

D: 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. References: https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320

Questions 7

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 璼erverpool ron 璱mportance 100 璵in 2 璵ax 2 璼ervers 016n1, 016n2 srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erverpool ron

B. srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erver 016n1, 016n2

C. srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erverpool ron 璼erver 016n1, 016n2

D. srvctl add srvpool 璼erverpool ron 璱mportance 100 璵in 2 璵ax 2 璼ervers 016n1, 016n2 srvctl add db 璬b ron 璷raclehome $ORACLE_HOME 璬btype raconenode 璼erver 016n1, 016n2

Buy Now

Correct Answer: C

Section: (none)

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.

Reference: https://docs.oracle.com/cd/E11882_01/rac.112/e41960/onenode.htm#RACAD8194

Questions 8

Which three statements are true about ASM Cloud File System (ACFS) tagging?

A. acfssettag is a command provided by a platform-independent API to tag files.

B. acfssettag is a command provided by a platform-dependent API to tag files.

C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.

D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.

E. acfsutil tag set can be used to tag files.

Buy Now

Correct Answer: ACE

Section: (none)

A: The acfssettag command sets the tag name on an Oracle ACFS file.

Syntax

sb8 acfssettag(const oratext *path, const oratext *tagname, oratext *value, size_t size, ub4 flags);

C: Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS Replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having

to replicate an entire Oracle ACFS file system.

E: The acfsutil tag set command adds the given tag to the specified files or directories in an Oracle ACFS file system. Incorrect Answers:

D: The acfsutil encr on command encrypts an Oracle ACFS file system, directories, or individual files. However, you specify a directory not a tag name.

References: https://docs.oracle.com/database/121/OSTMG/GUID-9D88AC84-F3E1-432B-8907- E6D7647E1B0F.htm#OSTMG95633 https://docs.oracle.com/database/121/OSTMG/GUID-5A980C0A-BE5E-4489-8A25- ED9596BF6CA2.htm#OSTMG34700

Questions 9

Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?

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

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

C. an O/S user to own the Oracle Database installation

D. an O/S group called dba

E. a group to own the ASMLIB-provisioned storage

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

Buy Now

Correct Answer: BD

Section: (none)

B: Creating the Oracle Inventory Group If an Oracle Inventory Does Not Exist If the oraInst.loc file does not exist, then create the Oracle Inventory group by entering a command similar to the following: # /usr/sbin/groupadd -g 54321 oinstall

The preceding command creates the oraInventory group oinstall, with the group ID number 54321. Members of the oraInventory group are granted privileges to write to the Oracle central inventory (oraInventory), and other system privileges for Oracle installation owner users.

D: Oracle recommends that you create one software owner to own each Oracle software product (typically, oracle, for the database software owner user, and grid for Oracle Grid Infrastructure).

Incorrect Answers:

A: During an Oracle Grid Infrastructure installation, both Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM) are installed. You no longer can have separate Oracle Clusterware installation owners and Oracle ASM installation owners.

References: https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN179

Questions 10

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 12c?

A. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner's environment.

B. The upgrade must be done in-place.

C. The upgrade must be done out of place.

D. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility.

E. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade.

F. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner's environment.

G. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

Buy Now

Correct Answer: ACEG

Section: (none)

References: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN422

Questions 11

Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs?

A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required.

B. An application VIP is created on the default network by the appvipcfg utility.

C. An application VIP is created on the interconnect network by the crsctl utility.

D. An application VIP can be created with the crsctl utility.

E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

Buy Now

Correct Answer: BD

Section: (none)

B: Oracle 11.2 introduced appvipcfg utility for creating VIPs. From the GRID_HOME/bin directory run the appvipcfg command to create the application VIP. Oracle Clusterware assigns this VIP to a physical server in the cluster and will migrate the VIP to a surviving node in the cluster in the event of a server failure.

Example: appvipcfg create -network=1 -ip=192.168.20.111 -vipname=MyTestVIP -user=grid

D: While you can add a VIP in the same way that you can add any other resource that Oracle Clusterware manages, Oracle recommends using the script Grid_home/bin/appvipcfg to create or delete an application VIP. Incorrect Answers:

E: When a node dies in an Oracle RAC cluster, the Virtual IP (VIP) fails over to a different node. Upon node failure application VIP fails over to a surviving node along with the protected application. It is the Application VIP that is used for accessing the application, thus in case of failure the application will be highly.

References: https://gjilevski.com/2011/11/13/build-ha-for-third-party-application-with-oracle-gi-11-2-0-3/

Questions 12

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)

A. Configure 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.

B. Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.

C. Deactivate 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.

D. If network time protocol (NT P) 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.

E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.

Buy Now

Correct Answer: AE

Section: (none)

Questions 13

Which statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware standard Cluster that uses Grid Naming Service (GNS)?

A. Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.

B. Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.

C. Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.

D. Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.

Buy Now

Correct Answer: A

Section: (none)

Exam Code: 1Z0-068
Exam Name: Oracle Database 12c: RAC and Grid Infrastructure Administration
Last Update: Mar 25, 2025
Questions: 157

PDF (Q&A)

$45.99
ADD TO CART

VCE

$49.99
ADD TO CART

PDF + VCE

$59.99
ADD TO CART

Exam2Pass----The Most Reliable Exam Preparation Assistance

There are tens of thousands of certification exam dumps provided on the internet. And how to choose the most reliable one among them is the first problem one certification candidate should face. Exam2Pass provide a shot cut to pass the exam and get the certification. If you need help on any questions or any Exam2Pass exam PDF and VCE simulators, customer support team is ready to help at any time when required.

Home | Guarantee & Policy |  Privacy & Policy |  Terms & Conditions |  How to buy |  FAQs |  About Us |  Contact Us |  Demo |  Reviews

2025 Copyright @ exam2pass.com All trademarks are the property of their respective vendors. We are not associated with any of them.