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

Difference between 2NF &3NF ?

Cap Gemini,

1139

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

Flextronics, Hexaware,

1 2067

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

HCL,

1211

How do you create type- insensitive operator?

EXL,

1113

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

Ernst Young,

1234

Explain different types of Normalization.

HPCL, Hughes Systique Corporation, Ittiam Systems,

1 1915

What is the difference between Triggers and Stored Procedure?

HCL,

1167

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

HCL,

1038

How to connect of datebase with sql express.?

MCN Solutions,

1150

What do you mean by a Composite primary key?

Genpact,

1203

Are all views updatable ?

MCN Solutions,

1208

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

HCL,

1058

Tell me about normalization in DBMS.

Honeywell, Zomato,

1066

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

MCN Solutions,

1137

Relational calculus is what type of language?

HCL,

1111

Un-Answered Questions { Databases }

How to check if sybase database is up and running?

923

What is auto increment in sql?

1180

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1132

How to retrive a student with height marks,second height and third height from MS access database what wil be the query for this purpuse?

1048

How to install oracle database 10g xe?

1070

How do you bind variables in oracle?

1032

How secure is sql server database?

1082

Explain an automatic checkpoint

1022

What is row_number () in sql?

1035

What is blob and clob?

998

Please explain the main features of couchdb?

You need to remove the affected rows and dashes. How would you do that?

1009

What are the differences between a dbms and rdbms?

1075

How do I copy an entire mysql database?

954

What is the starting oracle error number? What is meant by forward declaration in functions?

1045

For More Un-Answered { Databases } Questions Click Here