Free 1Z0-068 Exam Dumps

Question 26

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

Correct Answer:C
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:

Question 27

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.

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

Question 28

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.

Correct Answer:ACE
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.

Question 29

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM
$ srvctl stop service –db CDB1 –service CRM Which three statements are true?

A. CRM is only available for new logins on the CDB1 instance on host01.
B. CRM is available for new logins on one CDB1 instance.
C. The srvctl start service command automatically opens PDB_1 if not already opened.
D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
E. The CRM service is not available for new logins on any instance of CDB1.

Correct Answer:CDE

Question 30

You must replace a failed disk that was dropped from a disk group.
You want the rebalance operation to occur with minimal performance impact.
Which two options exist to achieve this? (Choose two.)

A. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.
B. Increase the value of the DISK_REPAIR_TIME attribute for the disk group.
C. Use the WAIT clause with the ALTER DISKGROUP command.
D. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.
E. Set the POWER clause to 1 in the ALTER DISKGROUP command.

Correct Answer:AB