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 19022Post New Perot Systems SQL Server Interview Questions
- Perot Systems ASP Interview Questions (1)
- Perot Systems VB Script Interview Questions (1)
- Perot Systems ASP.NET Interview Questions (4)
- Perot Systems VB.NET Interview Questions (1)
- Perot Systems Oracle General Interview Questions (1) Perot Systems SQL Server Interview Questions (1)
- Perot Systems Linux Commands Interview Questions (1)
- Perot Systems Unix Commands Interview Questions (2)
- Perot Systems Test Director Interview Questions (2)
- Perot Systems JCL Interview Questions (3)
- Perot Systems DB2 Interview Questions (1)
- Perot Systems Business Objects Interview Questions (2)
- Perot Systems HR Questions Interview Questions (1)
- Perot Systems Business Administration Interview Questions (1)
- Perot Systems Accounting AllOther Interview Questions (1)
- Perot Systems Call Centre AllOther Interview Questions (2)
- Perot Systems General Aptitude Interview Questions (1)
- Perot Systems Placement Papers Interview Questions (3)
How do I search for files containing specific text in linux?
sir I got selected in rail vikas nigam limited and they call for interview but i don't what they will ask in interview please guide me if you have any experience
Explain the common execution states for a swift ios app (ios application lifecycle).
Name at least 5 different types of transformations used in mapping design and state the use of each.?
The Tabula Manufacturing Company has been in business for one month. At the end of month the company had the following accounts: Materials used K 5 000.00 Direct labour 10 000.00 Indirect labour 3 000.00 Indirect materials 2 000.00 Labour fringe benefits 1 000.00 Supervisor’s salary 1 000.00 Depreciation Machinery 2 000.00 Miscellaneous factory overhead 1 000.00 Heat and light 500.00 Insurance on plant 1 500.00 The company processed two jobs during the month with costs as follows: Job 101 Job 102 Materials cost K3 000.00 K2 000.00 Direct labour cost K6 000.00 K4 000.00 Direct labour hours 4 000.00 3 000.00 Machine hours 2 000.00 1 000.00 The company does not use a predetermined rate for factory overhead. The rate is computed at the end of each month. Required Use both the direct labour hours and machine hours to compute: 1) The overhead rates for the month (5 pts) 2) The overhead cost for each job (5pts) 3) The total cost for each job (10 pts) 4) Briefly describe the difference between Job order and process costing, citing relevant examples (5 pts).
What is subquery? Explain the properties of a subquery?
PLEASE SEND ME THE TTA EXAMS PREVIOUS PAPERS TO PREPARE TTA2009
Is json is a programming language?
What qualities have you got that would make you a good accountant?
What about pricing for the new office 365 for business offerings?
PLEASE SEND FAQ FOR NETWORK ADMINISTRATOR
Why did you decide to pursue your career at Subway?
Did you deploy BizTalk more than one machine?
sir,i have L&T infotech campus placements in the next week. can u please send me the actual procedure,previous written test papers and technical questions?
hi iam ram can any one help me in how to get previous test papers for JMGs 1 promotion exam which were published by js institute banglore
