Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology 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?

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

trace file
audit trail
control file
alert log file
event viewer

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

PMON
SMON
MMNL
MMAN
MMON

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
134
135
136
137
138
139
140
141
142
…
486
487
Next →