Relational database

What should a primary key contain?

• A lot of different values
• A null value
• An unique value

What is the correct way to begin your SQL query if you want to displays data that is stored in a specific table?

• COLLECT
• COMBINE
• SELECT
• CHOOSE

What is the expected output from following SQL Query:
SELECT title
FROM videogames
WHERE title LIKE  '%2'

• It will only show video games which contains the character 2 somewhere in the title
• It will only show  videogames which begins with the character 2 in the title
• It will only show videogames which ends with the character 2 in the title

Is it possible to have duplicated foreign keys in a joining table?

• YES

• NO

What is a relational database?

• A relational database organizes data into tables, and links them together, based on key-fields. These relationships enable you to retrieve and combine data from one or more tables with a single query
• A relational database arranges data into a tree structure, which is similar to folders and files on a computer. 

Which SQL reserved keyword do you use to combine data from two or more tables, based on a common field between them?

• using SELECT
• using JOIN
• using WHERE
• using GET

What is the expected output from following SQL Query:
SELECT title
FROM videogames
WHERE title LIKE  '4%'

• It will only show video games which contains the character 4 somewhere in the title
• It will only show video games which begins with character 4 in the title
• It will only show video games which ends on the character 4  in the title

How do you communicate with your database?

• By using HTML
• By using JavaScript
• By using Structured Query Language (SQL)
• By using PHP

What do we do in the database requirement stage?

• Analyse and try to get a clear understanding of the end user requirements specifying which data the future database system will hold

• Try to implement the physical database

• Try to develop the Front End

What is SQL ?

• It is a programming lanuage
• It is a declarative language
• It is a markup language