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

How is SQL Azure different than SQL server?

1 266

How many replicas are maintained for each SQL Azure database?

1 185

How can we migrate from SQL server to SQL Azure?

1 153

Which tools are available to manage SQL Azure databases and servers?

1 156

Explain something about security and SQL Azure?

1 180

What is SQL Azure Firewall?

1 174

Define Wed Edition in SQL Azure?

1 143

Define Business Edition in SQL Azure?

1 141

How do we synchronize On-Premise SQL server with SQL Azure?

1 165

How do we Backup SQL Azure Data?

1 155

What is the current pricing model of SQL Azure?

1 149

What is the current limitation of the size of SQL Azure DB?

1 171

What happens when the SQL Azure database reaches Max Size?

1 155

How do you improve the performance of a SQL Azure Database?

1 178

What were the latest updates to SQL Azure service?

1 155

Un-Answered Questions { Databases }

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

What is an indexed view?

1017

How to define array in mongoose schema?

What are wait types?

1230

What are the two main functions of queries in databases?

1519

How to use values from other tables in update statements using oracle?

1144

What are the source of constraints?

1006

What is clustered index

1081

Explain system functions or built-in functions? What are different types of system functions?

1055

How to enter binary string literals in ms sql server?

1235

What is current version of mysql?

1063

How to convert character strings into numeric values?

1184

List the ways in which dynamic sql can be executed?

1074

please send me oracle pl/sql exp resume. and also faqs...

2564

How raid can influence database performance?

1104

For More Un-Answered { Databases } Questions Click Here