Aco 9

Front 1

1. You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. You issue the following statement:
ALTER SYSTEM SET UNDO_RETENTION=4800;
Which option is true?
A. UNDO_RETENTION is a static parameter and hence cannot be changed using ALTER SYSTEM.
B. The change will be available to the instance only after a database cycle.
C. The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
D. The value is changed only in memory, and the server parameter file needs to be updated for the change to persist across database shutdowns.

Back 1

1. C. When using ALTER SYSTEM to change parameter values, the change is made to the server parameter file (spfile) too, because the default for the
SCOPE clause is BOTH. Option D would have been correct, if the pfile was used to start up the database.

Front 2

2. You need to find the directory where the Oracle alert log is being written. Which initialization parameter contains this information?
A. ALERT_LOG_DEST
B. BACKGROUND_DUMP_DEST
C. DIAGNOSTIC_DEST
D. INIT_LOG_DUMP_DEST

Back 2

2. C. DIAGNOSTIC_DEST is the initialization parameter that determines where the Automatic Diagnostic Repository home is. The alert log file would be in t h e <diagnostic_dest>/diag/rdbms/<dbname>/<instancename>/alert directory. A text version of the alert log is in the <diagnostic_dest>/diag/rdbms/<dbname>/<instancename>/trace directory.

Front 3

3. Which data dictionary view is used to view the current values of parameters?
A. V$DATABASE
B. V$SPPARAMETER
C. V$PARAMETER
D. V$SYSPARAMETER

Back 3

3. C. V$PARAMETER shows information about the parameters and their current value in the database. V$SPPARAMTER shows the information as read from the spfile.

Front 4

4. Which startup options must be used to start the instance when you’re creating a new database?
A.STARTUP FORCE
B.STARTUP MOUNT
C.STARTUP RESTRICT
D.STARTUP NOMOUNT

Back 4

4. D. When creating a new database or creating a control file, the database should be in the NOMOUNT state.

Front 5

5. TheDIAGNOSTIC_DEST parameter is not set up in the initialization-parameter file. The value of theORACLE_HOME environment variable is /u01/app/oracle/product/11.1.0, and the value of ORACLE_BASE is /u01/app/oracle. The database name is xyz, so what is the location of the text-alert log file for the xyz database?
A. /u01/app/oracle/product/11.1.0/log/rdbms/xyz/xyz/trace
B. /u01/app/oracle/diag/rdbms/xyz/xyz/trace
C. /u01/app/oracle/diag/rdbms/xyz/xyz/alert
D. /u01/app/oracle/product/11.1.0/diag/rdbms/xyz/xyz/trace
E. /u01/app/oracle/log/rdbms/xyz/xyz/trace

Back 5

5. B. The alert log file in Oracle 11g is saved in the $ORACLE_BASE/diag/rdbms/<dbname>/<instancename>/trace directory. The XML version of the alert-
log file is in the $ORACLE_BASE/diag/rdbms/<dbname>/<instancename>/alert directory.

Front 6

6. You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?
A. A block size of 32KB is not allowed in Oracle 11g.
B. You must choose the Data Warehouse template in the DBCA.
C. You must choose the Custom template in the DBCA.
D. You must set the environment variable DB_BLOCK_SIZE to 32768.

Back 6

6. C. The Custom template lets you choose the database block size in the DBCA. If the template includes data files, the block size of the template
cannot be changed. The predefined templates that come with data files have the block size at 8KB.

Front 7

7. All the following are database-management options within the Database Configuration Assistant except which one?
A. Change Database Initialization Parameters
B. Create a Database
C. Manage Templates
D. Delete a Database

Back 7

7. A. The Database Configuration Assistant lets you create databases, manage templates, add database options, and delete databases. Although you can change initialization parameters when you are defining a database, this is not one of the management options available.

Front 8

8. Which of the following is another term for the fully qualified name of a database?
A. ORACLE SID
B. Global database name
C. Global identifier
D. Oracle global name
E. ORACLE ID

Back 8

8. B. The global database name is another term for the fully qualified name of a database. The global database name is composed of the database name and database domain.

Front 9

9. Which of the following Oracle accounts is not automatically configured by the DBCA?
A. SYS
B. SYSTEM
C. SYSMAN
D. DBSNMP
E. All these accounts are configured automatically by DBCA.

Back 9

9. E. The DBCA configures the SYS, SYSTEM, SYSMAN, and DBSNMP accounts by default. You can unlock the accounts and set the initial password.

Front 10

10. Your database name is OCA11G. The options show the files that are available in the $ORACLE_HOME/dbs directory. Which file is used to start up the database instance when you issue the STARTUP command?
A. initOCA11G.ora
B. OCA11Gspfile.ora
C. spfile.ora
D. init.ora

Back 10

10. C. When starting the instance, Oracle looks for spfileOCA11G.ora file. If it could not find that file, it looks for spfile.ora. If that file is not found, Oracle
looks for the initOCA11G.ora file.

Front 11

11. Which initialization parameter cannot be changed after creating the database?
A. DB_BLOCK_SIZE
B. DB_NAME
C. CONTROL_FILES
D. None. All parameters can be changed as and when required.

Back 11

11. A. The block size of the database cannot be changed after database creation. The database name can be changed after re-creating the control
file with a new name, and the CONTROL_FILES parameter can be changed after copying the control files to the new location.

Front 12

12. Which script creates the database dictionary?
A. dictionary.sql
B. catdict.sql
C. catproc.sql
D. catalog.sql

Back 12

12. D. The catalog.sql script creates the data dictionary views, dynamic performance views, and synonyms.

Front 13

13. If your database name is PROD and your instance name is PROD1, what would be the name of the text-alert log file?
A. alertPROD.log
B. alert_PROD1.log
C. PROD1alert.log
D. PROD_alert.log

Back 13

13. B. The text-alert log file has the name alert_<instancename>.log. For most non-RAC databases, the instance name and database name would be the same.

Front 14

14. Your database is not responding and is in a hung state. You want to shut down and start the database to release all resources. Which statements would you use?
A.STARTUP AFTER SHUTDOWN
B.STARTUP FORCE
C.SHUTDOWN FORCE
D. SHUTDOWN ABORT and STARTUP

Back 14

14. B, D. STARTUP FORCE will perform a SHUTDOWN ABORT and STARTUP of the database. SHUTDOWN ABORT will terminate all sessions and processes and shut down the instance.

Front 15

15. Which of the following startup options does not perform a database recovery?
A. STARTUP
B.STARTUP FORCE RESTRICT
C.STARTUP NOMOUNT
D.STARTUP OPEN
E.STARTUP RESTRICT

Back 15

15. C. The recovery of a database occurs when the database moves from the MOUNT mode to the OPEN mode. All these options attempt to start up and open the database except for option C, which only puts the database in NOMOUNT mode.

Front 16

16. Which of the following shutdown statements does not perform a clean shutdown?
A.SHUTDOWN ABORT
B.SHUTDOWN TRANSACTIONAL
C. SHUTDOWN
D.SHUTDOWN IMMEDIATE
E. All of these are considered clean shutdowns.

Back 16

16. A. Any time you perform a SHUTDOWN ABORT, Oracle does not perform a clean shutdown. All other types of shutdowns are considered clean shutdowns because Oracle will not have to perform recovery on a subsequent database startup.

Front 17

17. You would like to export the system and limit access to only the DBA staff during the export process. Which of the following startup options should you use?
A.STARTUP NOMOUNT RESTRICT
B.STARTUP RESTRICT
C.STARTUP MOUNT RESTRICT
D.STARTUP MOUNT FORCE RESTRICT

Back 17

17. B. The STARTUP RESTRICT choice opens the database and allows only users with RESTRICTED database access to connect and use it.

Front 18

18. You want to start up the database using a binary initialization file. What is another name for this file?
A. Configfile
B. Pfile
C. Spfile
D. init_pfile.ora

Back 18

18. C. A pfile is another term for a server-side binary file that Oracle reads when a database startup is performed. This binary file contains all the
nondefault initialization parameters used at startup.

Front 19

19. Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
A. Database startup and shutdown information
B. Nondefault initialization parameters
C. ORA-00600 errors
D. New columns added to a user table

Back 19

19. D. The Oracle alert log contains a chronological history of administrative events and actions and certain types of database errors that occur within the database. Adding a column to a user table is not an administrative action and is not recorded in the alert log.

Front 20

20. Which of the following is true about EM Database Control? (Choose all that apply.)
A. You can start up and shut down a database using Database Control.
B. You can read the contents of the alert log file.
C. You can modify static initialization parameters.
D.The CREATE DATABASEstatementcreatestheDatabaseControlrepositoryinthedatabase.

Back 20

20. A, B, C. The Database Control repository is not created when the CREATE DATABASE statement is executed. DBCA creates the Database Control repository and configures Database Control for you.