Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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

1 1172

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

1 1029

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

1 1016

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

1 1079

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

1 989

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

1 1064

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

1 1051

what are tables and fields? : Sql dba

1 1114

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

1 1066

define data blocks ? : Sql dba

1 1052

what is user defined functions? : Sql dba

1 1094

what is msql? : Sql dba

1 1048

discuss about myisam key cache. : Sql dba

1 1081

what is 'mysqlcheck'? : Sql dba

1 1077

what is rollback? : Sql dba

1 1197

Un-Answered Questions { Databases }

Why should you use or avoid select * statements?

1094

How efficient you are in oracle and SQL server?

1235

Do we need to rebuild index after truncate?

1114

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

Suppose database is running slow, what will you do?

2580

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2089

What is the primary use of the model database?

1141

Can you index views?

946

Can we use distinct and group by together?

1116

what is the command syntax for inserting a document?

What are the source of constraints?

994

what are all the common sql function? : Sql dba

1113

Why we use the openxml clause?

1059

Is primary key clustered index?

1001

Can delete statement be rollbacked?

1038

For More Un-Answered { Databases } Questions Click Here