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

Can we check locks in database? If so, how can we do this lock check?

1 1009

What is sub query and its properties?

1 1036

What is the use of @@spid?

1 1061

What do mean by xml datatype?

1 1200

What is the difference between commit and rollback?

1 1010

How exceptions can be handled in sql server programming?

1 1103

How global temporary tables are represented and its scope?

1 1044

Which sql server table is used to hold the stored procedure scripts?

1 1129

Mention what is the basic syntax to use index in mongodb?

1 48

Mention the command syntax that is used to view mongo is using the link?

1 40

Explain what is the role of profiler in mongodb?

1 41

Explain what are indexes in mongodb?

1 44

How replication works in mongodb?

1 50

Explain what is a replica set?

1 40

To do safe backups what is the feature in mongodb that you can use?

1 42

Un-Answered Questions { Databases }

Can we rollback truncate?

1070

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 sql or structured query language?

1212

What kind of problems occurs if we do not implement proper locking strategy?

1490

Equi join and non equi join is possible with sql server?

1119

How raid can influence database performance?

1104

Is primary key clustered index?

1008

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2695

What are wait types?

1230

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

Have you used lexical parameters in reports?

how to escape special characters in sql statements? : Sql dba

1108

How do I find query history in sql server?

1018

Is there some bulk load or other way to import a lot of data fast?

926

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

For More Un-Answered { Databases } Questions Click Here