adspace




Databases Interview Questions
Questions Answers Views Company eMail

For web applications from which version of Oracle is suitable?

1 6288

What are the main diff. between oracle 7.3 and oracle 8i?

1 5771

What is mutating table?

Saama Tech,

11 67661

How to call DDL statements from pl/sql?

5 34008

How to perform a loop through all tables in pl/sql?

Evosys, MBT,

4 17393

How to maintain the history of code changes of pl/sql?

3 15430

what are Dynamic SQL statements?

9 27157

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 15689

What is pl/sql and what is it used for?

4 16064

what is constraining table?

2 14533

How pl/sql source code can be protected?

3 11892

What is the result, when NULL is compared with NULL?

TCS,

22 53147

What can be a size of a pl/sql block? Is there any limit?

2 13444

what are %TYPE and %ROWTYPE? what is the difference?

ICICI, Saama Tech, Sail,

7 49414

How to set the time zone for MySQL to particular country time?

1 3283


Un-Answered Questions { Databases }

What is a concurrency problem in dbms?

1054


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

1156


how to use regular expression in pattern match conditions? : Sql dba

1111


What is the current mysql version?

1099


Can we shrink data file in sql server?

1125


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

2708


Can we rollback truncate?

1074


what is the age limit for groups1 examination

2341


What is normalization and what are the advantages of it?

1054


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?

1907


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1045


Can one drop a column from a table?

1086


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1196


How to connect php with different port numbers?

1184


How do I start sql server 2017?

1015