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 offset-fetch filter in tsql? : Transact sql

960

what is sp_pkeys? : Transact sql

1174

how tsql statements can be written and submitted to the database engine? : Transact sql

1012

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1058

What is t-sql? : Transact sql

1013

what is the difference between sql and t-sql? : Transact sql

1106

how to do backup entire database? : Transact sql

1161

what are the limitations of identity column? : Transact sql

1128

what is the use of set statement in tsql? : Transact sql

1024

what is the syntax for using sql_variant_property? : Transact sql

1058

Why do we use group by and order by function in mysql?

939

What is join in mysql? What are the different types of join?

948

If we use sum function in mysql, does it return sum of that row or for that column?

996

What do we use to remove duplicate records while fetching a data in mysql ?

974

What is the use of count function in mysql?

1044

Un-Answered Questions { Databases }

What is key set driven?

974

What are the characteristics of modern DBMS?

1115

How to call a stored function in oracle?

1041

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

1084

How to download and install sql server 2005 books online?

1216

Can we perform backup restore operation on tempdb?

1047

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2324

How to convert numeric expression data types by assignment operations?

1099

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

996

Do you know clustered and non-clustered index?

993

What are the functions of database management system?

988

What do you mean by adaptive server enterprise?

968

What are notification services?

1023

What are the operating modes in which database mirroring runs? : sql server DBA

1203

How many types of table create in ms access?

834

For More Un-Answered { Databases } Questions Click Here