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 about Normalization?

Infosys,

1133

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

Hexaware,

1378

Explain about Joins?

Infosys,

1042

What are the purpose of Normalisation?

HCL,

1103

Difference between group by clause and having clause in SQL?

Flextronics,

1033

What are the types of subscriptions in SQL Server replication?

HCL,

1120

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

Informatica,

1065

What are the characteristics of modern DBMS?

Ericsson,

1156

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

MCN Solutions,

1292

Define DML and DCL statements?

Hexaware, NIIT,

1 1754

What is function of ROLLUP ?

HCL,

1151

Where do we generally create INDEX?

Ernst Young, Thomson Reuters,

1 3247

What do you mean by 'normalization'?

Ernst Young, Thomson Reuters,

1130

Define Unique Key?

HCL,

1076

Difference between aggregate functions of sql?

EXL,

1152

Un-Answered Questions { Databases }

What are property classes?

Is sql sequential or random?

1093

What is right outer join in sql server joins?

1236

What is a read write transaction in oracle?

1148

What number aggregate functions are accessible there in sql?

1147

Explain the ways to controlling cursor behavior?

971

What are the different pseudo commands? Explain in general?

1135

How a tablespace is related to data files?

1171

How to store binary data in mysql?

1051

What is a database access?

960

What is a relation schema?

1082

how to determine the service pack currently installed on sql server? : Sql server database administration

1026

What is a unique key?

1113

What is main function of database administrator?

618

Write a SQL query to make a column as unique?

1080

For More Un-Answered { Databases } Questions Click Here