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

Is inner join same as self join?

1071

Does group by remove duplicates?

988

Is inner join faster than left join?

1131

Is primary key always clustered index?

956

Is primary key clustered index?

905

Can we rollback truncate?

954

Can delete statement be rollbacked?

943

Can we use distinct and group by together?

1003

Do we need to rebuild index after truncate?

981

What is the basic form of sql query?

891

Is sql sequential or random?

990

Why truncate is used in sql?

947

How many types of indexes are there in sql?

946

What are sql procedures?

971

What is dense_rank in sql?

925

Un-Answered Questions { Databases }

How to shutdown your 10g xe server?

1094

Discuss row chaining, how does it happen? How do you correct it?

504

Tell me the use of keyword with encryption. Create a store procedure with encryption?

968

Difference between hot backup vs. Cold backup?

953

What are transaction and its controls?

978

What is Tab Query Whats its advantage over Sql-Query

4511

What is type and rowtype in pl sql?

978

What is optimization and its types?

926

What is a transaction? Describe mysql transaction properties.

1045

explain normalization concept? : Sql dba

1005

Explain the various types of oracle report?

1026

Explain active/passive and active/active cluster configurations?

1023

How would you best determine why your MVIEW couldnt FAST REFRESH?

1849

Explain intimate shared memory(ism)

847

What is the purpose of cursors in pl/sql?

1087

For More Un-Answered { Databases } Questions Click Here