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?

1012

How to get a create statement for an existing table?

970

How to pass parameters to procedures?

1035

How to use "in" parameter properly?

1074

How to run create database statement again?

1160

How to run queries on external tables?

1050

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

1070

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 1573

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?

1119

What is a named program unit?

1088

Un-Answered Questions { Databases }

How do database connections work?

949

Are stored procedures precompiled?

989

Why is normalization important?

1032

How a Store Procedure called with a cursor out parameter.?

1020

what is index? : Sql dba

1008

How many types of literals are available in pl sql?

1119

What is prepare statement in mysql?

995

how can you pass values to-and-fro from foreign function?

What is primary key secondary key alternate key candidate key?

1037

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

What is ase database?

1022

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

593

What is mysql primary key?

980

What is pl sql block structure?

1044

What is cardinality in db?

1020

For More Un-Answered { Databases } Questions Click Here