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 convert numeric values to integers in ms sql server?

1109

What are the advantages of passing name-value pairs as parameters?

1179

How to create a local temporary stored procedure?

1012

What happens if null values are involved in datetime operations?

988

What is a subquery in a select query statement in ms sql server?

1143

How to see the event list of an existing trigger using sys.trigger_events?

1094

How to provide default values to stored procedure parameters?

1078

How to defragment indexes with alter index ... Reorganize?

1101

What is the default schema of your login session in ms sql server?

1061

Where to find ntwdblib.dll version 2000.80.194.0?

973

What happens if ntwdblib.dll is missing on your machine?

1158

How to disconnect from a sql server using mssql_close()?

1122

How to turn on the mssql api module in php?

1090

Can select statements be used on views in ms sql server?

1077

How to create a ddl trigger using "create trigger" statements?

1148

Un-Answered Questions { Databases }

Define database model.

1050

What is the blob data type?

803

What problem one might face while writing log information to a data-base table in pl/sql?

1178

What do you know by pl/sql cursors?

1120

Difference between LEN() and DATALENGTH() in sql server ?

1144

Can we enter data in a table in design view?

976

How to select true false based on column value in sql server?

1047

Define normalization.

964

Why do we need to use a database?

978

Which is faster mongodb or mysql?

912

explain what is odi?why is it different from the other etl tools.

628

What is query processing?

951

What are sql procedures?

1047

How to update operations immediately sync to disk in mongodb?

What is the difference between cold backup and hot backup?

590

For More Un-Answered { Databases } Questions Click Here