Online Access Free 1z1-068 Practice Test

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

Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

• A.They are contained in a directory on the same volume as their parent file system.
• B.They are always point-in-time copies of the parent file system.
• C.All ACFS snapshot operations for all filesystem are serialized clusterwide.
• D.They can only be accessed when the file system is mounted.
• E.They can be administered using ASMCMD.
• F.You can create a snapshot from an existing snapshot.

Which three statements are true about Server Categorization in Oracle 12c Clusterware?

• A.Different Hub nodes in a flex cluster may belong to separate administrator-defined categories.
• B.All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
• C.A server may be added to only one category using the crsctl utility.
• D.All server attributes used for categorization are administrator modifiable.
• E.All hub nodes in a flex cluster belong to the same Oracle-supplied category.
• F.All leaf nodes in a flex cluster belong to the same Oracle-supplied category.

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

• A.Use the cluvfy comp command for the specific resource within a component.
• B.Use the crsctl set trace res "resource_name=debugging_level" command.
• C.Set the environment variable _USA_ORA_DEBUG=1 and then stop and restart the resource that requires resource debugging data to be collected.
• D.Use the crsctl set log res "resource_name=debugging_level2" command.

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 start vip to start the VIP on host01.
• B.Use oifcfg setif to stop the VIP on host01.
• C.Use srvctl modify nodeapps to change the VIP on host01.
• D.Use oifcfg setif to start the VIP on host01.
• E.Use srvctl stop vip to stop the VIP on host01.