Answer Posted / guest
constraints ? [Y] Specifies whether table constraints
should be exported with table data. If N then constraints
won't get exported
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of database servers?
What is an entity-relationship model?
What is a driver in programming?
Why rdbms is not suitable for big data?
Explain the difference between two and three-tier architectures.
What is database partitioning?
Explain by listing some of dbms major advantages.
When does checkpoint occur?
1. Tell me about your self? 2. Latest Project Introduction? 3. Difference between server jobs and parallel jobs? 4. Seq-Seq Explain its behavior and execution mode and which parallelism technique is used? 5. What is padding characters? 6. Seq-Seq, Seq-Copy-Seq which one is the best and efficient? 7. How many reject links do we have to a transformer? 8. How many reject links to join stage? 9. Difference between join and lookup? 10. How to design PX routine? 11. How can we call job in another job? 12. Difference between batch and sequencer? 13. Which Database is used? 14. What is change capture? Give briefing of that? 15. What is change Code? Explain? 16. How you call UNIX in Ds? 17. How do you call JCL in UNIX? 18. How do you pass the job status of one job to another job? Have designed any job sequencer? 19. How do you find a file in existed directory? 20. How can you call parallel jobs in transformer? 21. Execution of jobs in command line? 22. Tuning of sql queries? 23. What is orchestrating metadata? 24. What are junk dimension? 25. What are the third party tools you are used? 26. What are the system variables you have used?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What is normalization? What are different type of normalization?
What are the five steps of data modeling?
Explain why an information gap exists in most organizations.
Explain the different types of database keys?
What is dbms used for?