Which two methods can you use to work around the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ct database and OS statistics. Answer: C,D,F QUESTION 114: You want the default database to participate in automatic startup and have configured the startup script and runlevels. However, the dbstart script does not start the instance. Which two methods can you use to work around the problem? (Choose two.) A. Specify the command: SQL>CREATE SPFILE = '?/dbs/spfile@.ora' FROM PFILE = '?/dbs/init@.ora': B. Edit the startup script: Add the line: CREATE SPFILE = '?/dbs/spfile@.ora' FROM PFILE = '?/dbs/init@.ora': Replace the line: if [ -f $PFILE ] ; then with if [-f $PFILE -o -f $PFILE ] ; then C. Edit the dbstart script: Add the line: PFILE=${ORACLE_HOME }/dbs/init@.ora' Replace the line: if [-f $PFILE ] ; then with if [ -f$PFILE -f-f $SPFILE ] ; then D. Edit the dbstart script: Add the line: SPFILE=${ORACLE_HOME }/dbs/spfile${ORACLE_SID }.ora Replace the line: if [ -f$PFILE ] ; then with if [ -f $PFILE -o -f $SPFILE ] ; then E. Specify the command: SQL> CREATE PFILE = '?/dbs/init@.ora' FROM SPFILE = '?/dbs/spfile@.ora' ; Answer: D,E QUESTION 115: You are trying to connect to a database as scott/tiger@orcl92 You are getting the following error message: ORA 12154: TNS:could not resolve the service name Which two Oracle utilities or tools could you use to add or modify a service name in the tnsnames.ora file? (Choose two.) Actualtests.com - The Power of Knowing 1Z0-036 A. Oracle Net Configuration Assistant B. Oracle Net Manager C. Database Configuration Assistant D. Listener Control utility E. Oracle Names Control utility F. Oracle Connection Manager Control utility Answer: A,B QUESTION 116: Which file systems support asynchronous input/output (I/O)? (Choose all that apply.) A. Oracle Clustered File System (OCFS) B. Raw partitions C. ext3 D. General Parallel File System (GPFS) E. ext2 F. Network File System (NFS) Answer: A,B,C,E QUESTION 117: Your operating system (OS) does not support asynchronous input/output (I/O). Which Oracle 9.2 initialization parameter would you use to simulate asynchronous I/O? A. OPEN_LINKS B. PRE...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online