Relational Databases vs Flat Files: Advantages and Best Practices

1. Databases

2. What is the primary value add of relational databases over flat files? • Ability to store data in a format that can be sent across a network • Ability to quickly convert data to HTML • Ability to scan large amounts of data quickly • Ability to execute PHP code within the file

3. Which command is used to retrieve all records from the table? • RETRIVE * FROM Users • SELECT * FROM Users • RETRIEVE all FROM Users • SELECT all FROM Users

4. Which keyword will cause the results of the query to bedisplayed in sorted order? • ORDER BY • WHERE • GROUP BY • None of these

5. Which of these is the right syntax to make a new database? • MAKE DATASET people; • MAKE people; • CREATE people; • CREATE DATABASE people;

7. Which of the following is NOT a good rule to follow when developing a database model? • Use a persons email address as their primary key • Use integers as primary keys • Never repeat string data in more than one table in a data model • Each "object" in the application should be modeled as one or more tables

8. Which of the following is the label we give a column that the "outside world" uses to look up a particular row? • Logical key • Primary key • Foreign key • Local key • Remote key

9. What is the label we give to a column that is an integer and used to point to a row in a different table? • Logical key • Primary key • Foreign key • Local key • Remote key

10. What MySQL keyword is added to primary keys in a CREATE TABLE statement to indicate that the databaseis to provide a value for the column when records are inserted. • PRIMARY • INSERT_AUTO_PROVIDE • AUTO_INCREMENT • ASSERT_UNIQUE