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

1002

what is database white box testing? : Mysql dba

1059

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

1110

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

959

what is database black box testing? : Mysql dba

1179

Un-Answered Questions { Databases }

How can I create database in excel?

965

What is the Cdc?

757

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

2024

What is the use of aggregate functions in oracle?

1077

What is ms sql server triggers?

1075

What is rank in database?

943

What is db flush?

963

How to defragment indexes with alter index ... Reorganize?

1146

What is exporting and importing utility?

1150

How do you connect MySQL database with PHP?

1039

How do I view a script in sql server?

1092

What is a with(nolock)?

1032

How to find second highest salary from a table?

1065

What is tuple in rdbms?

1200

What is dbms language?

988

For More Un-Answered { Databases } Questions Click Here