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 nested transaction?

1141

What are the differences between clustered and non-clustered index?

1083

What is page-level compression?

1011

When cursors are useful?

1172

Explain about extended stored procedure?

995

Explain what is “asynchronous” communication in sql server service broker?

962

Define inner join in sql server joins?

1126

What is row-level compre?

1051

Explain about nested stored procedure?

1084

Define left outer join in sql server joins?

1012

Can we create clustered index on composite key?

1176

Explain important index characteristics?

1083

Explain about local stored procedure?

1031

What is “asynchronous” communication in sql server service broker?

1082

What is bit data type? What's the information that can be stored inside a bit column?

972

Un-Answered Questions { Databases }

What do you mean by transparent dbms?

1474

Is coalesce faster than isnull?

1020

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1450

Give an example of why you would want to denormalize a database

1035

What are functions in database?

1007

Explain how are indexes update?

1125

What is the difference between varchar and varchar(max) datatypes?

1138

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

1034

Explain the difference between delete,drop and truncate in SQL Server?

1165

How to view the error log for any specific instance? : sql server database administration

1098

when would you go for denormalization? : Sql server database administration

911

Enlist the cursor types.

1094

what is the role of auditor in auditing data oriented applications?

2444

Write the alter statement to enable all the triggers on the t.students table.

1178

How to list all triggers in the database with sys.triggers in ms sql server?

1140

For More Un-Answered { Databases } Questions Click Here