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

Explain about Normalization?

Infosys,

1065

What are triggers? How do you invoke a trigger on demand?

Hexaware,

1318

Explain about Joins?

Infosys,

988

What are the purpose of Normalisation?

HCL,

1050

Difference between group by clause and having clause in SQL?

Flextronics,

971

What are the types of subscriptions in SQL Server replication?

HCL,

1035

Â Explain what is sql override for a source taLle in a mapping?

Informatica,

1012

What are the characteristics of modern DBMS?

Ericsson,

1092

How to change the system date and time from SQL Plus Terminal ?

MCN Solutions,

1220

Define DML and DCL statements?

Hexaware, NIIT,

1 1660

What is function of ROLLUP ?

HCL,

1083

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3141

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1060

Define Unique Key?

HCL,

1003

Difference between aggregate functions of sql?

EXL,

1102

Un-Answered Questions { Databases }

What the different components of Replication and what is their use?

1068

How to dump a table to a file with 'mysqldump'?

1030

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1209

Explain different backup plans?

942

Which are the different character-manipulation functions in sql?

1065

How do I create a mysql username and password?

901

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

110

What is scalar user-defined function?

1101

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2123

Is postgresql cloud based?

809

What is Relationship type?

899

How many data types are supported?

1079

Is mongodb better than other sql databases? If yes then how?

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1224

When do we use namespace in mongodb?

For More Un-Answered { Databases } Questions Click Here