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

What is constraints and its types?

1 1017

How to find which stored procedure is currently running in sql server?

1 1066

How to get all stored procedures in sql server?

1 1092

How do you debug a procedure in sql server?

1 1022

How to check if stored procedure is running in sql server?

1 1170

Why join is faster than subquery?

1 1191

What is before trigger?

1 1083

Which is faster union or join?

1 1042

Why is a primary key important?

1 1120

What is mutating trigger?

1 1086

Which is better cte or subquery?

1 1097

Is it possible to update views?

1 1036

Which is faster count (*) or count 1?

1 1111

Why use subqueries instead of joins?

1 1152

Which normal form is best?

1 1018

Un-Answered Questions { Databases }

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

1021

Have you used lexical parameters in reports?

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

How to start an oracle instance?

1094

Can we use distinct and group by together?

1129

define sql insert statement ? : Sql dba

1092

What are the types of database explain each of them briefly?

1049

What versions of clipper does netlib support?

1082

What is an indexed view?

1018

Can we rollback truncate?

1070

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

1055

Can we shrink data file in sql server?

1119

What is a concurrency problem in dbms?

1047

What is a coalesce function?

1275

What are the different types of subquery?

1228

For More Un-Answered { Databases } Questions Click Here