1Z0-068 Exam Questions

Which three statements are true regarding Flex ASM on a four-node cluster consisting of three- hub nodes and a leaf node?

Which two statements are true about initialization parameters for Clustered ASM instances?

Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?

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='...

Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

Which two statements are true about Flex ASM in a Flex Cluster?

Which three statements are true about the cluster file system archiving scheme?

Which three statements are true regarding multitenant architecture for RAC databases?

Which two statements are true about ASM alias names?

Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware?

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 ser...

Which two steps must always be performed to delete node host04 from an Oracle 12c Clusterware cluster that does not use Grid Naming Service (GNS)?

Which two utilities support the "what-if" command evaluation?

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3. Server pool prod_pool has a cardinality of three and all six h...

Which three functions are performed by the SQL Tuning Advisor?

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Wh...

Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?

Which three statements are true about Oracle Clusterware 12c Flex Cluster architecture?

Which three statements are true about Global Resource Management in an Oracle 12c RAC database?

Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?

Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

Which three statements are true about node listeners in a Grid Infrastructure Cluster using Flex ASM?

Which three statements are true about the services created when the DBCA is used to create a RAC database?

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

Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster?

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

Which four tasks are performed by DBCA when you convert a single-instance database to a four- instance RAC database?

Examine this command to create a volume in the DATA disk group: SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH STRIPE_WIDTH 1M; STRIPE_COLUMNS 1; The DATA disk group has 50...

Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy. Which two statements are true?

Examine this query and output: SQL> select order_flag, cache_size, session_flag, keep_value, 2 from user_sequences where sequence_name = `SEQ1'; O CACHE_SIZE S K -- ---------------...

When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04?

Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

Examine this output: ASMCMD> volinfo - G ACFS -a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280 State: ENABLED Size (MB): 2048 Resize Unit (MB): 32 Redunda...

Which three statements are true about Quality of Service Management (QoS)?

Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?

Which two statements are true about Quality of Service Management?

Which two statements are true about resources defined by an administrator and registered with Oracle 12c Clusterware for high availability?

Which two statements are true about v$asm ?views in clustered environment?

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

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?

Which three are benefits of using RAC One Node in Oracle 12c?

Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?

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 D...

Which two statements are true about database service administration in a RAC environment?

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

Which three statements are true about Oracle Enterprise Manager Topology Viewer?

You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?