Section 4 Answer Key
- What does SQL stand for?
- Standard Query Linguistics [Incorrect]
- Structured Query Language [Correct!]
- Strict Query Language [Incorrect]
- None of the above [Incorrect]
- Which of these is used to retrieve information from a database?
- Get [Incorrect]
- Fetch [Incorrect]
- Select [Correct!]
- Find [Incorrect]
- Which of these commands would get the name column from a Persons table?
- Select name from Persons; [Correct!]
- Get persons.name [Incorrect]
- Select persons.name [Incorrect]
- Get name from Persons [Incorrect]
- Which of the following select records where the name fields starts with an A?
- Select * from Persons where name=’a’ [This will get names that are only a]
- Select * from Persons where name like “a%” [Correct!]
- Select * from Persons where name like “%a” [This will select things that end in a]
- None of these [Incorrect]
- Which of the following is the keyword used to sort results?
- Order By [Correct!]
- Sort By [Incorrect]
- Filter By [Incorrect]
- Ascending [Incorrect]
- Which of the following is used to find the number of records?
- Total() [Incorrect]
- Count() [Correct!]
- Sum() [Incorrect]
- None of these [Incorrect]
- Eliminating multiple identical columns from a table is which normalization?
- First [Correct!]
- Second [Incorrect]
- Third [Incorrect]
- Fourth [Incorrect]
- Eliminating repeated values from a table is which normalization?
- First [Incorrect]
- Second [Correct!]
- Third [Incorrect]
- Fourth [Incorrect]
- Ensuring no values are repeated in a database is which of the following?
- First [Incorrect]
- Second [Incorrect]
- Third [Correct!]
- Fourth [Incorrect]
- Ensuring all fields relate directly to the table they are in is which normalization?
- First [Incorrect]
- Second [Incorrect]
- Third [Correct!]
- Fourth [Incorrect]
- The CRUD actions are:
- Compose, Read, Update, Delete [Incorrect]
- Create, Read, Update, Destroy [Incorrect]
- Create, Read, Update, Delete [Correct!]
- Copy, Read, Update, Drop [Incorrect]
- Including all of the records in the first table of a join is done using:
- Join all [Incorrect]
- Left join [Correct!]
- Right join [Incorrect]
- None of these [Incorrect]
- Queries can be placed inside of other queries.
- True [Correct!]
- False [Incorrect]
- Which of the following is used to remove a record from a table?
- Delete from [Correct!]
- Drop from [Incorrect]
- Destroy [Incorrect]
- MySQL requires which of the following to run?
- Windows [Incorrect]
- Linux [Incorrect]
- Apple [Incorrect]
- Any of these [Correct!]