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

Explain the steps to create and execute a user-defined function in the sql server?

1 1021

What do you understand by triggers?

1 984

mention different types of relationships in the dbms?

1 1108

What is the command used to check locks in microsoft sql server?

1 1110

What do you understand by recursive stored procedure?

1 998

How can you ensure that the database and sql server based application perform well?

1 1132

What do you understand by the data quality services in sql server?

1 987

What is the usage of the sign function?

1 1221

What are trace flags?

1 1097

What are the steps you should follow to start sql server in single-user mode?

1 963

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1 1037

What do you understand by sql server agent?

1 1037

What are the various levels of constraints?

1 1178

What do you mean by table in sql?

1 1047

What are stuff and replace function?

1 1151

Un-Answered Questions { Databases }

How can I check that whether automatic statistic update is enabled or not?

1101

Can delete statement be rollbacked?

1038

what are the advantages of sql ? : Sql dba

1125

Is primary key clustered index?

1000

What is the difference between for xml raw and for xml auto?

1095

Is there some bulk load or other way to import a lot of data fast?

923

what is collation? : Sql dba

1211

List the ways in which dynamic sql can be executed?

1071

How to put more than 1000 values into an oracle in clause?

1095

Is inner join faster than left join?

1265

Why should you use or avoid select * statements?

1094

Explain “row_number()” in sql server with an example?

1061

Explain system functions or built-in functions? What are different types of system functions?

1052

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2081

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1015

For More Un-Answered { Databases } Questions Click Here