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

What is rollback trigger in a trigger?

1 1119

What is the difference in storage type of numeric and decimal data types in sybase ?

1 937

Can you create your own sps for system wise?

1 976

State some of the criticism about sybase iq?

1 1007

How to delete unix files which are more than 3 days old?

1 979

Using large raw partitions with replication server on unix in sybase?

1 1033

What is asa ultralite in sybase?

1 1012

Compare in and exists?

1 988

What are the common oracle dba tasks?

1 1232

What is the difference between pre-select and pre-query?

1 1356

What is raw datatype?

1 1211

What is a subquery?

1 1229

Explain coalesce function?

1 1271

What is a package ? What are the advantages of package ?

1 1163

Will you be able to store pictures in the database?

1 1202

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

1262

Design database draw er diagram for a certain scenario ?

4650

Is microsoft getting rid of access?

883

What are the steps in creating a database?

1007

How to define array in mongoose schema?

How to convert numeric expression data types using the cast() function?

1145

What is the current version of sql?

1091

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8226

What are the two main functions of queries in databases?

1525

List out the different types of locks available in sql server?

1045

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

2567

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

Are you familiar with user exits in reports?

How do I remove duplicates in two columns?

1179

Do we need to rebuild index after truncate?

1132

For More Un-Answered { Databases } Questions Click Here