最新的Oracle 1Z0-048免費考試真題

問題1

Which CREATE SEQUENCE option is the most scalable?

A. CACHE ORDER

B. NOCACHE ORDER

C. CACHE NOORDER

D. NOCACHE NOORDER

正確答案: C

問題2

Which three statements are correct regarding ASM instances in a RAC environment? (Choose three.)

A. ASM instances can mount different sets of disk groups.

B. ASM instances can use different values for ASM_POWER_LIMIT.

C. ASM instances recognize their disks by looking at their headers.

D. ASM instances must all have the same value for ASM_DISKSTRING.

E. ASM instances must all have the same value for ASM DISKGROUPS.

正確答案: A,B,C

問題3

In a RAC environment, you see a steep increase for enq:HW- contention and gc current grant wait events. What would you do to fix this issue?

A. Increase the cache size of sequences.

B. Reduce the number of updates causing locks on tables accessed by multiple instances.

C. Reduce the time of transactions by committing more often.

D. Use larger uniform extent sizes for objects.

正確答案: D

問題4

Which three statements regarding backup of the voting disk are true? (Choose three.)

A. A backup of the voting disk should be taken whenever a new node is added to the cluster.

B. Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster.

C. A backup of the voting disk should be taken whenever an existing node is removed from the cluster.

D. A backup of the voting disk should be taken whenever an RMAN catalog reset is done.

E. On UNIX platforms, the voting disk can be backed up with the dd command.

正確答案: A,C,E

問題5

The following are the steps that you have taken so far in a two-node RAC implementation:
1) Completed the preinstallation tasks
2) Performed Oracle Clusterware installation
View the Exhibit and examine the current status of a list of resources on each node.
Your next step is to install the Oracle Database 10g software on these nodes. Which statement is
true about running Oracle Universal Installer (OUI) and installing the software in this situation?

A. You run OUI from any node and the software would be installed on both the nodes successfully.

B. You must run OUI from the first node ora....17a because running it from the second node ora....17b would result in an error.

C. You run OUI from any node and the installer would prompt you to run the crs_start command to start the resources that are offline.

正確答案: A

問題6

Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others?

A. REMOTEJJSTENER

B. REMOTE_DEPENDENCIES_MODE "

C. PREFER LEAST LOADED NODE <listener-name>

D. LOCALJJSTENER

正確答案: A

問題7

Which four statements contain accurate information regarding RAC VIPs and application VIPs? (Choose four.)

A. It is recommended to share application VIPs among multiple applications.

B. A failed over application VIP does accept new connections.

C. It is not recommended to share an application VIP among several applications.

D. A RAC VIP fails over if the listener fails.

E. An application VIP fails over if the associated application fails over.

F. A failed over RAC VIP does accept new connections.

G. It is recommended to share a RAC VIP among several database instances.

H. It is not recommended to share a RAC VIP among several database instances.

正確答案: B,C,E,G

問題8

View the Exhibit and examine a database software installation step in a RAC environment.
Which statement about the path is true?

A. You must specify the same path that you specified to install ASM.

B. You should specify a path under ORACLE_BASE where Oracle product is to be installed.

C. You must specify the same path where Oracle clusterware is installed.

D. You must specify the location of the OCR file.

E. You must specify the location of Oracle inventory.

F. You should specify the same path that you specified for the ORACLE_BASE environment variable.

正確答案: B

問題9

You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.)

A. RAC would increase availability in the event of a network failure.

B. RAC would increase availability in the event of node and instance failures.

C. RAC would increase availability in the event of data failures.

D. RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.

E. RAC would increase scalability for all application workloads in all cases.

F. RAC used in conjunction with parallel execution may provide speedup of DSS queries.

G. RAC alone would increase availability when doing release upgrades.

H. RAC alone would not help protect from human errors.

正確答案: B,F,H

問題10

You are requested to make your Web server, which accesses a clustered Oracle database, highly available. Which solution would you propose?

A. Because you cannot use Oracle Clusterware to protect your Web server, you come up with an operating system solution.

B. Bring your Web server under control of the Oracle Clusterware and use an application VIP address to reach your Web server from your clients.

C. Bring your Web server under control of the Oracle Clusterware and use the public IP address to reach your Web server from your clients.

D. Bring your Web server under control of the Oracle Clusterware and use the private IP address to reach your Web server from your clients.

E. Bring your Web server under control of the Oracle Clusterware and use the RAC VIP address to reach your Web server from your clients.

正確答案: B

最新的Oracle Database 10g R2: Administering RAC - 1Z0-048免費考試真題

聯系我們

站內鏈接

最新更新