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

Which tcp/ip port does sql server run on? How can it be changed?

1057

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1049

What is a file group?

1120

Does order by actually change the order of the data in the tables or does it just change the output?

1170

What is the definition for sql server 2000?

1114

What is identity?

1035

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1005

What are synonyms?

977

What is the default order of an order by clause?

1013

What are the authentication modes in sql server? How can it be changed?

1140

What is acid properties?

1128

Can we perform backup restore operation on tempdb?

1047

What is pivot and unpivot?

1033

What is dirty page?

991

What is extent? Types of extents?

1216

Un-Answered Questions { Databases }

What is a package in oracle?

1130

what is the difference between undefined value and null value? : Sql dba

1120

What is precedence constraint?

1003

What are information schema views?

1002

What is data type for image in mysql?

879

What is oracle thin client?

1041

What is postgresql? Explain the history of postgresql.

904

How to get help at the sql prompt?

1131

How we can compare two database data?

962

What are the features of Embedded SQL

1155

Does sql full backup truncate logs?

1037

What are the types of keys?

1016

What is integrity in sql?

1064

Why mongodb logging so many “connection accepted” events?

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

1203

For More Un-Answered { Databases } Questions Click Here