tobidosumu

1 a. 10 differences between the 4 types of table join queries: INNER JOIN, LEFT JOIN, RIGHT JOIN and Full OUTER JOIN.

      Answer:
      
      
      Definition of the 4 types of table join queries in SQL are:

      I. INNER JOIN: 
          This type of join returns only the matching records between two tables based on a common column. 
          Inner join combines rows from two tables that have matching values in both tables.

tobidosumu

1. Write a 500 words explaining the tech behind Postgres and SQL.
    
    I. Introduction
        SQL and PostgreSQL are two widely used database management systems that are used to store and manage large amounts of data. 
        In this article, we will be exploring the technology behind these two systems and why it is important to understand their inner 
        workings.

        A. Definition of SQL and PostgreSQL
           SQL, also known as Structured Query Language, is a standard language for managing and organizing data stored in relational 
           databases. It is used to insert, update, delete, and retrieve data from a database. On the other hand, PostgreSQL is an 

tobidosumu

1.aI. Write out all the 7 GDPR principles

      i. Lawfulness, fairness, and transparency: Personal data must be processed in a lawful, fair, and transparent manner. 
         Individuals must be informed of how their data is being used and must give their consent for it to be used.

     ii. Purpose limitation: Personal data must be collected for specific, explicit, and legitimate purposes, and must 
         not be further processed in a way that is incompatible with those purposes.

    iii. Data minimization: Personal data must be adequate, relevant, and limited to what is necessary for the purposes 
         for which it is processed.

tobidosumu

1.a. By the end of next year, state 5 programming languages/frameworks you will be writing
    
    I.    Laravel
    II.   Angular
    III.  React
    IV.   Vue
    V.    React Native
  
  b. What is your most preferred programming stack
    

tobidosumu

2. a. Write 10 differences between ES5 and ES6

    Answer:
    1. ES5 is the fifth edition of the ECMAScript (a trademarked scripting language specification defined by ECMA International).
       ES6 is the sixth edition of the ECMAScript (a trademarked scripting language specification defined by ECMA International).
       
    2. ES5 was introduced in 2009.
       ES6 was introduced in 2015.
       
    3. ES5 supports primitive data types that are string, number, boolean, null, and undefined.

tobidosumu

1. a. Why do we need status code?

        An HTTP status code is a server response to a browser's request. When you visit a website, 
        your browser sends a request to the site's server, and the server then responds to the browser's 
        request with a three-digit code: the HTTP status code.

        Status and error codes refer to a code number in the response header that indicates 
        the general classification of the response — for example, whether the request was 
        successful (200), resulted in a server error (500), had authorization issues (403), 
        and so on.  

tobidosumu

1	ai. List 5 differences between arguments and parameters

		Answer:
	
		1. When a function is called, the values that are passed during the call are called as arguments.
			 The values which are defined at the time of the function prototype or definition of the function are called as parameters.
			 
		2. These are used in function call statement to send value from the calling function to the receiving function.
			 These are used in function header of the called function to receive the value from the arguments.
			 

tobidosumu

Question 1
List 10 SQL Database types excluding MySQL and Postgres/PostgreSQL.

	Answer:
	1. SAP IQ
	2. Spark SQL 
	3. CockroachDB
	4. Amazon Aurora
	5. Elasticsearch
	6. Lovefield