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?

965

Does truncate remove indexes?

978

How can we find duplicate records in a table?

904

Can we insert data in view?

901

How do I remove all records from a table?

1042

Why truncate is faster than delete?

1062

Are subqueries faster than joins?

957

Does truncate free space?

953

Can a foreign key be null?

1037

How do you respond to dementia behavior?

934

Can we create clustered index without primary key?

911

How many types of index are there?

979

Is primary key an index?

956

How do you optimize a query?

943

Is natural join same as inner join?

878

Un-Answered Questions { Databases }

Is microsoft access still used?

823

How do I connect to a postgresql database remotely?

775

What happens if null values are involved in string operations?

935

What is the definition for sql server 2000?

1048

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1061

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1879

What is sql azure database?

206

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1904

Explain constraining triggers.

1051

What is a initialization parameter file in oracle?

996

What is enter substitution variable in oracle?

1001

What advantages does DBMS have over traditional file systems?

999

What are the types of views in sql?

1052

What is order by clause?

877

How do I restore a mysql database dump file in linux?

927

For More Un-Answered { Databases } Questions Click Here