Tag: databases

Questions Related to databases

In oracle 10g, which statement regarding the usage of redo log file during instance recovery is true?
technology databases

  1. Transactions are rolled back using redo log files.

  2. Transactions are rolled forward using redo log files.

  3. Transactions are rolled back using redo log files and archived log files.

  4. Transactions are rolled forward using redo log files and rolled back using redo log files

Show answer
Correct Option: B

You have determined that the archiving was not successful in on of the destinators. You want to check the alert log file for more information on this. Which initialization parameter gives you the location of the alert log file?
technology databases

  1. USER_DUMP_DEST

  2. CORE_DUMP_DEST

  3. ALERT_LOG_DEST

  4. BACKGROUND_DUMP_DEST

  5. ALERT_DUMP_DEST

Show answer
Correct Option: D

You want to administer your database servers, which are running on different host machines using the web enabled grid control interface. You have configured the agent in the host machines. You have started Oracle database10g grid control utility on your machine. Which two additional components would you configure to achieve this objective?
technology databases

  1. Application server control.

  2. Oracle Management service.

  3. Oracle enterprise manager repository.

  4. Oracle enterprise manager database control.

Show answer
Correct Option: C,D

Your database is in NOARCHIEVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case?
technology databases

  1. Hot backup

  2. Online backup

  3. Consistent backup

  4. Incremental backup

  5. Inconsistent backup

Show answer
Correct Option: C

You have enabled tracking while creating a listener to your database. What additional information is available to you when you enable tracking?
technology databases

  1. Information about each oracle Net connection.

  2. Information about each entry in the Listener.ora file

  3. Information about the changes done in the database.

  4. None

Show answer
Correct Option: A

In Oracle 10g , which statement regarding the contents of the V$PARAMETER view is true?
technology databases

  1. Displays only the list of all default values.

  2. Displays only the list of all basic parameters.

  3. Displays currently in effect parameter values.

  4. Displays only the list of all advanced parameter.

Show answer
Correct Option: C

Your database is opened in NOARCHIVELOG mode. You decide to place the database in ARCHIEVELOG mode. How would you do this? ( Choose two)
technology databases

  1. Execute the ALTER DATABASE ARCHIVELOG statement

  2. Select ARCHIVELOG option in database control and restart the database to apply the changes.

  3. Shutdown and restart the instance, and in NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.

  4. Shutdown and restart the instance mount the database and execute the ALTER DATABASE ARCHIVELOG statement.

Show answer
Correct Option: B,D

Suppose you are using three databases, DB01, DB02, and DB03 on different host machines in development environment. The database server configuration such as server IP address and listener Port number changes frequently due to development requirements. And you have the task of notifying the developers of the changes. Which connection method would you use to overcome the overhead?
technology databases

  1. Host naming

  2. Local naming

  3. Easy Connect

  4. External naming

  5. Directory naming

Show answer
Correct Option: E

In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?
technology databases

  1. It degrades the run time and compiler performance

  2. It provides better run time and compiler performance

  3. It provides better optimization of the statement during parse time.

  4. It forces the rule based optimizer to be used for statement optimization.

  5. It provides better run time performance, but slightly degraded compiler performance.

Show answer
Correct Option: E

You are working on the Training Database. What is default name of the alert log file in this database?
technology databases

  1. alert_Training.log

  2. alertlog_Training.log

  3. alert_log_Training.log

  4. Training_alert_log.log

Show answer
Correct Option: A