Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3258)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3328)
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?

810

Does group by remove duplicates?

763

Is inner join faster than left join?

896

Is primary key always clustered index?

755

Is primary key clustered index?

701

Can we rollback truncate?

733

Can delete statement be rollbacked?

741

Can we use distinct and group by together?

796

Do we need to rebuild index after truncate?

718

What is the basic form of sql query?

693

Is sql sequential or random?

786

Why truncate is used in sql?

730

How many types of indexes are there in sql?

738

What are sql procedures?

781

What is dense_rank in sql?

718

Un-Answered Questions { Databases }

How do you trace the traffic hitting a sql server?

827

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

977

What do you understand by intension and extension?

665

Where the sql database files are stored?

717

Why do we need sharding?

747

What is subquery in sql?

755

How does stuff differ from the replace function?

759

Explian rowid, rownum? What are the psoducolumns we have?

772

What are the neo4j features?

How to generate random numbers with the rand() function in ms sql server?

779

Can mongodb store structured data?

What is collation?

902

What is snapshot replication?

798

Does group by sort data?

684

Does a full backup include transaction log?

703

For More Un-Answered { Databases } Questions Click Here