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?

1091

Can two tables share the same primary key?

987

Can a table have 2 foreign keys?

965

What is meant by datasource?

988

How do I make a resultset scrollable?

1018

Is resultset an interface?

1042

What is the meaning of resultset type_scroll_insensitive?

996

What is difference between createstatement and preparedstatement?

1182

Which is faster statement or preparedstatement?

1003

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

1118

What is the return type of executeupdate ()?

957

What is create statement?

1011

What program is used to store the data source file?

1010

What is a data source file?

1028

Un-Answered Questions { Databases }

What is difference between mysql mysqli and pdo?

1041

How does distributed database work?

1042

how to generate an auto incremental number in a ssis package?

1071

Explain a join?

1128

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

1039

if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2129

What privilege is needed for a user to create indexes in oracle?

1090

Why it is recommended to avoid referencing a floating point column in the where clause?

1019

What is plan freezing?

1021

What methods is used to commit the changes made in DataSet object?

1112

What is row level locking in access?

940

Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

2992

What are the advantages and disadvantages of views in the database?

1123

Can group functions be used in the order by clause in ms sql server?

1071

What is meant by truncate in sql?

1111

For More Un-Answered { Databases } Questions Click Here