databases Online Quiz - 175
|Description: databases Online Quiz - 175
|Number of Questions: 20
|Created by: Aliensbrain Bot
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?
To answer this question, you need to understand the different backup formats used for database backups.
Option A) backup set only - This option is correct because a backup set is a logical backup format that can be written to tape. It includes all the necessary data and metadata to restore the database.
Option B) image copy only - This option is incorrect because an image copy is a physical backup format that cannot be written directly to tape. It is a bit-for-bit copy of the database files and is typically used for faster recovery.
Option C) only user-managed backup - This option is incorrect because it does not specify a specific backup format. User-managed backup refers to the process of manually performing backups, but it does not specify the format.
Option D) both image copy and backup set - This option is incorrect because although both backup sets and image copies are valid backup formats, only the backup set can be used for writing to tape as specified in the question.
Option E) only incremental image copy backup - This option is incorrect because it specifies a specific type of backup (incremental image copy) rather than a format. Incremental backups only copy the changes made since the last backup and do not provide a full backup of the database.
Therefore, the correct answer is option A) backup set only. This option is correct because a backup set is a logical backup format that can be written to tape.
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?
Your application demands frequent connection and disconnection from the database. You have three listener processes those are listening for the database PROD. While settings up connect string using Oracle Enterprise Manager 10g Database Control, which two options would you select to balance the connection load across all the listener process? (Choose two)
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?
To recover the locally managed temporary tablespace after a tempfile has been deleted at the operating system level, the correct option is:
D. Drop and re-create the tablespace.
Explanation: When a tempfile is deleted at the operating system level, the associated locally managed temporary tablespace becomes unusable. To recover the tablespace, you need to drop and re-create it. This process involves dropping the existing tablespace and then creating a new tablespace with the same name.
Flashback the database (Option A) is not applicable in this scenario, as it is used to restore the database to a previous point in time.
Performing a point-in-time recovery (Option B) is not necessary in this case, as it is used to recover the database to a specific point in time.
Performing a full database recovery (Option C) is not required for a locally managed temporary tablespace recovery.
Using recovery manager (RMAN) to recover the database (Option E) is not applicable in this situation, as the issue is specific to the temporary tablespace.
Therefore, the correct answer is D. Drop and re-create 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?
To answer this question, you need to understand the concept of Automatic Shared Memory Management (ASMM) and the background processes involved in managing the memory component.
ASMM is a feature in Oracle Database that dynamically manages the size of the System Global Area (SGA) components, such as buffer cache, shared pool, and large pool. It automatically adjusts the sizes of these components based on the workload of the database.
The background process that ASMM uses to coordinate the sizing of the memory component is called Memory Manager (MMAN). The MMAN process is responsible for dynamically managing the memory allocation and deallocation within the SGA.
Let's go through each option to understand why it is correct or incorrect:
Option A) PMON - The Process Monitor (PMON) process is responsible for process recovery and cleaning up resources when a user process fails. It is not involved in coordinating the sizing of the memory component in ASMM.
Option B) SMON - The System Monitor (SMON) process performs recovery and cleanup operations during database startup and shutdown. It is not involved in coordinating the sizing of the memory component in ASMM.
Option C) MMNL - The Memory Monitor Light (MMNL) process is responsible for monitoring and managing the Automated Maintenance Tasks. It is not involved in coordinating the sizing of the memory component in ASMM.
Option D) MMAN - The Memory Manager (MMAN) process is responsible for coordinating the sizing of the memory component in ASMM. It dynamically manages the allocation and deallocation of memory within the SGA.
Option E) MMON - The Manageability Monitor (MMON) process is responsible for collecting and managing performance data for the Oracle database. It is not directly involved in coordinating the sizing of the memory component in ASMM.
The correct answer is Option D) MMAN. This option is correct because the Memory Manager (MMAN) process is the background process used by ASMM 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?