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

Explain the term entity in dbms?

946

What is index hunting and how does it help in improving query performance?

2059

What do you understand by clause in sql?

1091

What are the differences between a dbms and rdbms?

1068

Explain the terms specialization and generalization.

1000

Explain the term entity set in dbms?

1196

Explain the term entity type in dbms?

1092

What are the different types of keys in the database?

999

Mention the different languages present in dbms

1008

What is sql and where is it used?

994

What do you understand by cursor?

999

How can you perform pattern matching in sql?

1044

What do you understand by intension and extension?

978

Mention the differences between unique key and primary key

1041

What is normalization and what are the different types of normalization?

1041

Un-Answered Questions { Databases }

What is database implementation?

979

Create table employee (eno int(2),ename varchar(10)) ?

1062

What is 2nf and 3nf?

1004

What port does sql server use?

1114

Which is the most used database?

989

What are advantages of ssrs or why we should use ssrs?

145

How do I connect to oracle database?

1205

What has stored procedures in sql and how we can use it?

1129

What is set transaction?

1094

You need to remove the affected rows and dashes. How would you do that?

1002

Explain what are the authentication modes in sql server?

1075

What schema means?

943

How do I view a table in sql?

1044

How do I run a sql query in pgadmin 4?

1004

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1079

For More Un-Answered { Databases } Questions Click Here