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

Explain the primary key?

820

Explain table queries and select queries. What are the main differences between the two?

849

What would happen if the both source and destination have the same name?

824

What do you mean by erd and its main elements?

798

Explain the index key?

805

Versions of softwares change everyday. In what format should I save my database so that different versions of ms access cab open it?

852

List different query types in microsoft access database

925

Explain the foreign key?

860

How will you create a updatecascade, deletecascade relation in ms-access? Explain with example.

807

What is microsoft access?

874

I am using the switchboard manager in ms access. I am getting an error message "there was an error executing this command." What could be wrong?

928

How would you open an ms access database that has been converted to a current version?

844

How would you import a sharepoint list?

809

How would you remodel an existing access database?

957

How does microsoft access database recover free space?

862

Un-Answered Questions { Databases }

Is pgadmin open source?

807

What is the difference between a check constraint and a rule?

1273

Can we join two tables without common column?

1026

What is transaction server implicit?

1023

What is extended stored procedures?

975

What is the main component of ms access database?

800

1. Difference between Lookup and join? 2. Difference between funnel and join? 3. What type of load you have used in your project? 4. What type of data warehouse schema you have fallowed in you project? 5. How many fact tables and dimension tables is their in project? 6. How do you kill the job process using windows environment? 7. Difference between sequence file and dataset? 8. What is delta load and subsequent load? 9. By using which stages you have implemented the SCD

1986

What is data file in computer?

972

What is number function in sql?

986

How to get month wise data in postgresql?

888

How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?

2805

What is use of @@ spid in sql server?

1225

What is best institute to Learn DotNET And SQL in chennai?

2185

Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?

543

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1403

For More Un-Answered { Databases } Questions Click Here