Jamonero Blanco
Quiz by , created more than 1 year ago

OCA OCA Quiz on OCA-9-Creating and Operating Oracle Database 12c, created by Jamonero Blanco on 29/01/2017.

223
2
0
Jamonero Blanco
Created by Jamonero Blanco almost 8 years ago
Close

OCA-9-Creating and Operating Oracle Database 12c

Question 1 of 20

1

1. You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too
low for some of your transactions. The database was created using DBCA. You issue
the following statement:
ALTER SYSTEM SET UNDO_RETENTION=4800;
Which option is true?

Select one or more of the following:

  • A. UNDO_RETENTION is a static parameter and, therefore, 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.

Explanation

Question 2 of 20

1

2. You need to find the directory where the Oracle alert log is being written. Which initial-
ization parameter can be best used to list the full directory path of the alert log location?

Select one or more of the following:

  • A. ALERT_LOG_DEST

  • B. BACKGROUND_DUMP_DEST

  • C. DIAGNOSTIC_DEST

  • D. INIT_LOG_DUMP_DEST

Explanation

Question 3 of 20

1

3. Which data dictionary view is used to view the current values of parameters?

Select one or more of the following:

  • A. V$DATABASE

  • B. V$SPPARAMETER

  • C. V$PARAMETER

  • D. V$SYSPARAMETER

Explanation

Question 4 of 20

1

4. Which startup options must be used to start the instance when you create a new database?

Select one or more of the following:

  • A. STARTUP FORCE

  • B. STARTUP MOUNT

  • C. STARTUP RESTRICT

  • D. STARTUP NOMOUNT

Explanation

Question 5 of 20

1

5. The DIAGNOSTIC_DEST parameter is not set up in the initialization-parameter file. The
value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0 ,
and the value of ORACLE_BASE is /u01/app/oracle . The database and instance name is
xyz . What is the location of the text-alert log file for the xyz database?

Select one or more of the following:

  • A. /u01/app/oracle/product/12.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/12.1.0/diag/rdbms/xyz/xyz/trace

  • E. /u01/app/oracle/log/rdbms/xyz/xyz/trace

Explanation

Question 6 of 20

1

6. You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which
statement is true?

Select one or more of the following:

  • A. A block size of 32KB is not allowed in Oracle Database 12c.

  • 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 32,768.

Explanation

Question 7 of 20

1

7. All of the following are database-management options within the Database Configura-
tion Assistant except which one?

Select one or more of the following:

  • A. Change Database Initialization Parameters

  • B. Create a Database

  • C. Manage Templates

  • D. Delete a Database

Explanation

Question 8 of 20

1

8. The Oracle Universal Installer is started by executing which program?

Select one or more of the following:

  • A. emctl

  • B. runInstaller

  • C. ouistart

  • D. isqlplusctl

Explanation

Question 9 of 20

1

9. You’ve been asked to install Oracle Database 12c on a new Linux server. You’re likely
to ask the Unix system administrator to do all but which one of the following for you
in order to get the new server ready for Oracle?

Select one or more of the following:

  • A. Modify the server’s kernel parameters.

  • B. Create a new Unix user to own the Oracle software.

  • C. Create the mount points and directory structure using the OFA model.

  • D. Determine which directory will be used for $ORACLE_HOME .

Explanation

Question 10 of 20

1

10. Your database name is OCA12C . 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?

Select one or more of the following:

  • A. initOCA12C.ora

  • B. OCA12Cspfile.ora

  • C. spfile.ora

  • D. init.ora

Explanation

Question 11 of 20

1

Which initialization parameter cannot be changed after the database is created?

Select one or more of the following:

  • A. DB_BLOCK_SIZE

  • B. DB_NAME

  • C. CONTROL_FILES

  • D. None. All parameters can be changed as and when required.

Explanation

Question 12 of 20

1

12. Which script creates the database dictionary?

Select one or more of the following:

  • A. dictionary.sql

  • B. catdict.sql

  • C. catproc.sql

  • D. catalog.sql

Explanation

Question 13 of 20

1

13. If your database name is PROD and your instance name is PROD1 , what would be the
name of the text-alert log file?

Select one or more of the following:

  • A. alertPROD.log

  • B. alert_PROD1.log

  • C. PROD1alert.log

  • D. PROD_alert.log

Explanation

Question 14 of 20

1

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?

Select one or more of the following:

  • A. STARTUP AFTER SHUTDOWN

  • B. STARTUP FORCE

  • C. SHUTDOWN FORCE

  • D. SHUTDOWN ABORT and STARTUP

Explanation

Question 15 of 20

1

15. Which of the following startup options does not perform a database recovery?

Select one or more of the following:

  • A. STARTUP

  • B. STARTUP FORCE RESTRICT

  • C. STARTUP NOMOUNT

  • D. STARTUP OPEN

  • E. STARTUP RESTRICT

Explanation

Question 16 of 20

1

16. Which of the following shutdown statements does not perform a clean shutdown?

Select one or more of the following:

  • A. SHUTDOWN ABORT

  • B. SHUTDOWN TRANSACTIONAL

  • C. SHUTDOWN

  • D. SHUTDOWN IMMEDIATE

  • E. All of these are considered clean shutdowns.

Explanation

Question 17 of 20

1

17. You would like to perform maintenance on the system and limit access to only the
DBA staff during the maintenance window. Which of the following startup options
should you use?

Select one or more of the following:

  • A. STARTUP NOMOUNT RESTRICT

  • B. STARTUP RESTRICT

  • C. STARTUP MOUNT RESTRICT

  • D. STARTUP MOUNT FORCE RESTRICT

Explanation

Question 18 of 20

1

18. You want to start up the database using a binary initialization file. What is another
name for this file?

Select one or more of the following:

  • A. Configfile

  • B. Pfile

  • C. Spfile

  • D. init_pfile.ora

Explanation

Question 19 of 20

1

19. Under normal circumstances, which of the following actions or events is not found in
the Oracle alert log?

Select one or more of the following:

  • A. Database startup and shutdown information

  • B. Nondefault initialization parameters

  • C. ORA-00600 errors

  • D. New columns added to a user table

Explanation

Question 20 of 20

1

20. Which of the following is true about EM Database Express? (Choose all that apply.)

Select one or more of the following:

  • A. You can start up and shut down a database using Database Express.

  • B. You can read the contents of the alert log file.

  • C. You can modify static initialization parameters.

  • D. The CREATE DATABASE statement creates the Database Control repository in the
    database.

Explanation

Previous
Next