Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Questions 1. What is returned from a table when using the following SQL ' Select * from tableName' 2. What does giving a field
Database Questions 1. What is returned from a table when using the following SQL ' Select * from tableName' |
2. What does giving a field an alias look like? Give an example |
3. When reading data from a database, you can make a "computed column", give an example where this would be used |
4. What are the rules of precedence? (remember your algebra), why are they important? |
5. Why is it important to store data in a database as the type of data it is? |
6. What SQL clause is used to list all unique values? |
7. What is the preferred choice of join? Why? (three types, Join On, Join Using, Natural Join) |
8. Give 3 reasons you may want to alias a table name in a query? |
9. When is it required to give a table name an alias? |
10. What is the default way a database will order data when using an order by? |
11. What SQL syntax do you want to use if you want to order items in "reverse" order? |
12. If you wanted to retrieve all results from a table (person) that had your same last name (lname), what would the conditional restriction syntax be? |
13. Would you have to use quotes in your conditional statement if your data was classified as numeric? |
14. What does an OR do in SQL? |
15. What does an AND do in SQL? |
16. Why are parenthesis important when using AND and OR statements? |
17. What operator would you use if you wanted to retreive all values in a table, but exclude one result? (example, give me all values in the student table except the students with the last name of 'Leonard') |
18. What one word operator would you use if you wanted to retreive all values that greater than 10 but less than 20? |
19 . What operator would you use if you wanted to retreive all values in a table that started with 'Smi'? |
20. What operator would you use to return all values in a table that are null? |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started