| 1. | Which of the following becomes available when an Oracle instance is started? |
| a. | | User process |
| b. | | Server process |
| c. | | Datafile |
| d. | | Background processes
|
|
|
|
|
|
|
| 2. | Identify the complete list of the logical components of an Oracle database? |
| a. | | Tablespaces, segments, extents, and data files |
| b. | | Tablespaces, segments, extents, and Oracle blocks |
| c. | | Tablespaces, database, segments, extents, and data files |
| d. | | Tablespaces, database, segments, extents, and Oracle blocks
|
|
|
|
|
|
|
| 3. | A database has the DB_NAME set to STUD and ORACLE_SID set to STUD.
The following files are in the default location for the initialization files:
-init.ora
-initSTUD.ora
-spfile.ora
-spfileSTUD.ora
The database is started with the command SQL> startup
Which initialization files does the Oracle Server attempt to read, and in which order? |
| a. | | Init.ora, initSTUD.ora, spfileSTUD.ora |
| b. | | Spfile.ora, spfileSTUD.ora, initSTUD.ora |
| c. | | SpfileSTUD.ora, spfile.ora, initSTUD.ora |
| d. | | InitSTUD.ora, spfileSTUD.ora, spfile.ora
|
|
|
|
|
|
|
| 4. | Which parameters should be set, to limit the number of transactions that can simultaneously make changes to data in a block, and increase the frequency with which Oracle returns a block back on the free list? |
| a. | | INITRANS and PCTUSED |
| b. | | MAXTRANS and PCTFREE |
| c. | | INITRANS and PCTFREE |
| d. | | MAXTRANS and PCTUSED
|
|
|
|
|
|
|
| 5. | While checking the alert log for the database many lines are discovered that say "Checkpoint Not Complete". How can the problem be solved? |
| a. | | Delete archived log files |
| b. | | Add more online redo log groups |
| c. | | Increase the size of archived log files |
| d. | | increase the size of online redo log files
|
|
|
|
|
|
|
| 6. | Examine the SQL statement:
CREATE TABLESPACE user_data
DATAFILE '/u01/oradata/userdata_0l.dbf' SIZE 100M
LOCALLY MANAGED UNIFORM SIZE 1M
AUTOMATIC SEGMENT SPACE MANAGEMENT;
Which part of the tablespace will be of a uniform size of 1 MB? |
| a. | | Extent |
| b. | | Segment |
| c. | | Oracle block |
| d. | | Operating system block |
| e. | | None of the above
|
|
|
|
|
|
|
| 7. | What is the correct method for starting an instance to create a database? |
| a. | | STARTUP |
| b. | | STARTUP OPEN |
| c. | | STARTUP MOUNT |
| d. | | STARTUP NOMOUNT
|
|
|
|
|
|
|
| 8. | Which file is part of the Oracle database? |
| a. | | Control file |
| b. | | Password file |
| c. | | Parameter file |
| d. | | Archived log file
|
|
|
|
|
|
|
| 9. | A primary database named PROD and a standby database named PRODS is maintained using standby log transmission to send the log files to the standby database.
To prevent any propagation of errors, the standby database should wait for 20 minutes before processing any log files shipped from the primary database.
What steps should be taken? |
| a. | | The LOG_ARCHIVE_DEST_n = 'SERVICE=PRODS DELAY 20' parameter should be included in the parameter file on the primary database |
| b. | | The LOG_ARCHIVE_DEST_n = 'SERVICE=PROD DELAY 20' parameter should be included in the parameter file on the standby database |
| c. | | The REOPEN option should be specified on the LOG_ARCHIVE_DEST_n parameter |
| d. | | At least one of the log archive destinations should be set to MANDATORY
|
|
|
|
|
|
|
| 10. | Which statement should be used to obtain information about the number, names, status, and location of the control files? |
| a. | | SELECT name, status FROM v$parameter; |
| b. | | SELECT name, status FROM v$controlfile; |
| c. | | SELECT name, status, location FROM v$control_files; |
| d. | | SELECT status, location FROM v$parameter WHERE parameter=control_files;
|
|
|
|
|
|
|
| 11. | When is the SGA created in an Oracle database environment? |
| a. | | When the database is created |
| b. | | When the instance is started |
| c. | | when the database is mounted |
| d. | | When a user process is started
|
|
|
|
|
|
|
| 12. | A database was started with the command STARTUP PFILE=initEMPLOYEE.ora
A value in the initEMPLOYEE.ora parameter file is LOG_ARCHIVE_START=false
While the database is open, ALTER SYSTEM ARCHIVE LOG START; command was issued to start the Archiver process.
The database was shut down to take a back up and restart it using the initEMPLOYEE.ora parameter file again. When the status of the Archiver was checked, it was disabled. Why? |
| a. | | When a backup is taken the Archiver process is disabled |
| b. | | The Archiver can only be started by issuing the ALTER DATABASE ARCHIVELOG command |
| c. | | LOG_ARCHIVE_START is still set to FALSE because the PFILE is not updated when you issue the ALTER SYSTEM command |
| d. | | The Archiver can only be started by issuing the ALTER SYSTEM ARCHIVE LOG START command each time the database is opened
|
|
|
|
|
|
|
