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

1070

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

1112

How can windows applications connect to sql servers via odbc?

1184

How to drop an existing schema in ms sql server?

1151

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

1052

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

1041

What happens when converting big values to numeric data types?

1231

Can we delete data from a view?

981

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

1265

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

1029

Can binary strings be used in arithmetical operations?

988

What is a transact-sql statement?

1131

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

1162

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

1092

Does index slows down insert statements?

1049

Un-Answered Questions { Databases }

Tell me about normalization in DBMS.

1064

What are the properties of a primary key in DBMS?

1005

Is ms access better than excel?

818

What is trigger in salesforce?

1062

Can we insert data into a view?

1196

Can you type more than one query in the query editor screen at the same time?

1073

What is the purpose of the tempdb database?

1050

what is an index? : Sql server database administration

1029

What do you understand by check constraint in sql server?

1020

What are pl/sql packages?

1167

How to turn off warning messages during php execution?

1113

Can dml statements be used in pl/sql?

1128

How much memory does mongodb need?

Explain autonomous transaction.

1223

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1206

For More Un-Answered { Databases } Questions Click Here