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

Is inner join same as self join?

1167

Does group by remove duplicates?

1092

Is inner join faster than left join?

1250

Is primary key always clustered index?

1063

Is primary key clustered index?

992

Can we rollback truncate?

1049

Can delete statement be rollbacked?

1031

Can we use distinct and group by together?

1103

Do we need to rebuild index after truncate?

1098

What is the basic form of sql query?

993

Is sql sequential or random?

1086

Why truncate is used in sql?

1043

How many types of indexes are there in sql?

1040

What are sql procedures?

1084

What is dense_rank in sql?

1037

Un-Answered Questions { Databases }

What happens if the constraint name is left out of a constraint clause?

576

Is google a database?

1258

What are the several methods to enter data in ms access 2013?

855

Explain what is cte (common table expression)?

1184

What is standby servers? Explain types of standby servers.

1054

What are the string functions in sql?

1022

What is a recursive stored procedure in sql server?

1243

What is dbms with example?

1104

Sql server reporting services vs. Crystal reports.

140

How do you create a table in microsoft access?

834

what's new in sql server 2016?

1003

Explain features of analysis services?

1079

What is the default table size in sybase?

949

How do you modify a trigger?

981

Can a unique key be a foreign key?

881

For More Un-Answered { Databases } Questions Click Here