What is the difference between db2pd and db2top?

Why do we need unmanaged node?

Discuss the advantages and disadvantages of hierarchical database management system in comparison with RDBMS. Discuss types of applications suitable for hierarchical DBMS and RDBMS.

What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache)

How to write script for export backup in shell.

Tell me any instance when your database encountered any problem. How you dealt with that problem.

Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?

What is simple replication and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?

How you spend a day as a DBA. Explain DBA activities in detail.

Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.A virtual index is created in a slightly different manner than the normal indexes. A virtual index has no segment pegged to it, i.e., the DBA_SEGMENTS view will not show an entry...

 The  related columns of the tables are called the cluster key.  The cluster key  is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

 It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary tablesUser objects (table,indexes,views etc.,)The server that access the database consists ofSGA  (Database  buffer,  Dictionary  Cache  Buffers, Redo log buffers, Shared...

This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex real-world entities such as customers and orders as single entities, called objects, in the database. You create object types using the CREATE TYPE ... AS OBJECT statement. You can replicate object...