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

How many primary keys can a table have?

1057

Does truncate remove indexes?

1079

How can we find duplicate records in a table?

991

Can we insert data in view?

1008

How do I remove all records from a table?

1116

Why truncate is faster than delete?

1159

Are subqueries faster than joins?

1076

Does truncate free space?

1064

Can a foreign key be null?

1142

How do you respond to dementia behavior?

1015

Can we create clustered index without primary key?

1000

How many types of index are there?

1099

Is primary key an index?

1036

How do you optimize a query?

1058

Is natural join same as inner join?

984

Un-Answered Questions { Databases }

What is different type of rman backup?

709

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

What is the default server name for sql server?

1231

What is the library index called?

1109

How do you clear the screen in sql?

1122

How to delete existing rows in a table?

1246

What is flexfileds and use of flexfileds in odi?

630

How to download oracle database 10g xe?

1065

What are the data types in oracle?

1095

How index is implemented in oracle database?

1043

What mongodb is good for?

New concepts of sql server 2005 use in your project.

2401

What is postgres process?

938

What is the difference between delete and truncate command in dbms?

1061

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2673

For More Un-Answered { Databases } Questions Click Here