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

various types of joins

9 10369

what is the difference between UNION AND UNIONALL

4 13007

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2285

what are the things that you consider while creating indexes on partitioning tables?

1 4885

what happened to the global index when I truncate the data in one of the partition?

2043

what are the advantages of running a database in archive log mode?

2215

what are the advantages of running a database in NO archive log mode?

1 4255

what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 14347

how do u setup a replication site?

2008

what is a Nested Loop join?

2137

when do u go for hash partitioning?

1 3775

what is RAID technology?which is better RAID 0+1 OR RAID 5?

CSC,

2 16856

how do get database name at sql prompt?

3 7106

what is the scenario where you take the database to NoArchivelog mode?

2347

does the query needs a hint to access a materialized view?

1873

Un-Answered Questions { Databases }

What is difference between group by and having?

964

What are the properties of a primary key in DBMS?

972

How do database indexes work?

1024

Does toad work with postgres?

789

How is it different from a normal table?

1047

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

936

Which type of cursor is used to execute the dml statement?

970

What is server name sql?

1160

What is mutating error in pl sql?

1040

When would you prefer to have a minimum number of indexes?

925

How to connect Silverlight application to database?

1074

How to create a single index for multiple columns?

1049

What are the 5 databases?

875

What happens to the current transaction if the session is killed?

1005

Explain the difference between drop and truncate commands in sql?

1077

For More Un-Answered { Databases } Questions Click Here