It is impossible to pass Oracle 1Z0-068 exam without any help in the short term. Come to Ucertify soon and find the most advanced, correct and guaranteed Oracle 1Z0-068 practice questions. You will get a surprising result by our Up to date Oracle Database 12c: RAC and Grid Infrastructure Administration practice guides.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-068 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q1. Which three statements are true about Oracle 12 RAC Database software installations?
A. It is possible to install RAC database software on a one node cluster.
B. It is possible to install multiple RAC database 12c software homes on the same cluster.
C. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OSusers.
D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RACdatabase software.
E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RACdatabase software.
F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OSuser.
Q2. 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 isntance.
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.
Q3. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1
Which statement is true about the srvctl start service command?
A. It opens the PRDPDB1 PDB if not already opened.
B. It can open the PRDPDB1 PDB only if it is policy managed.
C. It can open the PRDPDB1 PDB automatically.
D. It can open the PRDPDB1 PDB only if it is manually managed.
Q4. Which three are benefits of using RAC One Node in Oracle 12c?
A. automatic failover for high availability
B. ability to perform rolling patches
C. online conversion from RAC One Node databases to multi-instance RAC databases
D. load-balancing of services within a single instance
E. online-conversion from non-RAC databases to RAC One Node databases
F. multiple instances of the same database on a single node to protect against instance failure
Q5. Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 12c RAC?
A. In a RAC One Node database, there is no LMD0 process if only one instance is running.
B. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
C. In a RAC database, there is no LMD0 process if only one instance is running.
D. Global Enqueues and Instance Locks replace latches completely in RAC database isntances.
E. Global Enqueues may have owners and waiters in the same instance.
F. Global Enqueues may have converters and waiters in the same isntance.
Q6. Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?
A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.
B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.
C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.
D. Applying patches with Opatch must be done in an out-of-place fashion.
Q7. Which four tasks are performed by DBCA when you convert a single-instance database to a four-instance RAC database?
A. creating additional redo threads
B. creating additional undo tablespaces
C. creating shared ASM disk groups
D. adding cluster resources
E. creating database services
F. adding additional initialization parameters
Q8. Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
A. Taking an AWR snapshot in a RAC database captures data from all instances that have the databaseopened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after thetop of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to “none”
Q9. 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.
Q10. Which three statements are true about services when used with transparent application failover (TAF) for an administrator-managed RAC database?
A. TAF-enabled sessions fail over to a surviving instance accepting logins for the service.
B. TAF-settings for the service override TAF settings in TNS entry used by the client.
C. TAF can restart a query or a transaction after failover.
D. The TAF settings for a client connections overrides any TAF settings in the service definition.
E. TAF PRECONNECT requires configuration for the service and in the client TNS entry.