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

Oracle (3253)
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

What is group by in sql?

1125

Why we use triggers in mysql?

1037

What is sql procedures and functions?

1071

Why trigger is used in sql?

1015

What is rownum in sql?

1092

Why self join is used in sql?

1029

What is the difference between count 1 and count (*) in a sql query?

1053

What is the use of a view in sql?

1029

What is clustered index sql?

1030

What is the trigger in sql?

1002

What are sql queries used for?

1079

What are sql triggers used for?

1035

What is cte sql?

1052

What is sql indexing?

1062

What is a full join sql?

1104

Un-Answered Questions { Databases }

whats new about truncate in sql server 2008?

2553

What is indexed view? How to create it?

1069

What is 2nf and 3nf?

1001

explain about light scans in informix?

126

What is native sql query?

1075

What are commit and rollback in sql?

1170

HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1472

What is row level locking in mysql?

1071

Explain the difference between procedure and function in mysql?

1038

What is materialized view. What are different methods of refresh?

1438

What is the database development process?

1265

Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

1044

How does sharding work with replication?

What does currency type mean in database?

1248

How do I find sql server instance name?

1008

For More Un-Answered { Databases } Questions Click Here