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?

1096

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?

980

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 do you mean by oracle database?

572

Where is the mongodb database?

What are the uses of linked server and explain it in detail?

1060

Can you explain the select into statement?

1025

What is ibdata1?

909

Differentiate CHAR_LENGTH and LENGTH?

997

What are the advantages of database software?

959

What is oracle and pl sql?

1118

Do you know what are different types of replication in sql server?

1099

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1021

Delete duplicate rows without using rowid.

1532

What skills do you need to be an administrator?

566

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269

How sql server executes a statement with nested subqueries?

1028

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

549

For More Un-Answered { Databases } Questions Click Here