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 a data dictionary and how can it be created?

1151

Why do we need integrity constraints in a database?

1022

What are the different responsibilities of a dba?

725

How can we tune a sql query to optimize the performance of a database?

What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?

What is rac?

What is table partitioning and why is it required?

What is table partitioning?

What is an explain plan and how does it help in optimizing the sql query?

What is a recovery catalog?

How is incremental backup different from differential backup?

What do you understand by row chaining?

What is tkprof and how can we use it?

How can a single instance environment be converted into rac environment and how will they be different?

What do we mean by hot backup & cold backup and how are they different?

Un-Answered Questions { Databases }

Explain identity in sql server?

1013

What is set operator oracle?

980

How to run a sql statement?

1036

what is constraints? Also explain the different types of constraints?

974

When do you think a developer should use sql server-based cursors?

1048

How to combine two function together?

2129

What are the drawbacks of reporting in ssrs?

150

What flow of MSExcel in odi?

587

How is indexing done in search engines?

982

Can 2 queries be executed simultaneously in a distributed database system?

1143

What is a fan-out query in SQL Azure?

121

Can we rollback truncate?

999

explain the delete statements in sql

1061

Describe the three levels of data abstraction?

876

What's the difference between access and excel?

976

For More Un-Answered { Databases } Questions Click Here