SQL

Question 1

How do you create a database in SQL?

Answer 1

CREATE DATABASE example_name

Question 2

How do you create a Table with Columns and a designated Primary Key in SQL?

Answer 2

CREATE TABLE table_name (
row_name_one DATA TYPE(100),
row_name_two DATA TYPE(200,
row_name_three DATA TYPE(300),
PRIMARY KEY (row_name_one)
);

Question 3

You have three tables called Course, Student and Enrollment. These tables need to be linked with each other. Which of the following keys can you use to establish these relationships?

Answer 3

Primary Key and Foreign Key

Question 4

PRI

Answer 4

comes from primary; this means it’s a primary key.

Question 5

UNI

Answer 5

comes from unique; this means it’s a unique key.

Question 6

MUL

Answer 6

comes from multiple. If the key is MUL, it means that the related column is permitted to contain the same value in multiple cells of that column.