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

How many primary keys can a table have?

1009

Does truncate remove indexes?

1033

How can we find duplicate records in a table?

947

Can we insert data in view?

963

How do I remove all records from a table?

1074

Why truncate is faster than delete?

1111

Are subqueries faster than joins?

1021

Does truncate free space?

1010

Can a foreign key be null?

1090

How do you respond to dementia behavior?

970

Can we create clustered index without primary key?

963

How many types of index are there?

1040

Is primary key an index?

991

How do you optimize a query?

999

Is natural join same as inner join?

941

Un-Answered Questions { Databases }

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

961

What is replication and database mirroring?

1047

Explain insert into select statement?

956

What is a design view?

924

How to throw custom exception in Stored Procedure?

1044

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

145

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1061

Does oracle partitioning improve performance?

992

Does varchar need length?

992

Can we create table in function?

964

Does facebook use graph database?

1033

What is sql server transaction log file?

1054

What is a partition key?

954

how to create a scrollable cursor with the scroll option? : Sql server database administration

1092

What are ddl (data definition language) statements for tables in ms sql server?

1104

For More Un-Answered { Databases } Questions Click Here