1Z0-068 | Highest Quality Database 12c 1Z0-068 dumps
Q41. Which three statements are true about ASM Cloud File System (ACFS) encryption?
A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
D. acfsutil encr on can be used to specify the encryption key length for a directory or file.
E. An ACFS snapshot can be ACFS encrypted.
Answer: A,D,E
Q42. 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, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron
B. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
C. srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –serverpool ron –server016n1, 016n2
D. srvctl add srvpool –serverpool ron –importance 100 –min 2 –max 2 –servers 016n1, 016n2 srvct1 add db –db ron –oraclehome $ORACLE_HOME –dbtype raconenode –server 016n1, 016n2
Answer: C
54. Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?
A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
C. Use crsctl querry votedisk to view the location of voting files if stored in ASM.
D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
E. Use crsctl querry votedisk to view the location of voting files if stored in a file system.
F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.
Answer: B,E,F
Q43. Which three statements are true about ASM Cloud File System (ACFS) auditing?
A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
C. acfsutil audit init must be run by a system administrator.
D. acfsutil audit purge can be run by an audit manager.
E. acfsutil audit read marks audit files to indicate that it is safe to purge them.
Answer: B,C,D
Q44. Which three statements are true about Global Resource Management in an Oracle 12c RAC database?
A. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.
B. Object remastering causes all blocks in any instances’ buffer cache from the same object to be mastered inthe Global Resource Directory (GRD).
C. When a database instance fails, then some global resource masters lost from the failing instance areremastered among the surviving instances.
D. Lazy remastering instances occurs when an instance shuts with SHUTDOWN TRANSACTIONAL.
E. Global Enqueue resources are recovered after Global Cache Resources after an instance failure.
Answer: A,C,D
Q45. You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.
It runs on an eight-node cluster and a serverpool prod_pool has three servers. Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool
$ srvctl start service –db CDB1 –service HR $ srvctl stop service –db CDB1 –service HR
Which two statements are true?
A. HR is uniformly managed across all instances in prod_pool.
B. srvctl stop service only closes PDB_1 in the instance on HOST01.
C. srvctl stop service closes PDB_1 on all CDB1 instances.
D. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
E. srvctl stop service prevents logins to any isntance of CDB1 using service HR.
F. HR is available on a single instance of prod_pool.
Answer: B,F
Q46. Which method can be used to convert a single-instance Oracle 12c Database to a RAC Database?
A. using DBCA to migrate the database to shared storage and then start one or more RAC databaseinstances on the cluster
B. using DBCA to create a template from the single-instance database and then to create a RAC database onthe cluster using that template
C. using the rconfig utility to create a template from the single-instance database and then using DBCA tocreate a RAC database on the cluster using that template
D. using the rconfig utility to migrate the database to shared storage and then using DBCA to start one ormore RAC database instances on the cluster.
Answer: C
Q47. 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 usesthat 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: A,C,D
Q48. Which two statements are true about v$asm – views in clustered environment?
A. They exist both in ASM and RDBMS instances, and display the same output.
B. Their names can be seen in dict when connected to an ASM instance.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster.
Answer: B,D
Q49. 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: C,D
Q50. Examine this command:
SQl> CREATE DISKROUP RECO HIGH REDUNDANCY:
FAILGROUP fgrpl1 DISK
‘/dev/disk1’ NAME disk1,
‘/dev/disk2’ NAME disk2,
‘/dev/disk3’ NAME disk3,
FAILGROUP fgrpl2 DISK
‘/dev/disk4’ NAME disk4,
‘/dev/disk5’ NAME disk5,
‘/dev/disk6’ NAME disk6,
FAILGROUP fgrpl3 DISK
‘/dev/disk7’ NAME disk7,
‘/dev/disk8’ NAME disk8,
‘/dev/disk9’ NAME disk9,
ATTRIBUTE ‘au_size’=’4M’,
‘compatible.asm’ = ’12.1’,
‘compatible.rdbms’ = ’12.1’,
‘compatible.advm’ = ’12.1’,
‘content_type’ = ‘recovery’;
Which three statements a true about this disk group?
A. File created in it have three copies for each allocation unit.
B. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it.
C. The Compatible attribute values of the disk group can be changed to lower values.
D. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring.
E. The RECO diskgroup may only be used for the FRA.
F. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring.
Answer: B,D,F