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

Where the procedures are stored in database?

1 918

Explain about the implementation of stored procedures?

1 956

Does storing of data in stored procedures increase the access time? Explain?

1 1197

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

1 801

How can we call stored procedures inside store procedures?

1 909

State about the security aspects of stored procedures?

1 1053

Explain the benefits of running stored procedure on a database engine?

1 1009

How one call ddl statement using stored procedures in oracle?

1 869

State the different extensions for stored procedures?

1 891

How many types of stored procedure?

1 927

What is the difference between "is" and "as" while creating procedure?

1 886

What is the difference between stored procedures and stored functions in oracle?

1 1049

How you can import data from other sources into access database?

1 1088

Explain how we can do multi-join query in ms access?

1 948

Between different data’s, what are the types of relationship can be formed?

1 1114

Un-Answered Questions { Databases }

How to start an oracle instance?

1099

What is oracle latest version?

1171

What is a concurrency problem in dbms?

1049

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 in place upgrade in sql server?

1123

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1950

Can sql servers link to other servers like oracle?

911

How do I find query history in sql server?

1018

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

8225

What is the current version of sql?

1091

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

How to rebuild the master database?

1160

What is clustered index

1083

what is the difference between openrowset and openquery?

1187

How do I create a trace in sql server?

1112

For More Un-Answered { Databases } Questions Click Here