Interview Questions

A Control file records the physical structure of the database. It contains the following information. Database Name ,Names and locations of a database’s files and redolog files. Time stamp of database creation.

Mention the mistake and be honest about it, but always make sure that you follow it up with what you learnt from that episode and the improvements it has brought to your efficiency.

Variable costs are expenses that vary in proportion to the amount of goods or services that a business produces. 

Examples of variable cost include labor, packaging and raw materials.

- Installing and upgrading the Oracle Server and application tools.

- Allocating system storage and planning future storage requirements for the database system.

- Managing primary database structures (tablespaces)

- Managing primary objects (table, views, indexes)

- Enrolling users and maintaining system security.

- Ensuring compliance with Oracle license agreement

- Controlling and monitoring user access to the database.

- Monitoring and optimizing the performance of the database.

- Planning for backup and recovery of database information.

- Maintain archived data on tape

- Backing up and restoring the database.

- Contacting Oracle Corporation for technical support.

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Use the buffer cache advisory over a given workload and then query the v$db_cache_advice table. If a change was necessary then I would use the alter system set db_cache_size command.

A universe is a business-oriented mapping of the data structure found in databases: tables, columns, joins, etc. It can represent any specific application, system, or group of users. For example, a universe can relate to a department in a company such as marketing or accounting.

In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis.

It is a single computer in a network reserved for serving the needs of the network.