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 will you optimize a stored procedure optimization?

1118

What are the disadvantages of using the stored procedures?

1192

Distinguish between commit and rollback?

1017

Explain subquery and state its properties?

1097

What do you understand by a stored procedure?

1156

What is coalesce and check constraint in sql server?

1179

What are the purposes of floor and sign functions?

1024

What is a virtual table in sql?

1037

Explain cdc and sql injection?

1045

State the difference between local and global temporary tables?

1175

Explain cross join or cartesian product in sql?

932

What is sql server agent and what are the two modes of authentication in sql server?

1112

Explain tablesample?

1044

Differentiate between truncate vs delete in mssql?

1169

How are the exceptions handled in sql server programming?

1119

Un-Answered Questions { Databases }

Is mysql still popular?

968

How to shut down the server with 'mysqladmin'?

1026

Explain procedure to change characterset of a database.

683

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1112

What is transaction control statement and how many types of transaction control statement in Oracle?

1242

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2609

Define constraints and give an example of their use?

1099

Name the buffer in which all the commands that are typed in are stored

856

What is an oracle tablespace?

1097

What is acid property in dbms?

1023

Why is nosql good?

1085

how to get @@error and @@rowcount at the same time? : Sql dba

1084

What is data type in oracle?

1186

What is the difference between oracle media recovery and crash recovery?

1216

aht is the difference b/w network & hierarchial & relational dbms????

2260

For More Un-Answered { Databases } Questions Click Here