Oracle 1Z0-048 問題集

質問 1：
Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)
A. You can use a cluster file system or a raw device to store snapshot control files.
B. You need to configure a default path and file name for these snapshot control files that is valid on every node from which you might initiate an RMAN backup.
C. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.
D. By default, the snapshot control file is created on the node that is making the backup.
正解：A,B,D

質問 2：
On a UNIX platform, which three processes are required to be running on all nodes before initiating a cluster database creation? (Choose three.)
A. evmd.bin
B. ocssd.bin
C. racgmon.bin
D. crsd.bin
正解：A,B,D

質問 3：
You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster?
A. onsctl
B. crsctl
C. Isnrctl
D. crs_stat
E. addnode.sh
正解：D

質問 4：
You need to add a new service to your RAC database, called DBA, to account for all the work done by database administrator sessions performing routine maintenance, to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the-clock access requirements. The database administration team may connect locally or remotely to the RAC database. You decide to use DBCAto create the new service. What must be true to allow client-server connection to the DBA service? (Choose two.)
A. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service.
B. The TNSNAMES.ORAfile or a name server must contain the net service entries for the DBA service.
C. The services must be started using the SRVCTL START SERVICE command.
D. The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners.
E. The service must be started using the DBMS_SERVICE.START_SERVICE procedure.
F. The service must have at least one preferred or available instance that is running and accepting logins.
正解：B,F

質問 5：
Over a six-month period, you have been regularly monitoring your four-instance RAC database,
which is running on the first 4 nodes of a 6-node cluster, by using ADDM and by monitoring well-
known combinations of wait event and statistics in AWR reports.
Two weeks ago, a newer version of your main application went live. Starting last week, you
noticed a large increase in CPU time (consumed by the three application services on your RAC
database) due to increased workload.
The OLTP and DSS services have not had a decrease in the percentage of time spent using CPU.
However, for the BATCH service the percentage of time spent using CPU has gone down and the
wait-time percentage has increased.
You want to recommend a tuning exercise to your team. Which two recommendations would you
make first, based on the symptoms described? (Choose two.)
A. The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
B. The OLTP and DSS service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
C. Tune SQL from the BATCH service programs because they may benefit from SQL tuning.
D. The OLTP and DSS service programs may scale well and could benefit from adding new database instances on one or both of nodes 5 and 6, and by adding more nodes the SQL for BATCH service programs would perform better due to more CPU power.
E. Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning.
正解：B,C

質問 6：
You decide to implement a Data Guard configuration to support a disaster recovery plan for your RAC database. Your primary database has all shared files and the flash recovery area is stored on ASM disk groups. Which three options exist for storing the data guard broker configuration files at the primary location? (Choose three.)
A. must be stored on Oracle Cluster File System if a cluster file system is used
B. must be in the same shared ASM disk group as the database data files if the broker configuration files are stored in ASM disk groups
C. may be stored on any supported cluster file system if a cluster file system is used
D. can be stored on shared Raw Devices
E. must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files are stored in ASM disk groups.
F. can be in any shared ASM disk group
正解：C,D,F

質問 7：
Several steps must be followed to successfully add a node to your cluster database. Assuming that a UNIX platform is used, which of the steps listed below is not correct? (Choose the incorrect step.
A. Configure the OS and hardware for the new node.
B. Reconfigure listeners for the new node with netca.
C. Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
D. Add instances via DBC
E. Add the RAC software to the new node using orainstRoot.sh from ORACLEJHOM
正解：E

質問 8：
You are implementing a three-node RAC setup in your company. You have already performed these tasks:
1) Hardware and OS configuration 2) Cluster file system installation 3) Clusterware installation You executed the following command in one of the nodes: cluvfy stage -pre dbinst -n all
What is the reason for executing this command?
A. to check whether the dbinst directory is available on all the nodes
B. to check for the existence of Oracle database software installation files in the /stage directory on all the nodes
C. to check if the ORACLEJHOME environmental variable is set to a correct value or not before the database installation
D. to check for node connectivity and Clusterware integrity
正解：D