Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3258)
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?

809

Does inner join remove duplicates?

739

Can we rollback after truncate?

811

Can we create a trigger on view?

719

Does truncate release storage space?

828

Are views faster than queries?

774

Can we perform dml on view?

776

How does a trigger work?

765

Can we insert delete data in view?

770

How does a covering index work?

735

Can we have two clustered index on a table?

799

How many types of primary keys are there?

773

Can we insert data into view?

723

How do you define a foreign key?

763

Can we join tables without foreign key?

739

Un-Answered Questions { Databases }

Define atomicity and aggregation.

829

What are the three types of database design?

791

Hi Can any one tell me what are the API's used in requisition import.

1732

In what script is snap$ created? In what script is the scott/tiger schema created?

2513

Explain the difference between two and three-tier architectures.

723

What is degree of Relationship type?

675

How will you add a new style in a table?

594

What does mongodb mean?

What is a schema in oracle?

807

What is the use of procedure in mysql?

710

What is procedure cache and data cache in sybase?

640

What is a driver in programming?

747

What is the user of Primary key?

779

The select into statement is most often used to create backup copies of tables or for archiving records?

829

What is the basic form of sql query?

723

For More Un-Answered { Databases } Questions Click Here