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 are cursors? : Sql server database administration

1075

what's sql server? : Sql server database administration

1005

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1076

what is the system function to get the current user's user id? : Sql server database administration

1036

what's the maximum size of a row? : Sql server database administration

1103

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1034

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

994

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

959

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

950

what is database replicaion? : Sql server database administration

1207

tell me what is blocking and how would you troubleshoot it? : Sql server database administration

913

what purpose does the model database serve? : Sql server database administration

994

what are constraints? Explain different types of constraints? : Sql server database administration

1001

what is a schema in sql server 2005? : Sql server database administration

1039

what are different types of raid configurations? : Sql server database administration

1071

Un-Answered Questions { Databases }

Explain the blob datatype?

1084

What are the main features of couchdb?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2709

What are the advantages of myisam over innodb?

992

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

1016

What is difference between stored procedure and user defined function?

1123

How to connect a sql*plus session to an oracle server?

1142

How to check if a record exists in a mysql database php?

904

What is join and name different type of joins?

1060

Can you tell which of the following where clauses is faster?

919

What does it mean to manipulate data?

1012

What is deterministic in mysql?

989

Does table partitioning improve performance?

979

What is error ora-12154: tns:could not resolve the connect identifier specified?

1092

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1401

For More Un-Answered { Databases } Questions Click Here