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

How to prevent concurrent access to my data?

HCL,

1032

Explain the Logical Schema of Database

HCL,

1012

Have you written applications to retrieve stored images in a table?

Tech Mahindra,

1021

What is Database Management System?

Atos Origin,

1186

What is Data Redundancy and Consistency ?

MCN Solutions,

1001

What is Normalization and its different forms?

QuestPond,

1031

How a Store Procedure called with a cursor out parameter.?

MCN Solutions,

1019

What methods is used to commit the changes made in DataSet object?

Petranics Solutions,

1059

Difference between data and information, and how are they related in a database?

Huawei,

975

Explain the three Level Architecture of the Database System

HCL,

950

how Data is stored in a file so that Direct Searching can be performed

HCL,

1014

Can you drop all the columns of a table ?

MCN Solutions,

967

Tell us about some Dot operator queries?

Atos Origin,

1167

What are the different types of DBMS architecture?

TCS,

1081

Can we linked SharePoint to a SQL databasebe?

Sans Pareil IT Services,

1103

Un-Answered Questions { Databases }

How do I delete a trigger?

965

What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?

926

how to check myisam tables for errors? : Sql dba

1321

Can you lock more than one database at the same time in mongodb?

What is cursors? And what are the different types of cursor?

1144

What is the difference between access and excel?

935

What command is used to create a database in the sql server and how?

1179

Write SQL queries on Self Join and Inner Join.

1154

How does left join work in sql?

1001

What is cte?

982

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

1085

What is the difference between hot backup and cold backup in oracle?

1014

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

2168

How does mongodb replication work?

Can two tables have the same primary key?

1208

For More Un-Answered { Databases } Questions Click Here