SQL

Question 1

What is SQL?

Answer 1

SQL is used to retrieve and manipulate data in DBMSs.

More focused on what to retrieve, delete or insert.

Question 2

What is a data type?

Answer 2

The specific type of data a column can hold

Question 3

ORDER BY

Answer 3

sorts the column in either ASC or DESC order

Question 4

What is a foreign key?

Answer 4

Columns that have values linked with other tables

Question 5

What does it mean to normalize?

Answer 5

Taking a database and applying a set of formal rules (NF1, NF2, NF3 depending on how the data is structured). Reduces redundancy and makes the database more flexible

Question 6

What is a primary key?

Answer 6

A field that provides a unique key to every row in a table

Question 7

What is a query?

Answer 7

A question/command concerning data from the database

Question 8

What are parts of a query?

Answer 8

Clause, keyword, statement

Question 9

What is a clause?

Answer 9

Clauses are segments of SQL statements that can combine to form a complete statement

Question 10

What is a keyword?

Answer 10

words like SELECT and FROM that allow you to communicate with a database