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?

1053

Does inner join remove duplicates?

940

Can we rollback after truncate?

1031

Can we create a trigger on view?

895

Does truncate release storage space?

1075

Are views faster than queries?

992

Can we perform dml on view?

1044

How does a trigger work?

1067

Can we insert delete data in view?

950

How does a covering index work?

959

Can we have two clustered index on a table?

1025

How many types of primary keys are there?

1036

Can we insert data into view?

900

How do you define a foreign key?

1002

Can we join tables without foreign key?

962

Un-Answered Questions { Databases }

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1066

What is ms access and its features?

852

List some alternatives to mongodb?

Explain the purpose of %type and %rowtype data types with the example?

994

How to dump a table from a database.

1019

Is microsoft access important?

896

What are the types of index in sql?

1069

What is a rownum?

976

What are the different types of cursor?

1096

How do I completely remove sql server instance?

1100

What is dynasets in ms access?

879

What is pdo database?

940

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

921

what is objecld composed of?

How can we optimize stored procedure?

951

For More Un-Answered { Databases } Questions Click Here