1Z0-068 | Real Database 12c 1Z0-068 braindumps
Q21. Which three statements are true about opatch version 12?
A. It can apply patches to a database ORACLE_HOME.
B. It can apply a patchset to a database ORACLE_HOME.
C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
D. It cannot run with root privileges on a Unix-like system.
E. It can apply some patches without shutting down database instances.
F. It can only apply patches on the cluster node from where it is issued.
Answer: A,D,E
Q22. Which three statements are true regarding Flex ASM on a four-node cluster consisting of
three-hub nodes and a leaf node?
A. An ASM instance and database instances can coexist on the same hub node.
B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O todiskgroups.
F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
Answer: A,C,F
Q23. Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?
A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
B. A disk cannot be undropped as a result of a drop diskgroup.
C. It automatically unmounts the disks after successfully undropping them.
D. It is not possible to cancel pending drops of disks dropped using the force option.
Answer: A,C
Explanation:
The UNDROP DISKS clause of the ALTER DISKGROUP statement enables you to cancel all pending drops of disks within disk groups. Reference: https://docs.oracle.com/cd/B28359_01/server.111/b31107/asmdiskgrps.htm
Q24. Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware?
A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS)Management is used.
D. A server pool can have the same attributes defined for different policies in the policy set, when user-definedpolicy management is used.
E. A server pool can have different attributes defined for different policies in the policy set, when user-definedpolicy management is used.
Answer: A,C,E
Q25. The DGRP1 diskgroup has these attributes:
1.Normal redundancy
2.Two failgroups with four asmdisks in each failgroup
3.compatible.asm set to 12.1
The ASM_POWER_LIMIT is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup.
No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions:
1.Shut down all database instances using DGRP1.
2.Shut down all ASM instances.
3.Add the disks to DGRP1 specifying a large value for the REBALANCE POWER clause.
4.Start one ASM instances in restricted mode.
5.Wait for the rebalance to finish.
6.Mount DGRP1 in restricted mode.
7.Start all database instances whose files are stored in DGRP1.
8.Dismount DGRP1.
9.Mount DGRP1.
10.Start all ASM instances.
Identify the correct sequence of required steps:
A. 1, 2, 3, 4, 5, 2 ,10, 7
B. 1, 3, 5, 7
C. 1, 8, 6, 3, 5, 8, 9, 7
D. 1, 8, 6, 3, 5, 2, 10, 7
Answer: C
Q26. Which two statements are true about ASM alias names?
A. ASM files created using an alias name are not OMF files even if OMF is enabled.
B. Alias file names cannot be used together with templates when creating tablespaces.
C. ASM files created using an alias name are OMF files even if OMF is not enabled.
D. Alias names can be stored only in user-defined directories.
E. ASM files created using an alias name also have a fully qualified name and can be accessed by eithername.
Answer: A,D
Q27. 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
Answer: B,D,F
Q28. Which two statements are true about Quality of Service Management?
A. It can enable a more efficient sharing of hardware resources.
B. It can improve the performance of SQL statements.
C. It can improve system stability as the workload changes.
D. It can improve the performance of PL/SQL.
E. It can reduce the load on the system caused by Oracle background processes.
Answer: A,D
Q29. Which three components are integral parts of High Availability NFS (HANFS)?
A. Application VIP
B. DHCP
C. ExportFS
D. HAVIP
E. NFS
F. HAIP
Answer: B,C,E
Q30. 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 50GB free space.
Which two are prerequisites for successful execution of this command?
A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B. The DATA disk group must not be created with external redundancy.
C. The DATA disk group must not contain any other volume.
D. The DATA disk group must have at least three failure groups.
E. The DATA disk group must have an AU size of 1MB.
Answer: A,D
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to
11.2 or higher for the disk group.
A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG1007
2 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm