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

How to build data dictionary view an new database?

968

How to get a create statement for an existing table?

917

How to pass parameters to procedures?

983

How to use "in" parameter properly?

1010

How to run create database statement again?

1090

How to run queries on external tables?

996

What privilege is needed for a user to delete rows from tables in another schema?

1027

How to rename a column in an existing table?

983

How to view existing locks on the database?

1005

How much memory your 10g xe server is using?

1059

How to recover a dropped index?

1 1501

How to assign values to data fields in record variables?

979

How to create a new table by selecting rows from another table?

1030

How to create tables for odbc connection testing?

1025

What is a named program unit?

1030

Un-Answered Questions { Databases }

Is sql pronounced sequel or sql?

1222

Where are the settings stored for each instance in oracle?

1073

What is maximum size for an access database?

857

What is a benefit of using an after insert trigger over using a before insert trigger?

936

What is the difference between mdf and ndf files?

1071

What will happen non-clustered index will be created on clustered index?

998

Explain dml compiler?

985

What is difference between pls_integer and integer?

922

Have you created fact table and dimension tables?

601

Mention where does the clusterware write when there is a network or storage issue?

What command is used to delete the data from the table without deleting the table structure?

911

What is the port number for postgresql?

826

Does mongodb require a schema?

How do I run multiple versions of sybase on the same server?

810

Is mongodb open source?

For More Un-Answered { Databases } Questions Click Here