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)

In this mode, the monitored host is simply pushing data from itself to the system monitoring application.

This mode can work asynchronously.

By using this mode, the load of the monitoring system can be reduced.

By using this mode, the system monitor can do all the polling in whatever simple means are available.

Both (1) and (4)

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)

The group OSDBA has a specific name 'dba' for Unix user group.

For the member of the OSDBA group with the SYSDBA, the system privilege will be SYSDBA while connecting to the database.

For the member of the SYSOPER group with the SYSDBA, the system privilege will be SYSOPER while connecting to the database.

The CONNECT command fails in case of no member from the groups SYSDBA or SYSOPER found while connecting to the database.

All of the above

There must be sufficient memory available to start the oracle database instance.

There must be sufficient disk storage space must be available for the planned database.

The operating system privileges must be associated with a fully operational database administrator.

All of the above

Both (2) and (3)

The name of the password file

The password

The maximum number of distinct DBAs and OPERs

To check whether to overwrite existing file

Both (3) and (4)

SYSDBA authorizes ALTER DATABASE ARCHIVELOG.

SYSDBA authorizes DROP DATABASE.

SYSOPER privilege performs STARTUP and SHUTDOWN operations.

SYSOPER privilege authorizes ALTER DATABASE ARCHIVELOG.

All of the above

The database can be shutdown instantaneously by this clause.

After this clause, uncommitted transactions are not rolled back.

After this clause, the database implicitly disconnects all connected users.

All of the above

Both (1) and (3)