Enter Title

Basic Knowledge

100

What does SQL Stand for?

Structured Query Language

200

When was SQL first developed?

1970

300

What company first developed SQL?

IBM

400

What was SQL originally called? 

SEQUEL

500

Who was the first developer of SQL?

Donald Chambelin

Data Types

100

Name 3 different data types?

Int, varchar, text, char, decimal, date

200

What are the max amount of characters varchar can use?

255

300

What is the syntax of the 'date' datatype?

date: (yyyy-mm-dd)

400

What is the different between char and text?

Char is for one character, text is for many characters.

500

 In MySQL, this data type is commonly used to store large amounts of text, but it cannot be indexed efficiently like.

Varchar

Commands

100

Name me four of our basic SQL commands.

SELECT, INSERT, DELETE, UPDATE

200

What command can we use to add data into our table?

INSERT

300

Give the Code that would select all the students from a table called 'Students', given the student has an A 

Select * from students where grades = 'A';

400

Give the syntax used to modify a record in a table, given a condition.

UPDATE tableName set column1 = 'value1', column2 = 'val2' where condition;

500

Give the code that would insert 3 records into the table "student_Info" (Fields include name, grades, class)

INSERT INTO student_Info (name, grades, class) VALUES ('John Doe', 85, 'Physics');
INSERT INTO student_Info (name, grades, class) VALUES ('Jane Smith', 92, 'Mathematics');
INSERT INTO student_Info (name, grades, class) VALUES ('Alex Johnson', 78, 'Chemistry');

Data Integrity

100

What is data integrity?

Refers to accuracy to consistency and reliability

200

Name the 4 types of data integrity

Entity, referential, domain, and user-defined.

300

Why is data integrity important? (3 reasons)

> To not duplicate records in our table (or extra tables)

-> Ensuring that data is valid

-> Avoids inconsistencies

400

How many levels do constraints have, and for what are those levels for?

Constaints have two levels: Column level, or table level 

-Apples to either one column, or the entire table

500

Give the type of integrity that ensures that values in a column follow a set amount of rules.

Domain Integrity

Wild Cards

100

What does the * stand for?

All

200

What is the standard language for databases?

SQL

300

What did SEQUEL stand for?

Structured English Language

400

When was MySQL released?

1995

500

Who was the second developer of SQL?

Raymond Boyce