Interview Questions and answers for Oracle, DBA, Developer Candidates. Greate for employers and employees.

This is a collection of FAQ for Oracle DBA on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collection are organized together to form a complete tutorial guide on creating a new database instance manually.

Advanced replication allows the simultaneous transfer of data between two or more Master Sites. Each Master Site is fully functional and doesn't depend on pulling updates from a central site. The example below is a modified version of that found at Underground FAQs. In this example replication is setup between two Master Sites, TSH1 and TSH2, with the TSH1 instance as the Master Definition site, making it responsible for the coordination of the replication process.

This is a collection of FAQ for Oracle DBA on creating indexes and managing indexes. The clear answers and sample scripts provided can be used as learning tutorials or interview preparation guides.

B*TREE Indexes improve the performance of queries that select a small percentage of rows from a table. As a general guideline, we should create indexes on tables that are often queried for less than 15% of the table's rows. This value may be higher in situations where all data can be retrieved from an index, or where the indexed columns can be used for joining to other tables.

Analytic Functions, which have been available since Oracle 8.1.6, are designed to address such problems as 'Calculate a running total', 'Find percentages within a group', 'Top-N queries', 'Compute a moving average' and many more. Most of these problems can be solved using standard PL/SQL, however the performance is often not what it should be. Analytic Functions add extensions to the SQL language that not only make these operations easier to code; they make them faster than could be achieved with pure SQL or PL/SQL.

In this Tip we show how to connect to an Oracle 9.2.0 database from the .NET Framework using C#, MDAC and ODBC

A collection of 19 FAQs on creating and managing tablespaces and data files. Clear answers are provided with tutorial exercises on creating and dropping tablespaces; listing available tablespaces; creating and dropping data files; setting tablespaces and data files offline; removing corrupted data files.