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

1031

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

1023

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

961

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

1046

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

1066

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

1043

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

1035

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

1154

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

1060

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

1151

How to define output parameters in stored procedures?

1041

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

1063

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

1026

How to configure and test odbc dsn settings?

1176

How to list all user names in a database?

1063

Un-Answered Questions { Databases }

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2135

Is mongodb faster than sql?

Which one is better subquery or joins?

1075

whats new about truncate in sql server 2008?

2513

Do you know what is sql injection?

1009

explain advantages of myisam over innodb? : Sql dba

1083

What are the advantages of database software?

967

what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba

1102

What is msql?

1005

How to use multiple database server in back end ?

1052

What is implicit mode in sql server?

1115

Which part of the RDBMS takes care of the data dictionary? How

1027

Do you know what is bit data type and whats the information that can be stored inside a bit column?

967

how to drop an existing table in mysql? : Sql dba

1063

What are the functions of administration?

569

For More Un-Answered { Databases } Questions Click Here