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 joins in sql server? : sql server database administration

1019

Describe the left outer join & right outer join. : sql server database administration

1007

What is data compression? : sql server database administration

991

What is blocking and how would you troubleshoot it? : sql server database administration

1063

What is sql profiler. What are the default templates with it? : sql server database administration

1062

Where the sql logs gets stored? : sql server database administration

982

What stored by the model? : sql server database administration

971

How do you test your database? : sql server database administration

1039

How to view the error log for any specific instance? : sql server database administration

1055

What is the purpose of sql profiler in sql server? : sql server database administration

1120

Can we perform backup restore operation on tempdb? : sql server database administration

1020

Can you move the resources after pausing the node? : sql server database administration

1119

What should be the fill factor for indexes created on tables? : sql server database administration

1152

What is lock escalation? : sql server database administration

1172

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1051

Un-Answered Questions { Databases }

What are the types of containers in ssis?

1193

What are the essential components of sql server service broker?

1035

Explain the process of the user request and data generating?

1108

Why query optimization is needed?

937

What is embedded sql what are its advantages?

1058

Why can there be only one clustered index and not more than one?

1021

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1059

What is a foreign key constraint?

1030

What are the benefits of postgresql?

869

What is difference between oracle sql and mysql?

1035

What happens if you add a new index to large table?

954

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1454

What is the latest version of microsoft access?

923

What is row locking in mysql?

987

Can we write ddl in trigger?

932

For More Un-Answered { Databases } Questions Click Here