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

Oracle (3253)
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

What are data resources?

967

What is data source document?

1093

Can two tables share the same primary key?

987

Can a table have 2 foreign keys?

965

What is meant by datasource?

990

How do I make a resultset scrollable?

1022

Is resultset an interface?

1042

What is the meaning of resultset type_scroll_insensitive?

999

What is difference between createstatement and preparedstatement?

1187

Which is faster statement or preparedstatement?

1006

What is the difference between executequery () and executeupdate ()?

1123

What is the return type of executeupdate ()?

957

What is create statement?

1016

What program is used to store the data source file?

1012

What is a data source file?

1031

Un-Answered Questions { Databases }

Do we need commit after truncate?

1138

Explain cursor as data base object?

1105

How do you insert a table?

973

What is the difference between migration and upgradation in sql server?

1156

What do you mean by merge in oracle?

1038

Where is sql database stored?

1043

how many layers of tcp/ip protocol combined of? : Sql server database administration

1062

Does sql server 2016 have ssms?

1007

Can we call a function containing dml statements in a select query?

1032

Is mongodb free on aws?

Explain the foreign key?

909

How do you determine the location of mysql data directory?

989

Write a query to find 5th highest amount paid from the customer table.

997

What are the advantages and disadvantages of using mysql?

1059

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4724

For More Un-Answered { Databases } Questions Click Here