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

What is the query and subquery?

1090

What is the template in sql?

993

What is apply operator in sql?

1026

Do you have any idea about the tcl commands?

977

What is normalization according to you and explain its different levels?

966

Do you know the different ddl commands in sql?

1064

What are different types of database indexes?

1117

How to compare the top two records using sql?

1365

Why is the use of dbms recommended? Explain by listing some of its major advantages.

1703

What is the purpose of normalization in dbms?

1171

What are the different type of relationships in the dbms?

877

What is 3nf in the dbms?

909

What is 1nf in the dbms?

1062

What integrity rules exist in the dbms?

1039

What is the use of drop command and what are the differences between drop, truncate and delete commands?

1108

Un-Answered Questions { Databases }

What is user defined functions?

993

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

955

How do I do transactions/locking?

What is BCNF? How is it better than 2NF & 3NF?

1032

How to throw custom exception in Stored Procedure?

1058

What is data type in database?

1004

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1045

what are all types of user defined functions? : Sql dba

1053

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

1012

How many types of km's? And you what are the type's km are used in your project?

581

What are crud methods?

1044

What is meant by query optimization?

867

What data structure does mysql use?

1028

What kinds of responsibilities does a dba have in a database environment?

611

Why use stored procedures in sql server?

1029

For More Un-Answered { Databases } Questions Click Here