This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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. |