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

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1064

Explain the functionalities that views support?

1162

What are xml indexes?

1010

What is the openxml statement in sql server?

1128

Explain indexed view?

1 1502

What is for xml in sql server?

1145

How to call stored procedure using http soap?

1132

Can you explain what is indexed view? How to create it?

953

Explain what are partitioned views and distributed partitioned views?

1019

Do you know what are the restrictions that views have to follow?

1131

What are secondary xml indexes?

1082

What are the disadvantages of merge replication?

1521

What is replication and database mirroring?

1093

What is shared lock?

949

Explain the advantages of merge replication?

1013

Un-Answered Questions { Databases }

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

1070

How do I enable postgis on pgadmin?

1041

Explain throw statement in sql server 2008?

1056

How can Oracle users be audited?

1172

What are page splits? : sql server architect

960

How do I connect to pgadmin?

914

How to set a transaction to be read only in oracle?

1146

What format should my database be saved in to allow different versions of Microsoft Access to open the database?

961

Explain about the storage and physical database design?

972

What happens if you keep split brain syndrome in rac unresolved? How it can be resolved?

Does index speed up select statements?

1079

what is a table in a database ? : Sql dba

1090

which operator is used in query for pattern matching? : Sql dba

1048

What is difference between database and spreadsheet?

1125

Differentiate between ltm and repagent?

1043

For More Un-Answered { Databases } Questions Click Here