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 a ‘namespace’?

Are null values allowed?

How does sharding work with replication?

When using replication, can some members use journaling and others not?

If a ‘movechunk’ fails, is it necessary to cleanup the partially moved docs?

What is a master or primary?

When an object attribute is removed, is it deleted from the store?

How do I do transactions/locking?

Should you start out with sharded or with a non-sharded mongodb environment?

What happens when a shard is down or slow when querying?

what is cte? : Mysql dba

1004

what is database white box testing? : Mysql dba

1066

what is the default port for mysql server? : Mysql dba

1112

can you tell the order of sql select statement? : Mysql dba

967

what is database black box testing? : Mysql dba

1181

Un-Answered Questions { Databases }

What are materialized views & where do we use them? What is a materialized view log?

What does it mean to be case sensitive?

1068

How do I restore a mysql database?

1155

How do the blocker processes exist internally in sybase?

959

how to solve cardinality in dbms...many to many ralationships

1769

What is fill factor and pad index?

1069

How to export your own schema?

1057

What type of Index will get created after executing the above statement?

1156

What objects are present in the table msysobjects of microsoft access database?

891

Is sqlexception checked or unchecked?

1021

What are the advantages of a procedure?

977

Explain the different types of constraints in dbms?

1082

what is extent in informix?

What is cached report?

150

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1257

For More Un-Answered { Databases } Questions Click Here