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

1168

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

1027

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

1016

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

1073

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

989

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

1064

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

1051

what are tables and fields? : Sql dba

1114

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

1064

define data blocks ? : Sql dba

1050

what is user defined functions? : Sql dba

1094

what is msql? : Sql dba

1046

discuss about myisam key cache. : Sql dba

1078

what is 'mysqlcheck'? : Sql dba

1075

what is rollback? : Sql dba

1195

Un-Answered Questions { Databases }

What is parameterized cursor in oracle?

1237

What is the difference between form and report in ms access?

987

Why does reading require write privileges on database file?

944

What are constraints in microsoft sql server?

1227

What is postmaster pid file in postgres?

1005

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1146

Explain csv tables.

1073

What sql does mysql use?

1002

How do I shrink an ldf file?

1050

What is delimiter in pl sql?

1107

What are the advantages of using Query Strings?

1117

Does truncate need commit?

1012

Name the different triggers supported by oracle reports and their firing order.

1142

How do you bind variables in pl sql?

1172

What are some of the important security features of a dbms?

938

For More Un-Answered { Databases } Questions Click Here