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?

1114

Does group by remove duplicates?

1039

Is inner join faster than left join?

1190

Is primary key always clustered index?

1023

Is primary key clustered index?

949

Can we rollback truncate?

998

Can delete statement be rollbacked?

984

Can we use distinct and group by together?

1055

Do we need to rebuild index after truncate?

1033

What is the basic form of sql query?

943

Is sql sequential or random?

1031

Why truncate is used in sql?

1003

How many types of indexes are there in sql?

983

What are sql procedures?

1022

What is dense_rank in sql?

986

Un-Answered Questions { Databases }

What is repeatable read?

1015

Which sql server is best?

992

How many control files should you have?

591

What is SQL Azure Data sync?

121

How do I add a column in postgresql?

849

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

610

what are the three command line utilities and what are their primary functions?

144

How will you make an attribute not process? : sql server analysis services, ssas

1089

How view is related to data independence?

981

how to decrement dates by 1 in mysql? : Sql dba

1017

What is a partition function in sql server?

1133

What is pl sql in oracle?

1041

Write a query to get maximum and second maximum in oracle?

1046

What are the different types of backups that exist?

1167

What is a tinyint?

958

For More Un-Answered { Databases } Questions Click Here