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?

1009

How to get a create statement for an existing table?

969

How to pass parameters to procedures?

1034

How to use "in" parameter properly?

1071

How to run create database statement again?

1154

How to run queries on external tables?

1046

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

1066

How to rename a column in an existing table?

1035

How to view existing locks on the database?

1053

How much memory your 10g xe server is using?

1103

How to recover a dropped index?

1 1570

How to assign values to data fields in record variables?

1035

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

1102

How to create tables for odbc connection testing?

1117

What is a named program unit?

1082

Un-Answered Questions { Databases }

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

1026

What are exact numeric data types in ms sql server?

1076

What do you think about pl/sql?

1030

Does mongodb store data in memory?

List out the oracle forms configuration files?

1072

Distinguish between commit and rollback?

961

What format should my database be saved in to allow different versions of Microsoft Access to open the database?

887

Is it possible to configure the cache size for mmapv1 in mongodb?

What is the maximum no of columns a table can have?

910

How do you delete a data source?

1007

Can excel and access work together?

827

How we can apply bit m a podded index in ms access

2097

Tell me about standby database? What are some of the configurations of it?

568

What are the instances when triggers are appropriate?

979

What is sql and db2?

1003

For More Un-Answered { Databases } Questions Click Here