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 definer rights invoke rights?

1 6664

How can we schedule the procedure to run automatically ?

3 11273

How toimport .dmp file in lower version of oracle from higher version ?

TCS,

4 14376

What are the Restrictions on Cursor Variables?

2 16204

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 10872

what is meant by forward declaration in functions?

TCS,

4 16645

what is difference between stored procedures and application procedures,stored function and application function?

1 11586

State the difference between implict and explict cursor's?

CTS,

7 23569

State the advatage and disadvantage of Cursor's?

2 9737

How to trace the errors in pl/sql block code?

TCS,

5 16915

How to display the contents of a current record fetched in a reference cursor?

2 9235

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 11455

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1 2286

How well can multiple sessions access the same data simultaneously ?

Oracle,

1 3646

What is Data Concarency and Consistency?

1 6096

Un-Answered Questions { Databases }

Can sql servers link to other servers like oracle?

910

How do I remove duplicates in two columns?

1177

what is spatial nonclustered index

1054

What versions of clipper does netlib support?

1086

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

Is it possible to have clustered index on separate drive from original table location?

1034

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

How can you append an identity column to a temporary table?

1065

Does group by remove duplicates?

1112

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

What are the advantages of database?

1009

Why use identity in sql server?

1191

What is sql server query analyzer?

1123

What are the kinds of subquery?

1099

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

For More Un-Answered { Databases } Questions Click Here