Chapter 1 Answer to O'Reilly Learning Sql on SQL Server 2005

1.19. Review Questions

1. If I want to see what fields a table is made of, and what the sizes of the fields are, what option do I have to look for?
   Expand as the sequence: [Databases]-[your database name]-[Tables]-[your table]-[Columns]
2. What is a query?
   Sql statement excuted by server
3. A SQL query is typed in the _________ .
   Query Editor
4. What is the purpose of the model database?
   Template for the new database
5. What is the purpose of the master database?
   a database composed of system tables that keeps track of server installation as a whole and all other databases that are subsequently created.
6. What is the purpose of the tempdb database?
   tempdb is a temporary database or workspace recreated every time SQL Server is restarted. tempdb is used for temporary tables created by users and to hold intermediate results created internally by SQL Server during query processing and sorting.
7. What is the purpose of the USE command?
   Change the default database to excute query in.
8. If you delete a table in the database, will the data in the table be deleted too?
   yes
9. What is the Parse Query button used for? How does this help you?
   Check query before executing.
10. Tables are created in a ____________________ in SQL Server 2005.
    Database

1.20. Exercises

2.  Write a SQL query to view all the columns and rows in the Student table. (Hint: To retrieve all columns, use SELECT * in your query; the * means "all columns"). Save and execute the query. Save the results to a file and print out the results.
SELECT * FROM Student