1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
10 15408why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 70341). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4128Post New Perot Systems Interview Questions
What does the burndown charts show?
What is default session time out in tomcat?
You are entered a credit memo posting to vendor who is linked to a customer on 1st of May 2003 for your company code but you have not specifically entered the same data in customer till now. You have lots of entries appearing in the vendor and customer account prior to that date of May 2003 also. You are making a manual payment to the vendor ? select out of the following which statements are correct. a. Credit memo document will get the special payment term as per vendor master definition. b. Customer items will not be shown while paying the vendor as customer is not linked. c. Customer items will be shown only postings after the date 1st May 2003. d. All items of customer and vendor will be available for payment provided payment is same from 1st May 2003. e. All items of customer and vendor will be available for payment provided Special GL items are also selected in selection screen irrespective of the activation date
Position Market Analyst (market research, FMCG sector). I must to write math test on English. I need to find example of test. I'm Russian and I need to learn business terminology to understand question
Tell us about the stages (phases) of the jsp life cycle.
How can you send some messages in kafka?
1.Please tell me HRD is problem or not? if yes then tell is it a problem for top to bottom or bottom to top. 2. As a fresh HR Manager how will you make policy for HR Department? Give Sample of Policy?
What is command statement?
What’s collection?
What is process chain and how you used it?
What is google android sdk?
What does ord () do in python?
How will go about doing a client copy ?
What is meant by managedserver?
sir, please send HPCL INFORMATION SYSTEMS OFFICER SYLLABUS WITH PREVIOUS QUESTION PAPERS