Posts

Interview Questions for SQL Beginners & experienced

Image
  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...