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 are the different mysql database engines?

1242

What are aggregate functions in mysql?

1 1441

Explain unique key in sql.

1066

How to use distinct and count in sql query? Explain

1088

What is the difference between having and a where in sql?

1156

Explain the components of sql?

1113

Explain normalization and what are the advantages of it?

1005

Explain clause in sql?

1077

What are the advantages of sql? Explain

1158

Explain foreign key in sql?

1090

What is a primary key? Explain

1031

Explain the difference between drop and truncate commands in sql?

1118

Write a query to find the names of users that begin with "um" in sql?

1050

Explain scalar functions in sql?

1109

What is sql and explain its components?

1122

Un-Answered Questions { Databases }

What are the difference between “where” and “having” clause in sql server?

1139

Is there any restriction on the use of union in embedded sql?

1205

How to place comments in pl/sql?

1219

Can we write ddl statements in functions?

1186

Why is mongodb called mongodb?

What is a synonym? What are its various types?

1179

What are the extra roles available in msdb? : sql server security

1187

What is the difference between instance recovery and crash recovery?

Explain the term entity type in dbms?

1092

How to count groups returned with the group by clause in ms sql server?

1149

What is bulk compiling in pl/sql.?

1197

What is isql in sybase?

953

Is oracle a programming language?

1045

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1487

What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.

1941

For More Un-Answered { Databases } Questions Click Here