SQL

Question 1

Keys

Answer 1

Fields in a table that are used to identify specific rows

Question 2

Tables

Answer 2

Tables are used to store and structure data in SQL. They are organized as rows and columns

Question 3

Statements

Answer 3

Is the code used to retrieve or manipulate data in SQL

Question 4

Joins

Answer 4

A JOIN clause is used to combine rows from two or more tables, based on a related column between them

Question 5

Updates

Answer 5

Statement used to modify the existing records in a table

Question 6

Deletes

Answer 6

Deletes a record in a table

Question 7

Stored Procedures

Answer 7

A saved statement or group of statements that can be reused. Saves time on repetitive tasks.

Question 8

Primary Key

Answer 8

A primary key is the unique identifier for records in a table. Usually it’s just an ID number

Question 9

How do you extract information from a table?

Answer 9

You can use a SELECT statement to simply retrieve information or even SELECT INTO OUTFILE to extract the information into a document.

Question 10

What is a JOIN statement?

Answer 10

A statement that joins 2 or more rows from tables