SQL Basics

Question 1

Define Relational Database

Answer 1

database that organizes information into one or more tables

Question 2

Define Table

Answer 2

A collection of data organized into rows and columns

Question 3

What is another name for a Table?

Answer 3

Relation

Question 4

Define Column

Answer 4

a set of data values of a particular type

Question 5

Define Row

Answer 5

a single record in a table

Question 6

What are 4 common data types?

Answer 6

Integer, Text, Date, and REal

Question 7

Define Integer

Answer 7

a positive or negative WHOLE number (example, 19)

Question 8

Define Text

Answer 8

a string of text (example, ‘Gotham City’)

Question 9

Define Date & how formatted

Answer 9

date formatted as YYYY-MM-DD

Question 10

Define Real

Answer 10

a decimal value (example, 1.2)

Question 11

Define Statement

Answer 11

text that the database recognizes as a valid command

Question 12

What does EVERY statement end with in SQL?

Answer 12

a semicolon ;

Question 13

What are the 3 components of a statement?

Answer 13

1. Clause
2. Table Name
3. Parameter

Question 14

Define Clause

Answer 14

Performs specific task in SQL

Question 15

How are clauses written in SQL?

Answer 15

ALL CAPS

Question 16

What are clauses also known as?

Answer 16

Commands

Question 17

Define Parameter

Answer 17

list of columns, data types, or values that are passed to a clause as an argument

Question 18

Do the number of lines in a string of code affect the outcome in SQL?

Answer 18

NO!!

Question 19

Do SQL statements need to be written all on one line, or can they be split up across multiple lines for legibility?

Answer 19

They can be split up into multiple lines