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 user messages with print statements in ms sql server?

1002

How to write a query with a right outer join in ms sql server?

926

How to provide column names in insert statements in ms sql server?

1175

How to return the second 5 rows in ms sql server?

1078

How to verify a login name with sqlcmd tool?

1232

How to generate create table script on an existing table in ms sql server?

1158

How to replace null values in expressions using isnull()?

1109

How to set the current database in ms sql server?

1097

What are the requirements to use odbc connections in php scripts?

1130

What is a constant or literal in ms sql server?

1065

How extra digits are handled with numeric data type literals?

978

What are ddl (data definition language) statements for tables in ms sql server?

1117

What happens when converting big values to integers?

1016

How to test values returned by a subquery with the in operator?

1211

How to apply filtering criteria at group level with the having clause in ms sql server?

1016

Un-Answered Questions { Databases }

How do database connections work?

961

What is data compression?

1027

How to drop all foreign keys in database?

1104

What is history table in sql server?

991

What is snapshot is too old? Give and example for better understand.

1621

Can you tell how many values can set the function of mysql to consider?

1002

What is user-defined scalar function?

977

Is there a version of microsoft access for mac?

871

What are the types of database users?

1009

What is the purpose of linked server configuration in sql server?

1062

What is an entity-relationship model?

952

How to use the inserted and deleted pseudo tables?

975

What are the different pseudo commands? Explain in general?

1090

What does rdbms stand for?

1082

What are magic tables in sql server?

1145

For More Un-Answered { Databases } Questions Click Here