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 service-specific middleware?

1007

Explain dml (data manipulation language)?

925

What are the ways to tune reporting services?

1010

How do you call a stored procedure from jdbc?

947

Define data, entity, domain and referential integrity?

1114

Explain atomicity and aggregation?

1005

Which two can be implemented as a centrally located logical architecture?

930

What is data sparsity and how it effect on aggregation?

948

How to lock records in a table?

1014

What is building blocks of client/server?

1114

Explain the hierarchical database?

1006

Explain data independence?

1045

Explain dml compiler?

1059

How to prevent firebird.log file from filling up the disk partition?

932

How to unzip a file in ssis?

1072

Un-Answered Questions { Databases }

Does truncate require commit?

979

Describe types of sql statements?

1064

Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

623

Is postgresql is nosql?

889

How to store pictures on to the database?

982

What are the three levels of data abstraction?

1104

Why mongodb data files so large (in size)?

What is trace flag definitions in sybase?

934

What does it mean to be in union?

941

what is the difference between cluster and non cluster index? : Sql dba

1036

What is a coalesce function?

1201

You need to manipulate varbinary columns in sybase. How would you do that?

969

What are the types of tables in database?

993

Explain the term generalization.

987

Is it possible to configure the cache size for mmapv1 in mongodb?

For More Un-Answered { Databases } Questions Click Here