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 are the advantages of policy management?

1012

what is nonclustered index

976

Explain system views?

1102

What are various limitations of the views?

1072

How to insert stored procedure result into temporary table?

1031

What does top operator do?

1039

What is self contained scalar sub query?

991

How can I get data from a database on another server?

1010

Find nth lowest salary or get nth lowest salary?

1045

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1045

What is instead of dml trigger?

1020

Explain different types of self contained sub query?

1074

What is the difference between grant and with grant while giving permissions to the user?

983

Explain relational data?

938

What are the different normalization forms?

1129

Un-Answered Questions { Databases }

How do you put database is archivelog mode, explain procedure?

560

What is the difference between primary key and unique key and foreign key in oracle?

1006

How can we get the number of rows affected by query?

1082

Is a rollback possible to any savepoint?

1114

What is the volume management techniques used in oracle rac?

Which is the most used database?

952

What is shared_buffers postgresql?

911

What is ole db used for?

1030

What are “lost updates”?

1015

What is the method to configure the cache size in mongodb?

Can we join two tables without common column?

1026

Can you explain different types of joins?

955

Explain autosys. Why do you need it.

984

What is bcnf standard form in dbms?

1045

What do you understand by oracle forms and why are they required?

1033

For More Un-Answered { Databases } Questions Click Here