Oracle 1z0-078 問題集

質問 1：
You must deploy several Oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another.
Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local file system.
2. Install Oracle Database software on an ACFS file system.
3. Create several RAC One Node databases.
Which of the seven requirements are met by your plan?
A. 1, 2, 3, 4 and 6.
B. 2, 3, 4 and 6.
C. 2, 3, 4, 5 and 6.
D. 1, 2, 3 and 4.
E. 1, 2, 3, 4, 5 and 6.
F. 1, 2, 3, 4, 5, 6 and 7.
正解：D

質問 2：
For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)
A. Database transactions
B. Local resources
C. Administrator-defined resources
D. Cluster resources
E. Pluggable Databases (PDBs)
正解：B,C,D

質問 3：
You administer a RAC database that currently runs on a four-node cluster but which has three instances.
Which two statements are always true about redo logs for this RAC database? (Choose two.)
A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
B. A redo log group added using alter database add logfile without the instance clause is added to each instance.
C. A thread of redo must contain at least two log groups before it can be enabled.
D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.
正解：A,C

質問 4：
Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC? (Choose two.)
A. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes.
B. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed.
C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed.
D. The Clusterware stack must be up on all cluster nodes.
E. Grid Infrastructure must be installed on all cluster nodes.
F. The Clusterware stack must be up on all cluster nodes where the Database software will be installed.
正解：C,E

質問 5：
Examine the output of this command:

The ACFS disk group is a normal redundancy disk group with 5 GB of free space.
To increase the size of the ACFS file system, you execute this command as the root user:
$ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command? (Choose two.)
A. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
B. It fails to resize voli because it must be executed as a user belonging to the sysasm group.
C. It resizes voli.
D. It fails to resize the filesystem because it must be unmounted before resizing.
E. It succeeds but leaves the file system unmounted.
正解：A,C

質問 6：
Which two statements are true about v$asm- views in a clustered environment? (Choose two.)
A. They exist in both ASM and RDBMS instances, and display the same output.
B. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. Their names can be seen in dice when connected to an ASM instance.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.
正解：B,E

質問 7：
Which two statements are true about node listeners in a Grid Infrastructure Cluster using ASM? (Choose two.)
A. They listen on behalf of any ASM instance and all database instances on the same node.
B. There can be only one node listener per node.
C. They listen only for the ASM instance on the same node.
D. They run from the Grid Infrastructure home by default.
E. They listen only for database instances on the same node.
正解：A,D

質問 8：
Examine these descriptions of ASM instance shutdown behavior:
1) The ASM instance shuts down immediately without an orderly dismount of disk groups.
2) Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
3) Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
Which two lists are correct matches for these descriptions? (Choose two.)
A. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
B. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
C. 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
D. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT
E. 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
正解：B,D