Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

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?

  1. Application server control.

  2. Oracle Management service.

  3. Oracle enterprise manager repository.

  4. Oracle enterprise manager database control.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Multiple choice technology databases

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

  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.
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Full explanation
Multiple choice technology databases

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?

  1. Host naming

  2. Local naming

  3. Easy Connect

  4. External naming

  5. Directory naming
Reveal answer Fill a bubble to check yourself
E Correct answer
Full explanation
Multiple choice technology databases

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

  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.
Reveal answer Fill a bubble to check yourself
E Correct answer
Full explanation