Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

Patni,

2622

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2814

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 9772

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

Explain about query and reporting.

2091

How to combine two function together?

2129

How to use timestamp datatypes

2039

How to replace not in with not exist?

2089

Explain the family trees and connection by clause.

1 4386

Write the difference between case version and decode version.

2 4811

Write short notes on manual refreshes.

2734

How to create an external table.

1 4083

How to customize error conditions.

2150

How to generate OIDS

2255

How to use online Backups?

2202

Un-Answered Questions { Databases }

What does the option psql -l of PostgreSQL display?

1447

What is sql clause?

1051

how to extract a unit value from a date and time? : Sql dba

990

What are the features of Embedded SQL

1129

Why is stored procedure faster than query?

961

What are two types of data in a database environment?

917

What is sql indexing?

1010

What is postmaster pid file in postgres?

961

What are property classes?

How to find Duplicate Records In table?

1018

List some alternatives to mongodb?

What information is maintained within the msdb database?

982

Is mongodb good for storing images?

Please explain joins in oracle?

1062

How to store only time; not date and time?

1020

For More Un-Answered { Databases } Questions Click Here