CIS 331: Database Management Using SQL

Review for First Test

 

1. What do your texts list as some problems with spreadsheets? Why is a DBMS preferable?
   
   
2. What other words are used as synonyms for "entity"?
   
   
3. What is a relationship?
   
   
4. What are the differences one-to-one, one-to-many, and many-to-one relationships?
   
   
5. What is the general term for the data structure in which spreadsheets and DBMSs both store data?
   
   
6. Can a database store information about multiple types of entities? If so, how?
   
   
7. How are relationships implemented in a relational database?
   
   
8. What do you call the process of creating the structure of a database?
   
   
9. What are integrity constraints? Give an example.
   
   
10. What is meant by data independence?
    
    
11. What makes a database relational?
    
    
12. What is an attribute? What are some other terms that mean the same thing?
    
    
13. How are attributes generally arranged in a table?
    
    
14. What do rows generally represent in a table?
    
    
15. What uniquely identifies each row in a table?
    
    
16. What are the rules for calling a table a relation?
    
    
17. What term is used for a relation that does not meet one of the tests of a relation?
    
    
18. What do we mean by the intersection of two tables? What is the union of two tables?
    
    
19. Give an example of SQL having a free-format syntax.
    
    
20. How must commands end in MySQL?
    
    
21. What key can you press in the SSH client to scroll through previous commands?
    
    
22. What are the data types listed in the text that are commonly used with SQL?
    
    
23. What SQL command is used to make an empty table?
    
    
24. What SQL commmand is used to add data to tables?
    
    
25. How do you prevent NULL characters from being allowed in particular fields?
    
    
26. What is a NULL value?
    
    
27. What SQL command is used to display the structure of a table, not the data in it?
    
    
28. What notation is used to refer to the same column in different tables?
    
    
29. What does the phrase "single-valued" mean, with regard to data tables?
    
    
30. What is the acronym for a query method that allows you to fill in forms to create queries?
    
    
31. What wildcard is used in MySQL to stand for all fields?
    
    
32. How do you phrase an SQL command in order to see all rows in a table?
    
    
33. How are Boolean operators used in SQL?
    
    
34. When sorting the results of a query, what do we call the column that we do the first sort on? What do we call the second column we sort on?
    
    
35. What do you call a query that changes data?
    
    
36. What SQL command is used to erase a data table?
    
    
37. What kind of algebra is described in the text? Is it identical to SQL?
    
    
38. What is a query?
    
    
39. What is an example of an optional clause to the SELECT command?
    
    
40. Which clause of the SELECT command names the fields to be shown? Which clause names the table?
    
    
41. What are the comparison operators? What are their meanings?
    
    
42. Is SQL case sensitive? What aspect to our classroom environment is case sensitive?
    
    
43. What is the purpose of the NOT operator?
    
    
44. In MySQL, what is the wildcard character that may be used with the LIKE operator? What is its purpose?
    
    
45. What SQL command is used to sort results of a query?
    
    
46. What do you do to change an SQL sort command to work in descending order?
    
    
47. What are the aggregate functions in SQL? Which one does not require a numeric field to work?
    
    
48. What are nested queries? In what order are they evaluated?