• databases Online Quiz - 175
Back
0

databases Online Quiz - 175

Description: databases Online Quiz - 175
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Identify two tablespaces whose data files are so critical that only a closed recovery is possible?

technology databases

  1. USERS

  2. TOOLS

  3. UNDO

  4. INDEX

  5. SYSTEM

Show answer
Correct Option: C,E
Explanation:

To solve this question, the user needs to know about the concept of tablespaces and recovery methods in Oracle database.

Closed recovery is a type of database recovery method in which all the data files of the database are restored from a backup and then the redo logs are applied to bring the database to a consistent state. Closed recovery is required when the database is in a state of complete failure and no data is available in the memory structures.

Only those tablespaces whose data files are so critical that they cannot be recovered using an open recovery method require a closed recovery.

Now, let's go through each option and identify if it requires a closed recovery or not:

A. USERS: This tablespace contains the user's data. It does not require a closed recovery if it gets damaged because it can be restored using an open recovery method.

B. TOOLS: This tablespace contains the database tools data. It does not require a closed recovery if it gets damaged because it can be restored using an open recovery method.

C. UNDO: This tablespace contains the undo data. It does not require a closed recovery if it gets damaged because it can be restored using an open recovery method.

D. INDEX: This tablespace contains the database index data. It does not require a closed recovery if it gets damaged because it can be restored using an open recovery method.

E. SYSTEM: This tablespace contains the system data. It is critical to the functioning of the database. If its data files are damaged, a closed recovery is required to restore it from a backup.

Therefore, the correct answer is:

The Answer is: E (SYSTEM)

Data files of which three tablespaces can be recovered by performing an open recovery?

technology databases

  1. TEMP

  2. UNDO

  3. INDEX

  4. SYSAUX

  5. SYSTEM

Show answer
Correct Option: A,C,D

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?

technology databases

  1. It creates the pointer file

  2. It creates the base directory

  3. It creates the inventory pointer file

  4. It creates the oracle user for installation.

  5. It modifies the UNIX kernel parameters to match oracle’s requirements.

Show answer
Correct Option: C

You want to perform a backup of your database to a tape. Which backup format can you use?

technology databases

  1. backup set only

  2. image copy only

  3. only user-managed backup

  4. both image copy and backup set

  5. only incremental image copy backup

Show answer
Correct Option: A

AI Explanation

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?

technology databases

  1. uses undo data for roll forward

  2. uses flashback log for recovery

  3. uses online redo logs to roll back

  4. uses undo data to roll back the transaction

  5. uses recovery managers (RMAN) to roll back.

Show answer
Correct Option: D

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?

technology databases

  1. Group 2 is the active group

  2. Group 2 is the current group

  3. Database is in the MOUNT stage

  4. Group 2 has been already archived

Show answer
Correct Option: D

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?

technology databases

  1. increase the undo retention

  2. create more undo segments

  3. create another undo tablespace

  4. increase the size of the undo tablespace.

Show answer
Correct Option: D

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)

technology databases

  1. Use only the first address.

  2. Try one address selected at random.

  3. Try each address, in order, until one succeeds.

  4. Try each address, randomly, until one succeeds.

Show answer
Correct Option: B,D

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

AI Explanation

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.

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

AI Explanation

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?

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

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
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions