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 create a simple user defined function in ms sql server?

1035

How to create new tables with "create table" statements in ms sql server?

1074

How can windows applications connect to sql servers via odbc?

1141

How to drop an existing schema in ms sql server?

1115

How to insert and update data into a table with "insert" and "update" statements?

995

How to change the data type of an existing column with "alter table" statements in ms sql server?

993

What happens when converting big values to numeric data types?

1150

Can we delete data from a view?

932

How to update multiple rows with one update statement in ms sql server?

1219

What happens if an integer is too big for int date type?

988

Can binary strings be used in arithmetical operations?

950

What is a transact-sql statement?

1076

How to create stored procedures with parameters in ms sql server?

1100

How to specify the collation for a character data type in ms sql server?

1044

Does index slows down insert statements?

1008

Un-Answered Questions { Databases }

What is the openxml statement in sql server?

1086

What is dbms introduction?

967

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

729

What action plan is preferred if sql server is not responding?

1116

Mention few case manipulation functions in sql

992

What are different types of constraints?

940

Explain trigger classes i.e. Instead of and after trigger?

891

What is sql azure database?

206

What is the difference between BPA AND Contract What are documents and test cases u followed

2391

What are the steps you should follow to start sql server in single-user mode?

916

What is a production dba?

615

Explain the methods used to protect source code of pl/sql.

1034

Define full outer join in sql server joins?

1005

Explain iaas, paas and saas?

can you implement data mining in SSRS?

151

For More Un-Answered { Databases } Questions Click Here