1Z0-048 by Oracle Valid Free Exam Practice Test

Question 1

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. The service must be started using the DBMS_SERVICE.START_SERVICE procedure. B. The TNSNAMES.ORAfile or a name server must contain the net service entries for the DBA service. C. The service must have at least one preferred or available instance that is running and accepting logins. D. The services must be started using the SRVCTL START SERVICE command. E. The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners. F. All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service.

Correct Answer: B,C

Question 2

You and your colleague are working with Oracle Support on a database instance stability issue. The Oracle Support engineer wants you to issue a crsctl debug log crs ?crsctl debug log crs command to assist you in your troubleshooting assignment. Why does the Oracle Support engineer want you to do this?

A. to enable extra debugging on the currently running CRS daemon B. to list what debugging options are available on the CRS daemon C. to enable extra debugging on the CRS daemon the next time the CRS daemon is started D. to list which debugging options are enabled on the CRS daemon E. to enable extra debugging on the currently running and CRS daemons as well as those that will run in the future

Correct Answer: E

Question 3

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 location of Oracle inventory. B. You must specify the location of the OCR file. C. You must specify the same path where Oracle clusterware is installed. D. You should specify a path under ORACLE_BASE where Oracle product is to be installed. E. You must specify the same path that you specified to install ASM. F. You should specify the same path that you specified for the ORACLE_BASE environment variable.

Correct Answer: D

Question 4

You are working with Oracle Support to investigate to what extent a disk subsystem corruption has affected your Oracle cluster configuration. The support engineer wants you to run the OCRCHECK command and read out the output. What is the effect of running the OCRCHECK command?

A. t performs an OCR integrity check. B. t checks whether all your cluster resources, such as databases, instances, listeners, and node applications, are registered within the OCR. C. t checks whether the OCR daemons are making regular backups of the OCR. D. t checks whether there is enough disk space for the OCR. E. t checks whether the Oracle Cluster Registry daemons are running normally.

Correct Answer: A

Question 5

The following query shows four MEMBER disks and three CANDIDATE disks.
SQL> select name, header_status, path from v$asm_disk;
NAME HEADER STATUS PATH
CANDIDATE /dev/rdsk/diska5
CANDIDATE /dev/rdsk/diska6
CANDIDATE /dev/rdsk/diska7
DISK01 MEMBER /dev/rdsk/diska1
DISK02 MEMBER /dev/rdsk/diska2
DISK03 MEMBER /dev/rdsk/diska3
DISK04 MEMBER /dev/rdsk/diska4
7 rows selected.
Using SQLPIus you want to add /dev/rdsk/diska5 and /dev/rdsk/diska6 to diskgroup DGROUP1
DGROUP1 is currently mounted.
Pick the statement that would fail to add diska5 and diska6.

A. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/disk*5', '/dev/rdsk/disk*6'; B. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska[56]'; C. ALTER DISKGROUP dgroupl ADD DISK
'/dev/rdsk/diska5',
'/dev/rdsk/diska6'; D. ALTER DISKGROUP dgroupl ADD DISK
'/dev/rdsk/diska5' name disk05,
'/dev/rdsk/diska6' name disk06; E. ALTER DISKGROUP dgroupl ADD DISK '/dev/rdsk/diska*';

Correct Answer: E

Question 6

When an ASM instance initializes, ASM discovers and examines the contents of all the disks that are in the paths designated in the ASM_DISKSTRING initialization parameter. Under which four other circumstances does disk discovery take place? (Choose four.)

A. when you query V$ASM_DISKGROUP B. when you run ALTER DISKGROUP...ADD DISK C. when you query VJASMjDPERATION D. when you run ALTER DISKGROUP...RESIZE DISK E. when you query V$ASM_DISK

Correct Answer: A,B,D,E

Question 7

Which three statements are true regarding RAC instance startup and shutdown using SQL'Plus? (Choose three.)

A. Using SQL*Plus to start and stop the RAC database instances is the preferred method because SQL*Plus is a Clusterware client. B. To start or shut down your local instance, initiate a SQL*Plus session connected as SYSDBA or SYSOPER, and then issue the required command. C. It is not possible to start up or shut down more than one instance at a time in SOL*Plus. so you cannot start or stop all the instances for a cluster database with a single SQL*Plus command. D. You can start multiple instances from a single SQL*Plus session on one node using Oracle Net Services connection strings.

Correct Answer: B,C,D

Oracle Database 10g R2: Administering RAC - 1Z0-048 Exam Practice Test