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?

946

Can we insert data in view?

962

How do I remove all records from a table?

1073

Why truncate is faster than delete?

1109

Are subqueries faster than joins?

1020

Does truncate free space?

1009

Can a foreign key be null?

1090

How do you respond to dementia behavior?

969

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?

998

Is natural join same as inner join?

940

Un-Answered Questions { Databases }

what are user defined datatypes and when you should go for them? : Sql server database administration

1019

How do you know if sql server is running on your local system?

1043

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

1931

What does a dba stand for?

579

Explain the difference between control flow and data flow?

994

What is sql server locking?

992

What is sequence in sql?

1015

Explain the table term used in database.

1037

Is it possible to remove old files in the movechunk directory?

How to create new databases with "create database" statements?

1019

Explain the rollback statement?

1009

In which language mysql has been written?

1336

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

910

Explain what is public role in sql server?

1135

What is pdo in mysql?

933

For More Un-Answered { Databases } Questions Click Here