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 the purpose of self join?

1 1047

What is the maximum length of an alert name?

1 1047

What is a primary index?

1 982

What is query optimization process?

1 1093

What is a non equi join?

1 1036

What is a db view?

1 959

What is the use of commit?

1 1065

What is a covering index?

1 1054

What is difference between count (*) and count 1?

1 987

What is normalization process?

1 1251

What is difference between rownum and row_number?

1 1028

What is meant by indexing files?

1 1105

What is candidate key with example?

1 1041

What is the purpose of optimization?

1 1071

What is the full form of ddl?

1 979

Un-Answered Questions { Databases }

Can we do dml on views?

1024

Is it possible to have clustered index on separate drive from original table location?

1026

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

How to start an oracle instance?

1086

Can sql servers link to other servers like oracle?

900

How many concurrent programs you have customized, can you name some of them?

Does view occupy space?

998

What is the current version of postgresql?

1144

What are the two main functions of queries in databases?

1509

Disadvantages of the indexes?

1205

What are wait types?

1219

what are aggregate and scalar functions? : Sql dba

1116

How to export data from database and import into another?

978

When should you use an instead of trigger?

1033

Have you created fact table and dimension tables?

694

For More Un-Answered { Databases } Questions Click Here