Oracle 1z0-068 問題集

質問 1：
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)?
A. Run the rootcrs.pl - deconfig -force command as root on host01, or on either host02 or host03.
B. Run the crsctl unpin css -n host04 command as root on host04
C. Run the crsctl delete node -n host04 command as root on host04.
D. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.
E. Run the rootcrs.pl - deconfig -force command as root on host04.
F. Run the crsctl delete node -n host04 command as root on host01, or on either host02 or host03.
正解：E,F
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?
A. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
B. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
C. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
D. Performance of ACFS is improved by using these diskgroups.
E. Their sector size attributes can be changed using the ALTER DISKGROUP command.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which three options have a RAC-specific tuning component?
A. sequence definitions
B. contention for archived redo log files
C. the size of the online redo log buffers
D. the load on the Cluster Interconnect
E. contention on index leaf blocks
F. contention for online redo log files
正解：A,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)
A. gc current grant busy
B. gc cr grant busy
C. gc current block busy
D. gc cr block busy
E. gc cr request
F. gc current request
正解：E,F

質問 5：
Examine the output of the asmcmd and srvct1 commands:

Then you execute this command:
$ srvctl relocate asm - currentnode host03 -targetnode host02
Which three statements are true regarding the execution of this command based on the output shown?
A. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnected.
B. It fails because the ASM instance has not been shut down first on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01.
D. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
E. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02.
F. It fails because an ASM instance is not configured to run on HOST02.
正解：A,C,E

質問 6：
Examine this tnsnames entry from a RAC configuration using a SCAN listener:
HR=(DESCRIPTION=
(LOAD_BALANCE =on)
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=HRSRV)))
Which two statements are true about clients using this entry to connect? (Choose two.)
A. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.
B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
C. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
D. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
E. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.
正解：B,C

質問 7：
Which two statements are true about Instance Locks in Oracle 12c RAC? (Choose two.)
A. They are used to coordinate the next value for a sequence created with the CACHE and ORDER clauses.
B. They are used to coordinate access across multiple library caches for the same stored procedure.
C. They are used when an application uses the DBMS_LOCK package for UL lock types.
D. They are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses.
E. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution.
正解：A,B

質問 8：
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 installs the OpenSSH client package.
C. It creates the oinstall group if not already defined.
D. It installs kernel modules required for the ASM Cluster File System (ACFS).
E. It modifies the /etc/sysctl.conf Linux file.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)