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

How to insert multiple rows with a subquery?

1193

How to delete existing rows in a table?

1258

How to create an identity column?

1306

How to make a column nullable?

1188

What is a result set object returned by odbc_exec()?

1079

What is a result set object returned by mssql_query()?

1233

Explain what are the authentication modes in sql server?

1074

How to use linked server?

1274

Explain what is cte (common table expression)?

1192

Explain features and concepts of analysis services?

1025

Do you know what is user defined datatypes and when you should go for them?

1014

Do you know what is difference between index seek vs. Index scan?

1008

Can we use custom code in ssrs?

1170

Explain what are the restrictions while creating batches in sql server?

1118

Explain about sql server login?

1140

Un-Answered Questions { Databases }

Why do we use bulk collect in oracle?

1112

How to put more than 1000 values into an oracle in clause?

1090

What is the New in SQL server 2008?

1017

explain detail about ftp in datastage?

2296

How to link tables in sql server?

978

What would you do with an in-doubt distributed transaction?

2051

Should you normalize audio?

1010

What is the relation between database and instance?

702

How do I connect to mysql database?

1097

what is difference between view and Dip.

2461

How can I see all tables in oracle?

1063

What happens when unicode strings concatenate with non-unicode strings?

1188

Is pl sql a scripting language?

1084

What is database management system(dbms) and why it is used?

1086

What are the tools used for backup and ticketing?

1037

For More Un-Answered { Databases } Questions Click Here