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

Enlist some predefined exceptions?

1073

What do you mean by query optimization?

1016

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1176

What do you mean by stored procedures? How do we use it?

1007

Difference between truncate, delete and drop commands?

1092

How do you add a column to a table?

1070

What is a table?

1028

What is the syntax to add a record to a table?

1103

What is the mutating table and constraining table?

1043

How to select random rows from a table?

1088

What are properties of the transaction?

1008

Why is %isopen always false for an implicit cursor?

1124

What is normalization? How many normalization forms are there?

1095

When do we use triggers?

1095

What are the possible values for the boolean data field?

982

Un-Answered Questions { Databases }

What is instance in dbms?

885

List the different types of columns in oracle reports.

1012

What is sql server profiler trace data file?

1121

What is snowflake sql?

1085

How to list all user defined functions in the current database?

1060

Where the database is stored in mysql?

973

What type of database is neo4j?

What is reference section?

1016

Can a table have 2 primary keys?

994

Explain database normalization?

1239

how to get a list of all tables in a database? : Sql dba

991

How can i Relate Tables in SSIS

1095

What is a system tablespace?

1098

Can we use mongodb with java?

what are the different tables present in mysql? : Mysql dba

1024

For More Un-Answered { Databases } Questions Click Here