Relational database

Is the Entity Relationship Model used to make a Conceptual Database Model?

• Yes
• No

What is E-R model used for?

• To extract content  from the database
• To design and visualize database
• To create a graphical user interface

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 dublicated foreign keys in a helping 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