SQL

Question 1

What is a database?

Answer 1

A database is a collection of tables with interrelated information. Databases are used to store and manage large amounts of data in a structured and organized manner, and they provide a means of accessing and manipulating this data through the use of SQL queries and commands. Databases are used for a variety of applications such as e-commerce, banking, healthcare, and education.

Question 2

SQL stand for

Answer 2

Structure Query Language - Created by Michael O’Connor

Question 3

What are the three type of SQL languages

Answer 3

Structured Query Language
Transactional SQL
Parallel SQL

Question 4

Difference between nvarchar and varchar variable-length datatypes?

Answer 4

Varchar stores NON-unicode or English character data types max 8000 characters / 1 byte of storage
Nvarchar stores Unicode or non-English character data types max 4000 characters / best for multiple langauges / requires 2 bytes of storage