Tag: technology

Questions Related to technology

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

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

You want to administer your database servers, which are running on different host machines using the web enabled grid control interface. You have configured the agent in the host machines. You have started Oracle database10g grid control utility on your machine. Which two additional components would you configure to achieve this objective?

Application server control.
Oracle Management service.
Oracle enterprise manager repository.
Oracle enterprise manager database control.

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
915
916
917
918
919
920
921
922
923
…
3670
3671
Next →