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 18587why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two
1 79081). What are the situation in process is duplicate is linux box.? 2) Give me 5 situation to kill a process?
1 4813Post New Perot Systems Interview Questions
how to test an webbased application?
for methods within objects,what does the keyword this specifically refer to? : Adobe flash
which protection function should measure RMS value of current&DFT value of current?
What are font ligatures?
How to use WMLScript WMLBrowser library?
What is aws lambda?
What is difference between hibernate save(), saveorupdate() and persist() methods?
What is google possum?
Explain the process in which flat files are converted into vsam files?
What is the head tag used for?
What is methods in oop?
What are the technical and environment risks u faced in ur testing career?
Explain about procedural programming language or structured programming language and its features?
What is validation in mvc?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc