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

What is the default value of an integer data type in sql server 2005?

969

What are the different editions available in sql server 2000?

1073

Can a synonym name of a table be used instead of a table name in a select statement?

1065

How do I determine how many instances of sql server are installed on a computer?

1020

What does the on update no action do?

1036

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1039

What is the parse query button used for?

1050

What stored by the model?

1081

When is the use of update_statistics command?

1029

Does an index slow down updates on indexed columns?

989

What command would you use to add a column to a table in sql server?

1327

What is sql server 2000 work load governor?

1099

Are semicolons required at the end of sql statements in sql server 2005?

1011

How do I perform an unattended install of sql server 2000?

1107

What is nolock?

998

Un-Answered Questions { Databases }

What are different types of table joins?

1037

How would you choose between a clustered and a non-clustered index?

991

How to use "startup" command to start default instance?

1053

Why neo4j is used?

who developed informix?

What is rownum?

998

Differentiate between transaction type and transaction source? : oracle accounts receivable

1130

Tell about MOM Tool(Microsoft Operator Manager)?

1932

Explain what is a replica set?

What is query design?

918

What are tuples in sql?

1159

How do you go back in sql?

998

What kind of problems occurs if we do not implement proper locking strategy?

1420

what is self join and what is the requirement of self join? : Sql dba

1160

Why we use cross join?

979

For More Un-Answered { Databases } Questions Click Here