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 10309

what is the difference between UNION AND UNIONALL

4 12980

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

2266

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

1 4859

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

2027

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

2205

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

1 4234

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

2 14328

how do u setup a replication site?

1991

what is a Nested Loop join?

2120

when do u go for hash partitioning?

1 3759

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

CSC,

2 16839

how do get database name at sql prompt?

3 7091

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

2333

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

1864

Un-Answered Questions { Databases }

What is microsoft t sql?

951

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1055

What is the latest mysql?

963

What is the difference between truncate and delete?

1198

What is default value database?

1018

How many types of normalization? What is the use of it?

1142

What is tns entry?

1162

What is n tier architecture with example?

768

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

2015

How do you insert a table?

932

What is sql and where is it used?

951

What are the critical issues you have resolved in your company

2246

Can you use order by when defining a view?

980

What function does a database engine serve in the sql server?

1043

How do I start tns listener?

1051

For More Un-Answered { Databases } Questions Click Here