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

What is microsoft sql server?

986

How to select some specific columns from a table in a query in ms sql server?

1017

How to use order by with union operators in ms sql server?

1034

How to generate random numbers with the rand() function in ms sql server?

1171

Why are you getting errors when creating a new odbc dsn?

1237

What happens if null values are involved in string operations?

1005

How to test subquery results with the exists operator?

1125

How to download and install the scaled-down database adventureworkslt?

1002

How to connect to a sql server using odbc_connect()?

1172

How to select an exiting database using mssql_select_db()?

1003

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1114

What causes index fragmentation?

1012

How to modify the underlying query of an existing view?

997

How to end a stored procedure properly in ms sql server?

1103

How to view existing indexes on an given table using sys.indexes?

1106

Un-Answered Questions { Databases }

What is difference between joins and union?

1145

what is the maximum size of a row? : Sql server database administration

1030

Explain the record term used in database.

1099

How do you performance tune a database?

953

How do you set up tablespaces during an oracle installation?

616

What is mongodb query language?

Explain top-n analysis in DBMS.

1617

Where is database data stored?

917

What is a transaction and why is it important?

1107

Can you shard mysql?

934

Define Joins?

1040

Does view store data in sql?

973

How do I partition a table in sql server?

1056

What is error ora-01000: maximum open cursors exceeded

1162

What are the differences between a dbms and rdbms?

1004

For More Un-Answered { Databases } Questions Click Here