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 difference between a having clause and a where clause? : Sql dba

1087

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

975

what is the functionality of the function htmlentities? : Sql dba

965

what are the differences between require and include, include_once and require_once? : Sql dba

1022

how to create a new view in mysql? : Sql dba

937

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

1002

what is online transaction processing (oltp)? : Sql dba

994

what are tables and fields? : Sql dba

1055

can sql servers linked to other servers like oracle? : Sql dba

1009

define data blocks ? : Sql dba

1000

what is user defined functions? : Sql dba

1035

what is msql? : Sql dba

989

discuss about myisam key cache. : Sql dba

1021

what is 'mysqlcheck'? : Sql dba

1015

what is rollback? : Sql dba

1111

Un-Answered Questions { Databases }

please explain.. DB architecture ...

2023

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1070

What are the 3 main types of search queries?

839

Where can you find the error log information? : sql server database administration

1026

How do you exit in sql?

1110

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

2224

Why are aggregate functions called so?

947

Explain table valued parameters in sql server? Why tvp used?

1019

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169

What are different types of statements that are supported by sql?

1047

What is surrogate key? : sql server analysis services, ssas

1109

Why use view instead of a table?

953

How to find the size of database?

1038

What is the difference between the application object and session object?

1068

Define compound operators?

916

For More Un-Answered { Databases } Questions Click Here