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 differences between having and where clause.

966

What are the options which must be set to allow the usage of optimistic models?

963

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

985

Mention the command used to rename the database.

1006

Mention the differences between sql server and mysql.

1014

What are trace flags and mention a few common trace flags used with sql server?

1087

What are subqueries in sql server? Explain its properties.

1019

What do you understand by mirroring?

997

What are joins in sql and what are the different types of joins?

1014

How can you check the version of sql server?

1095

Write a query to find 5th highest amount paid from the customer table.

934

What do you understand by physical_only option in dbcc checkdb?

979

What are the differences between substr and charindex in sql server.

1115

What are relationships and mention different types of relationships in the dbms

962

What do you understand by integration services in sql server?

962

Un-Answered Questions { Databases }

What is the default schema of your login session in ms sql server?

1049

What is primary key in dbms?

910

What is difference between sql and excel?

1091

Why we use functions in sql server?

1077

What are cascading parameters in ssrs reports?

230

What are wait types?

1114

What is the meaning of database backup?

626

How to delete duplicate rows?

997

Explain the use of control file?

1113

Do you know nested transaction?

958

write a command to view the content of the table

899

Can a table have 2 primary keys?

983

Why functions are used in sql server?

960

where the connection string store in the database

2071

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1049

For More Un-Answered { Databases } Questions Click Here