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

How to create a user name in a database?

1064

What are indexes in ms sql server?

1075

What are unicode character string data types in ms sql server?

1273

What are the mathematical functions supported by sql server 2005?

1083

How to update existing rows in a table?

1 1643

How to perform key word search in tables?

973

How to display a past time in days, hours and minutes?

1035

How to query multiple tables jointly?

1005

How to get the number of affected rows?

1017

How to insert data into an existing table?

996

How to include date and time values in sql statements?

1102

How to include text values in sql statements?

1053

How to loop through returning rows?

1048

How to drop an existing table?

1022

How to insert data with null values?

1050

Un-Answered Questions { Databases }

Is mongodb better than other sql databases? If yes then how?

what is the difference between a having clause and a where clause? : Sql dba

1104

What are the indexing capabilities of neo4j?

What is database isolation in sql server? : sql server database administration

1121

What is normalization? Describe its different types.

1119

I am getting error "no communication channel" after changing the domain name? What is the solution?

605

Does an index slow down updates on indexed columns?

986

what are the differences between an exclusive lock and a shared lock?

1006

Why do not you use gnu autoconf or scons for building?

957

what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?

1070

How to find out what is the default collation in a database?

1139

What are the basic components of notification services?

1093

List the advantages of access database ovr oracle database.

815

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2089

What is ase database?

1027

For More Un-Answered { Databases } Questions Click Here