Placement Papers for All Companies

3i infotech
Abacus Infotech
Abatix
Abaxis
ABB
ACC Limited
Accel Frontline
Accenture
Aditi Technologies
Adobe System
ADP
Agilysys
AgreeYa
AIG
AirNet
Alanco Technologies
Alle Technologies
Allfon
Alter Systems
Amazon
AMDL
Amdocs
AMI
Amiti Software Technologies
ANZ
Apple
Applied Materials
Apps Associates
Aricent
ASDC
Ashok Leyland Ltd
Asian Paints
Aspire System
AT & T
Atlas Copco
Atos Origin
AXA Technology Services
Axes Technology
Bain
Bajaj
Bayer
Bharti Airtel Ltd
Bhawan Cybertek
Birlasoft
Blue Star Infotech
BMC
BOB
Brakes India
C-DOT
CA Technologies
Cadence
Calsoft
Canarys
Capgemini
Caterpillar
Celstream
CGI Group
Changepond Technologies
Cimtrix Systems
Cisco system
Citicorp Overseas Software Ltd
ClinTech
CMC Limited
CMS
Cognizant
Compaq
Consagous Technologies
Convergys
CORDYS
CRISIL
Crompton Greaves
CSC
CSFB
CtrlS Datacenters Ltd
Cummins
Cyient
Daffodil
Daimler
Dell
Deloitte
Delphi-TVS
Dharma Systems
Directi
DSRC
Eicher
ELGI
ELICO
EMC Corporation
Emphasis
Ericsson
Ernst & Young
ESKO
Essar
Facebook
Fanuc Corporation
Fidelity
Flextronics
Flipkart
Freescale
Fujitsu
Gajshield
GE
Genpact India
Geodesic
Geometric Limited
GlobalEdge
GlobalLogic
GMR Group
Godrej Infotech
Google
Grapecity
Harita - TVS
HCL
HCL Technologies
Headstrong
Healthasyst
HEC Ltd
Hexaware
HFCL
Holool
Honeywell
HP
HTC Global Services
Huawei
Hughes
Hyundai
IBM
IBS Software Services
IGate
Ikanos
IKOS
Impetus
iNautix
Indecomm
IndiaBulls Power Limited
Inductis-EXL
Industrial Alliance
Infineon
Infogain
Infosys
Intec
Integra
Intel
Intergraph
ITC Infotech
Jindal Steel and Power Limited
KPIT
L & T
L & T Infotech
LG Soft
Linde India Ltd
LnT Emsys
LnT-ECC
Lucas - TVS
Mahindra Engineering Services Ltd
Mahindra Ltd
Maruti
Matrix
Maveric Systems
McAfee
Microland
Microsoft
Mindtree
Miraclesoft
MKCL
Motorola
Mu-Sigma
Nagarro
NASSCOM
NCR Corporation
Ness Technologies
Neudesic
NIIT Technologies
Novell
Nvidia
Oracle
Persistent
Philips
Planetasia
Polaris
Poornam Info Vision
PSI Data Systems Limited
Quest-Global
Quinnox
R Systems
Redpine
Reliance Energy
Robert Bosch
RS Software
Samsung
SAP labs India
Sapient
Sasken Communications
Schneider India
Serco
Siemens
Sierra Atlantic
SkyTECH
Soliton
Sonata Software
Sony India
SQL Star
Steria
Subex Limited
Sutherland Global Services
Syntel
Talisma
Tata motors
Tata technologies
Tata-ELXSI
TCE
TCS
Tech Mahindra
Temenos
Tesco
Texas Instruments
Thermax
ThoughtWorks
Torry Harris
Triad
Trianz
Trilogy
TVS Motor
Unisys
UnitedHealth Group
UST Global
UTC Aerospace System
Valuelabs
Vedanta
Verifone
Verizon
Virtusa
Vision Infotech
Vizual
VMware
Wipro
Yahoo
YASH Technologies
Zenith
Zensar Technologies
ZTE

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?


  
   






FreshersLive - No.1 Job site in India. Here you can find latest 2016 government as well as private job recruitment notifications for different posts vacancies in India. Get top company jobs for both fresher and experienced. Job Seekers can get useful interview tips, resume services & interview Question and answer. Practice online test free which is helpful for interview preparation. Register with us to get latest employment news/rojgar samachar notifications. Also get latest free govt and other sarkari naukri job alerts daily through E-mail.

closepop
closepop