databases Online Quiz - 175
Description: databases Online Quiz - 175 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Identify two tablespaces whose data files are so critical that only a closed recovery is possible?
Data files of which three tablespaces can be recovered by performing an open recovery?
While running OUI on a UNIX platform to install Oracle 10g software you are prompted to run orainstRoot.sh script. What does this script accomplish?
You want to perform a backup of your database to a tape. Which backup format can you use?
One user session was terminated abnormally in the middle of a transaction What does oracle database do to recover it?
You are using the following command to clear the log file group ALTER DATABASE CLEAR LOGFILE GROUP 2; In which case would the command be successful?
Users in PROD database reported about the slow responses of the transaction. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem?
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?
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?
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?
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?
Which background process does Automatic Shared memory Management use to coordinate the sizing of the memory component?
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?