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

Difference between 2NF &3NF ?

Cap Gemini,

1084

What will happen when a Rollback statement is executed inside a trigger?

Flextronics, Hexaware,

1 1971

What do you mean by a dependent functionality in a build?

HCL,

1154

How do you create type- insensitive operator?

EXL,

1043

Give me a SQL Query to find out the second largest company?

Ernst Young,

1165

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

1 1832

What is the difference between Triggers and Stored Procedure?

HCL,

1095

Explain the concept of view and Types of views in SQL server?

HCL,

992

How to connect of datebase with sql express.?

MCN Solutions,

1104

What do you mean by a Composite primary key?

Genpact,

1103

Are all views updatable ?

MCN Solutions,

1152

How each E-R model constructs can be mapped to the relational model?

HCL,

1002

Tell me about normalization in DBMS.

Honeywell, Zomato,

995

what is the difference between count(*) and count(1) ?

MCN Solutions,

1084

Relational calculus is what type of language?

HCL,

1036

Un-Answered Questions { Databases }

What is a key field?

985

Explain can you move old files in the movechunk directory?

What is role playing dimension with two examples? : sql server analysis services, ssas

1006

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2470

How do you create a table in pgadmin 4?

829

Segregate database technology's development.

1553

What is integrity and what is constraint??Explain with example

2283

How do you delete duplicates in sql query using rowid?

946

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

575

What are the disadvantages of merge replication?

1422

Can you list down the different components of physical and logical database structure?

Sql technical questions

1276

What is dba training?

558

What is a database in layman terms?

938

Is it possible to query neo4j over the internet?

For More Un-Answered { Databases } Questions Click Here