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

Is left join faster than join?

985

Does inner join remove duplicates?

888

Can we rollback after truncate?

982

Can we create a trigger on view?

844

Does truncate release storage space?

1015

Are views faster than queries?

923

Can we perform dml on view?

976

How does a trigger work?

990

Can we insert delete data in view?

899

How does a covering index work?

907

Can we have two clustered index on a table?

968

How many types of primary keys are there?

980

Can we insert data into view?

850

How do you define a foreign key?

941

Can we join tables without foreign key?

909

Un-Answered Questions { Databases }

What is difference between standardization and normalization?

1021

Can you explain different types of locks in sql server?

913

Explain the steps for this message could not delete from the specified tables?

796

What are schema-level triggers?

1047

What is field with example?

872

How to loop through returning rows?

975

What is stored in a database?

902

What does Master database contains?

1085

Write short notes on manual refreshes.

2677

What do you understand by the term 'normalization'?

620

Difference between bind parameter and lexical parameter.

What is openedge rdbms?

918

How to find table creation date in postgresql?

767

Explain the process of recievables in oracle financials. : oracle accounts receivable

1107

How to select some columns from a table in oracle?

1005

For More Un-Answered { Databases } Questions Click Here