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 show table names with 'mysqlshow'?

1080

How to provide login information for a new odbc dsn?

1101

How to declare a cursor with "declare ... Cursor" in ms sql server?

1095

How to define and use table alias names in ms sql server?

1219

How to name query output columns in ms sql server?

1020

How to get the definition of a trigger back?

1049

What is wrong with sql server client libarary dll, ntwdblib.dll?

1099

Why I am getting this error when renaming a database in ms sql server?

1118

What is the security principal at the server level that represents your session?

1065

How to create an index on a view?

1146

What happens if you add a new index to large table?

988

How to convert binary strings into integers in ms sql server?

1091

What happens to a trigger with multiple affected rows?

999

What are database states in ms sql server?

1255

What happens if null values are involved in arithmetic operations?

1050

Un-Answered Questions { Databases }

How to shrink a database?

1029

What is range partitioning?

1019

Which is the correct statement about truncate and delete?

1180

Explain how to maintain a fill factor in existing indexes?

1043

What is simple indexing method?

1088

Which sql statement is used to return only different values?

1062

Can a rule be bound to any column of any data type?

1029

What is the reports view in oracle sql developer?

1049

What is format trigger?

2124

Can we create view in stored procedure?

1028

What do you understand by integration services in sql server?

1006

How do I create a foreign key in postgresql?

806

How to delete multiple rows from a table in oracle?

1119

explain different types of constraints? : Sql server database administration

1004

How do I remove all records from a table?

1121

For More Un-Answered { Databases } Questions Click Here