Database Management Systems

It is used to collect, process, and maintain performance statistics for problem detection and self-tuning purposes

It is used to analyse the information collected by the AWR for possible performance problems with the Oracle database.

It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.

It provides end-to-end application tracing.

Both (1) and (2)

Database statistics

Operating system statistics

Application statistics

Network statistics

All of the above

It allows a quick and efficient technique for optimizing SQL statements.

It collects, processes and maintains performance statistics for problem detection.

It provides advice on materialized views, indexes, and materialized view logs.

It analyses the information from the Automatic Workload Repository (AWR) for possible performance problems with the Oracle database.

Both (1) and (3)

Latch contention

Slow physical I/O

Excessive CPU usage

All of the above

Both (2) and (3)

It considers allocation of memory to database structures.

It determine the I/O requirements of different parts of the database.

It tunes the operating system for optimal performance of the database.

All of the above

Both (2) and (3)

Data consistency

Operating system workload

Reduced availability

All of the above

Both (2) and (3)

It checks the available memory to the oracle instances.

It defines the logical storage structure of the database.

It also checks, how many disk drives are available to oracle and its databases.

All of the above

Both (1) and (3)

Configuration of the data

Performance of the data

Data accessibility

All of the above

Both (2) and (3)

To develop a back up and security of the database

The performance of the database.

The logical storage structures of the database.

The efficiency of backup and recovery procedures for the database

All of the above

It is a mediator mode between 'monitor-poll' and 'agent-push' mode.

In this mode, one or more processes in the monitoring system actually poll the system elements in some thread.

The Hybrid mode is useful when all monitoring mechanisms have not been implemented.

Both (1) and (2)

Both (1) and (3)

The data pushed in the to monitoring application asynchronously.

In this mode, the monitoring system's load can be reduced to simply accepting and storing data.

The logic for the polling cycle/options are not centralized at the system monitor.

All of the above

Both (2) and (3)

When this clause is applied, no new connection can be allowed further.

No client can be accessed after the completion of the transactions in the database.

'SHUTDOWN TRANSACTIONAL' command use for shutting down with transactional clause.

No new transactions allowed to be started after the statement is issued.

All of the above

The database can be controlled by the central computer after installation.

The database tools can be executed on client side.

The database administrator handled the tasks like installation of database application, front end tools with Oracle database server.

The oracle net components are not necessary to install to execute the database.

Both (3) and (4)

Backing up and restoring the database

Planning for backup and recovery of database information

Ensuring compliance with your oracle license agreement

All of the above

Both (1) and (3)

The password file must be created in password file authentication.

REMOTE_LOGIN_PASSWORDFILE can be changed without restarting the database.

In this authentication, the SYSDBA or SYSOPER system privilege grant to the user.

All of the above

Both (1) and (3)