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

Explain about builtinadministrator?

1120

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

1158

Tell me what is use of except clause? How it differs from not in clause?

1003

Can you please differentiate between a primary key and a unique key?

1053

Explain what is dbcc?

1069

Explain in brief how sql server enhances scalability of the database system?

1031

Explain what is row_number function?

1085

Tell me what is difference between clustered and non clustered index?

984

Explain the phases a transaction has to undergo?

1118

What is sql service broker?

1026

List down some advantages of sql stored procedure?

1019

Do you know what are the properties of the relational tables?

1074

Can you explain various data region available in ssrs with their use?

1026

Tell me in brief how sql server enhances scalability of the database system?

1048

Explain what is log shipping?

1199

Un-Answered Questions { Databases }

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2196

What is the report builder?

143

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

1024

Is mysql good for big data?

995

How to add microsoft access to office 2016?

973

How to uncatalog backup?

608

Put some light on multi-version concurrency control?

934

How to drop all foreign keys in database?

1153

What is required to create mysql database?

1038

how many bits ip address consist of? : Sql server database administration

944

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1079

Is there a free version of mysql?

994

What is a deadlock and mention how it can be resolved?

917

What are rows and columns?

1067

Is redis in memory database?

1055

For More Un-Answered { Databases } Questions Click Here