EXAMEN PREPARACION OCA 12C

1

Choose two SGA structures that are required in every Oracle instance

1

Which statement is true?

1

Which component is configured at database startup and cannot be dynamically
managed?

1

Which component is not part of an Oracle instance?

1

Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?

1

User John has updated several rows in a table and issued a commit. What does the
DBWn (database writer) process do at this time in response to the commit event?

1

Which of the following best describes a RAC configuration?

1

Which component of the SGA contains the parsed SQL code?

1

Which tasks are accomplished by the SMON process? (Choose all that apply.)

1

Choose the best statement from the options related to segments.

1

From the following list, choose two processes that are optional in an Oracle Database
12c database.

1

Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?

1

When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)

1

The LRU algorithm is used to manage what part of the Oracle architecture?

1

Two structures make up an Oracle server: an instance and a database. Which of the
following best describes the difference between an Oracle instance and a database?

1

Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?

1

The DBA unknowingly terminated the process ID belonging to the PMON process
of Oracle Database 12c database using the kill -9 command on Unix. Choose the
best answer:

1

When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.

1

User Isabella updates a table and commits the change after a few seconds. Which of the
following actions are happening in the database? Order them in the correct sequence
and ignore the actions that are not relevant.

1

Querying the V$LOG file shows the following information. Which redo group files are
required for instance crash recovery?
SQL> select GROUP#, ARCHIVED, STATUS from V$LOG;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO ACTIVE

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?

1

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

1

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

1

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

1

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?

1

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

1

All of the following are database-management options within the Database Configuration
Assistant except which one?

1

The Oracle Universal Installer is started by executing which program?

1

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?

1

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?

1

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

1

Which script creates the database dictionary?

1

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

1

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?

1

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

1

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

1

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?

1

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

1

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

1

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

1

Which of the following statements about tablespaces is true?

1

Automatic segment space management on the tablespace causes which of the following
table attributes in that tablespace to be ignored?

1

Which is not a type of segment that is stored in a tablespace?

1

Which allocation unit is the smallest?

1

You performed the following statement in the database. What actions can you perform
on the CUST_INFO table in the CUST_DATA tablespace. (Choose all that apply.)

ALTER TABLESPACE CUST_DATA READ ONLY;

1

If the tablespace is offline, which statements should be executed to make the USERS
tablespace read-only? (Choose all that apply.)

1

How would you add more space to a tablespace? (Choose all that apply.)

1

The database is using automatic memory management. The standard block size for
the database is 8KB. You need to create a tablespace with a block size of 16KB.
Which initialization parameter should be set?

1

Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?

1

How would you drop a tablespace if the tablespace were not empty?

1

Which command is used to enable the autoextensible feature for a file if the file is already part of a tablespace?

1

Which statement is true regarding the SYSTEM tablespace?

1

The default critical threshold for a tablespace is set at 97 percent, and you think that
is too low. Which two options can you use to change the threshold value to 90 percent
for tablespace APPS_DATA?

1

Choose the statements that are resumable. (Choose three.)

1

How do you ensure you are notified when a resumable session is suspended?
(Choose two.)

1

Which statement regarding reclaiming wasted space is true?

1

Which compression option should be specified to compress blocks of tables that are
used by the OLTP application?

1

Choose the best option regarding extents.

1

You issue the statement CREATE TABLESPACE X;. Which of the following is the
best option?

1

Choose the information that is not part of a ROWID.

1

Changes made with an UPDATE statement in a transaction are permanent in the database
and visible to other users after what occurs?

1

Which of the following commands returns an error if the transaction starts with SET
TRANSACTION READ ONLY?

1

Guaranteed undo retention can be specified for which of the following objects?

1

Which of the following lock modes permits concurrent queries on a table but prohibits
updates to the locked table?

1

Select the statement that is not true regarding undo tablespaces

1

To resolve a lock conflict, which of the following methods can you use? Choose all
that apply.

1

Two transactions occur at the wall clock times in the following table. What happens
at 10:05?

WIP

EXAMEN PREPARACION OCA 12C

Choose two SGA structures that are required in every Oracle instance

Which statement is true?

Which component is configured at database startup and cannot be dynamically managed?

Which component is not part of an Oracle instance?

Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?

User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?

Which of the following best describes a RAC configuration?

Which component of the SGA contains the parsed SQL code?

Which tasks are accomplished by the SMON process? (Choose all that apply.)

Choose the best statement from the options related to segments.

From the following list, choose two processes that are optional in an Oracle Database 12c database.

Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?

When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)

The LRU algorithm is used to manage what part of the Oracle architecture?

Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?

Which of the following is the proper order of Oracle’s storage hierarchy, from smallest to largest?

The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer:

When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.

User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.

Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery? SQL> select GROUP#, ARCHIVED, STATUS from V$LOG; GROUP# ARC STATUS ---------- --- ---------------- 1 NO CURRENT 2 NO INACTIVE 3 NO INACTIVE 4 NO ACTIVE

Which component is configured at database startup and cannot be dynamically
managed?

Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?

User John has updated several rows in a table and issued a commit. What does the
DBWn (database writer) process do at this time in response to the commit event?

From the following list, choose two processes that are optional in an Oracle Database
12c database.

Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?

When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)

Two structures make up an Oracle server: an instance and a database. Which of the
following best describes the difference between an Oracle instance and a database?

Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?

The DBA unknowingly terminated the process ID belonging to the PMON process
of Oracle Database 12c database using the kill -9 command on Unix. Choose the
best answer:

When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.

User Isabella updates a table and commits the change after a few seconds. Which of the
following actions are happening in the database? Order them in the correct sequence
and ignore the actions that are not relevant.

Querying the V$LOG file shows the following information. Which redo group files are
required for instance crash recovery?
SQL> select GROUP#, ARCHIVED, STATUS from V$LOG;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO ACTIVE

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?

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

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

All of the following are database-management options within the Database Configuration
Assistant except which one?

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?

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?

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

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?

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?