Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
Explain unique Constraint.
- Correct Answer
- A unique constraint on a column uniquely identifies the record by a combination of one or more fields Few unique constraint fields can have a NULL value as long as the combination of values is unique Example: create table employee ( id number NOT NULL, dob DATE, professor_id NOT NULL, Name varchar(200) Constraint id_unique UNIQUE(id,dob) );
- 1. What do you like to do when you're not at work? Discuss
- 2. Have you ever had difficulty working with a manager? Discuss
- 3. Someone who loans money is called
Options- A. Lender
- B. Borrower
- C. Investee
- D. Investor Discuss
- 4. Cache events are processed when ever the Postback events occurs
Options- A. TRUE
- B. FALSE Discuss
- 5. EXPLAIN has output with MATCHCOLS = 0. What does it mean? Discuss
- 6. The new product development process usually starts with
Options- A. idea generation
- B. market strategy development
- C. concept development
- D. idea screening Discuss
- 7. How do you display last 5 records in DB2? Discuss
- 8. Managing the sales force : For a new salesperson, what are his training needs? Discuss
- 9. What is SPUFI? Discuss
- 10. How will u send data from a cobol file to db2 table? Discuss
More questions
Correct Answer: Be sure to emphasize those activities that may complement your on-the-job duties For Example, if you're applying for a position as a book-store manager, mentioning that you read three books per a week is highly appropriate
Correct Answer: Here are some example statements to consider as you prepare your answer 1I have been fortunate to have had awesome managers during my career so far I have respected each of them and got along nicely with all of them 2No, I am a hard worker, and my managers continually appear to appreciate the job I'm doing I have got along good with every manager I have had
Correct Answer: Lender
Explanation:
Someone who receives money in exchange for a promise to pay it back later is called a borrower1, and the person making the loan is the lender.
Correct Answer: TRUE
Explanation:
Cache events are processed only when the Postback events occur
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
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.