Interview Questions for SQL Beginners & experienced
What is data ? Any facts need to be stored for future purpose Called data. Data cannot give any information. Data can structured or unstructured. Structured 🡪 empname , address . Unstructured 🡪 empphoto , addmap . What is information ? The processed data can be called as information. This information gives meaning. What is database ? It is a collection of interrelated data, i.e is it is always stored Data along with it’s relations. What is metadata ? It is data which describes the properties or characteristics of End user data and context of the data. What is entity ? It is significance about the information need to know. Difference between char and varchar2 ? char Varchar2 It is fixed length char it is dynamic char..datatype When gives sting lessthan orginal string Blonk pad are generated. Blank pads are not generated , memory gives return (reuse) when string lesst...