Tag: databases

Questions Related to databases

In your database you discovered that a tempfile in locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace?
technology databases

  1. Flash back the database

  2. Perform a point-in-time recovery.

  3. Perform a full database recovery.

  4. Drop and re-create the tablespace.

  5. Use recovery manager (RMAN) to recover the database.

Show answer
Correct Option: D

You started a long transaction before committing; you executed a query on one of the tables currently being modified. You received the following error: ORA- 01555: snapshot too old. How would you prevent such an error in future? (Choose three)
technology databases

  1. Guarantee undo retention

  2. Add one more redo log group.

  3. Configure an appropriate undo retention interval.

  4. Size the UNDO tablespace appropriately.

  5. Size the SYSTEM tablespace appropriately.

Show answer
Correct Option: A,C,D

When you trying to open your database, you receive the following error: ORA- 00205: error in identifying control file. Where would you find the details to resolve this error?
technology databases

  1. audit trail

  2. alert log file

  3. user trace file

  4. online trace file

  5. background trace file.

Show answer
Correct Option: B

What advantage would you get if you increase the length of the time during which the undo information would be restored in the database

technology databases

  1. roll back of large transaction

  2. roll forward to redo a transaction

  3. data concurrency for large updates

  4. read consistency for long running transactions.

Show answer
Correct Option: D

The database users are connecting the PROD database from different applications thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connection to be the reason for low performance and ask you to restrict the number of concurrent connections per database user to one. Which action would you take to achieve this objective?

technology databases

  1. Set the SESSION to 1 in the parameter file.

  2. Grant SINGLE SESSION privileges to all of the users.

  3. Set SESSION_PER_USER to 1 in user’s profile.

  4. Grant RESTRICTED SESSION to all of the database users.

  5. Create a role with SINGLE SESSION privilege and assign the role to users.

Show answer
Correct Option: C

Where do you find the information about missing redo log file?

technology databases

  1. trace file

  2. audit trail

  3. control file

  4. alert log file

  5. event viewer

Show answer
Correct Option: D

Your database is in NOARCHIEVELOG mode. Since last night’s offline backup the logs in group 1 have been written to twice. This morning the system data file has become corrupted. Up to what point can it be recovered?

technology databases

  1. Until the last commit.

  2. Cannot be recovered.

  3. Until the last offline backup.

  4. Until the beginning of the last transaction.

Show answer
Correct Option: C

Which background process does Automatic Shared memory Management use to coordinate the sizing of the memory component?
technology databases

  1. PMON

  2. SMON

  3. MMNL

  4. MMAN

  5. MMON

Show answer
Correct Option: D

Client connection requests are failing because the listener in not responding. You want to forward client connect request to another listener if one listener is not responding. How do you achieve this?

technology databases

  1. Enable instance failover

  2. Configure shared server

  3. Enable database failover

  4. Enable connect-time failover

  5. Enable Transparent Application Failover

Show answer
Correct Option: D

In oracle 10g, which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?

technology databases

  1. The analysis tool doesn’t provide output for the performance of SQL statement

  2. The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.

  3. The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.

  4. The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.

Show answer
Correct Option: D