Identify two tablespaces whose data files are so critical that only a closed recovery is possible?
USERS
TOOLS
UNDO
INDEX
SYSTEM
Data files of which three tablespaces can be recovered by performing an open recovery?
TEMP
SYSAUX
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?
It creates the pointer file
It creates the base directory
It creates the inventory pointer file
It creates the oracle user for installation.
It modifies the UNIX kernel parameters to match oracle’s requirements.
You want to perform a backup of your database to a tape. Which backup format can you use?
backup set only
image copy only
only user-managed backup
both image copy and backup set
only incremental image copy backup
One user session was terminated abnormally in the middle of a transaction What does oracle database do to recover it?
uses undo data for roll forward
uses flashback log for recovery
uses online redo logs to roll back
uses undo data to roll back the transaction
uses recovery managers (RMAN) to roll back.
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?
Group 2 is the active group
Group 2 is the current group
Database is in the MOUNT stage
Group 2 has been already archived
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?
increase the undo retention
create more undo segments
create another undo tablespace
increase the size of the undo tablespace.
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)
Use only the first address.
Try one address selected at random.
Try each address, in order, until one succeeds.
Try each address, randomly, until one succeeds.
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?
Flash back the database
Perform a point-in-time recovery.
Perform a full database recovery.
Drop and re-create the tablespace.
Use recovery manager (RMAN) to recover the database.
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)
Guarantee undo retention
Add one more redo log group.
Configure an appropriate undo retention interval.
Size the UNDO tablespace appropriately.
Size the SYSTEM tablespace appropriately.
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?
audit trail
alert log file
user trace file
online trace file
background trace file.
What advantage would you get if you increase the length of the time during which the undo information would be restored in the database
roll back of large transaction
roll forward to redo a transaction
data concurrency for large updates
read consistency for long running transactions.
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?
Set the SESSION to 1 in the parameter file.
Grant SINGLE SESSION privileges to all of the users.
Set SESSION_PER_USER to 1 in user’s profile.
Grant RESTRICTED SESSION to all of the database users.
Create a role with SINGLE SESSION privilege and assign the role to users.
Where do you find the information about missing redo log file?
trace file
control file
event viewer
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?
Until the last commit.
Cannot be recovered.
Until the last offline backup.
Until the beginning of the last transaction.
Which background process does Automatic Shared memory Management use to coordinate the sizing of the memory component?
PMON
SMON
MMNL
MMAN
MMON
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?
Enable instance failover
Configure shared server
Enable database failover
Enable connect-time failover
Enable Transparent Application Failover
In oracle 10g, which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?
The analysis tool doesn’t provide output for the performance of SQL statement
The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.
The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.
The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.
In oracle 10g, which statement regarding the usage of redo log file during instance recovery is true?
Transactions are rolled back using redo log files.
Transactions are rolled forward using redo log files.
Transactions are rolled back using redo log files and archived log files.
Transactions are rolled forward using redo log files and rolled back using redo log files
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?
USER_DUMP_DEST
CORE_DUMP_DEST
ALERT_LOG_DEST
BACKGROUND_DUMP_DEST
ALERT_DUMP_DEST
