Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What is the use of ANALYZE command?
- Correct Answer
- To perform one of these function on an index, table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary - To delete statistics about the object used by object from the data dictionary - To validate the structure of the object - To identify migrated and chained rows off the table or cluster
- 1. EXPLAIN has output with MATCHCOLS = 0. What does it mean? Discuss
- 2. The new product development process usually starts with
Options- A. idea generation
- B. market strategy development
- C. concept development
- D. idea screening Discuss
- 3. How do you display last 5 records in DB2? Discuss
- 4. Managing the sales force : For a new salesperson, what are his training needs? Discuss
- 5. What is SPUFI? Discuss
- 6. How will u send data from a cobol file to db2 table? Discuss
- 7. What is buying forward? Discuss
- 8. What is Benchmarking? Discuss
- 9. In a DB2-CICS program which acts as co-ordinator and which is the participant? Discuss
- 10. Market survey means...........
Options- A. Market Research
- B. Market Planning
- C. Marketing Strategies
- D. Market Monitoring Discuss
More questions
Correct Answer: a nonmatching index scan if ACCESSTYPE = 1
Correct Answer: idea generation
Correct Answer: SELECT * FROM table_name ORDER BY column_name desc Fetch first 5 rows only;
Correct Answer: New salespersons needs: a) He needs to know the information on company history, its policies, rules and regulations etc b) Details about the product- its features, usage , demand c) Systems and procedures as followed by the company This may include the work timings, overimed, field work, work culture of that particular organisation etc d) Training on the basic ethics that need to be followed while selling a product e) He must know the basics of selling the different products of the company
Correct Answer: SPUFI stands for SQL processing using file input It is the DB2 interactive menu-driven tool used by developers to create database objects
Correct Answer: USING HOST VARIABLE we can pass data from COBOL to DB2
Correct Answer: It is an investment strategy that involves the buying of money market instruments or currencies in anticipation of a price rise or a future increase in demand Buying forward allows an investor to take advantage of future and potential profits by buying now at alower price, and selling when prices rise
Correct Answer: Benchmarking is the process of comparing one's business proceses and performance metrics to industry bests or best practices from other industries Dimensions typically measured are quality, time and cost
Correct Answer: DB2 acts as the participant and CICS acts as a co-ordinator
Correct Answer: Market Research
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.