SQL Star Placement Papers
SQL Star Technical Test Questions
SQL Star Aptitude, Technical Test 25th November 2011
SQL Star Written Test 10th October 2012
Placement Papers for All Companies
Amiti Software Technologies
Ashok Leyland Ltd
AT & T
AXA Technology Services
Bharti Airtel Ltd
Blue Star Infotech
Citicorp Overseas Software Ltd
CtrlS Datacenters Ltd
Ernst & Young
Harita - TVS
HTC Global Services
IBS Software Services
IndiaBulls Power Limited
Jindal Steel and Power Limited
L & T
L & T Infotech
Linde India Ltd
Lucas - TVS
Mahindra Engineering Services Ltd
Poornam Info Vision
PSI Data Systems Limited
SAP labs India
Sutherland Global Services
UTC Aerospace System
SQL Star Interview Questions
Posted on :09-04-2016
Q1. What is mutex?
Q2. What is the reference by value how does it works in .net?
Q3. What is the Magic Tables in SQL server 2000?
Q4. How to handle the exceptions in SQL server 2000?
Q5. How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?
RDBMS Interview Questions:
Q6. What command is used to get back the privileges offered by the GRANT command?
Q7. What is the difference between TRUNCATE and DELETE commands?
Q8. What is the difference between SQL and SQL Server?
Q9. How to store directory structure in a database?
Q10. What are cluster, cluster index and non cluster index?
Q11. What is materialized View?
Q12. What is the difference between DBMS and RDBMS?
Q13. What is reference cursor?
Q14. What is the parameter substitution symbol used with INSERT INTO command?
Q15. State true or false. !=, <>, ^= all denote the same operation.
Q16. Which command displays the SQL command in the SQL buffer, and then executes it?
Q17. Which system tables contain information on privileges granted and privileges obtained?
Q18. What are the wildcards used for pattern matching?
Q19. Which system table contains information on constraints on all the tables created?
Q20. What are the privileges that can be granted on a table by a user to others?
Q21. State true or false. EXISTS, SOME, ANY are operators in SQL.
Q22. How to find out the 10th highest salary in SQL query?
Q23. How to test the complex view using manually testing?
Q24. What is the advantage to use trigger in your PL?
Q25. How write a SQL statement to query the result set and display row as columns and columns as row?
Q26. What is the difference between UNION and UNIONALL?
Q27. What is the main difference between the IN and EXISTS clause in sub queries?
Q28. How to write a SQL statement to find the first occurrence of a non zero value?
Q29. When using a count (distinct) is it better to use a self-join or temp table to find redundant data.
Q30. In sub queries, which is efficient, the IN clause or EXISTS clause? Does they produce the same result?
Q31. If Delete Any Table In Back-End Then. What are the triggers will Fire Automatically?
Q32. What operator performs pattern matching?
Q33. What command is used to create a table by copying the structure of another table?
Q34. How to copy SQL table?
Q35. How can we backup the SQL files & what is SAP?
Q36. What is the difference between an equijoin and a union?
Q37. How can I hide a particular table name of our schema?
Q38. What is database?
Q39. What is the difference between Store Procedure and Trigger?
Q40. What is the difference between Single row sub-Query and Scalar sub-Query?
Q41. What is the use of the DROP option in the ALTER TABLE command?
Q42. Explain normalization with examples?
Q43. What is table space?
Q44. How to find out the database name from SQL*PLUS command prompt?
Q45. What is the difference between Co-related sub query and nested sub query?