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 enter date and time literals in ms sql server?

1072

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1062

How to create a user to access a database in ms sql server using "create user" statements?

998

How to set database to be single_user in ms sql server?

1084

Can multiple columns be used in sql group by clause in ms sql server?

1120

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

1077

How to create new databases with "create database" statements?

1069

How to filter out duplications in the returning rows in ms sql server?

1223

How to list all user defined functions in the current database?

1121

How to list all login names on the ms sql server?

1191

How to define output parameters in stored procedures?

1088

How to how to convert numeric expression data types using the convert() function??

1101

What are group functions in query statements in ms sql server?

1066

How to configure and test odbc dsn settings?

1230

How to list all user names in a database?

1099

Un-Answered Questions { Databases }

explain the storage models of olap? : Sql server database administration

1018

Can we create a trigger on view?

946

How we can get the current date in mysql?

1004

How to returns the columns and column information pertaining to the designated table.

1077

How to use null as conditions in oracle?

1129

what are the different ways to return the rowcount of a table?

1059

Can a cursor be updated? If yes, how you can protect which columns are updated?

1181

Write down the syntax and an example for create, rename and delete index?

1031

What is database management system explain?

988

What are the disadvantages of mongodb?

How a table can be created using microsoft access object library (maol)?

1683

What do you mean by recursive stored procedure?

993

What is a relation in dbms?

1243

What happens to the indexes if a table is recovered?

1050

What is database schema name?

1103

For More Un-Answered { Databases } Questions Click Here