1 / 10

Databases

Databases. 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.

babrego
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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;

  6. 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

  7. 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

  8. 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

  9. 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

More Related