Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
SQL *NET is ORACLE's mechanism for interfacing with
the communication protocols used by the networks that
facilitate distributed processing and distributed
databases. It is used in Clint-Server and
Server-Server communications.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the term specialization.
Difference between data and information, and how are they related in a database?
When we will denormalize data?
How view is related to data independence?
What is pcbs (program communication blocks)?
Write about Transaction Management in Oracle 9i?
What's the difference between delete and truncate ?
What are the types of model?
What are different types of joins in the sql?
Define primary and unique key?
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
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?
What are the various types of relationships in database? Define them.
If you need to refresh a website page every time a record is updated in database, how would you do it?
Define ddl interpreter.
