Test your basic knowledge |

Database Fundamentals

Subject : it-skills
Instructions:
  • Answer 50 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. In an Access query the line drawn between tables to indicate how they are related






2. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table






3. A screen object you use to maintain or view and print data from a database






4. A structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities






5. A characteristic or property of an entity






6. A delete option in which related records are automatically deleted






7. A Characteristic or property of an entity






8. An index built on a single field






9. An index built on more than one field






10. The SQL command used to add new data to a table






11. The relational algebra command for performing the difference of two tables






12. In Access the query that updates the contents of a table






13. The column on which two tables are joined






14. The relational algebra command to select rows from a table






15. A question the answer to which is found in the database






16. A file containing a collection of compiled and optimized SQL statements that are available for future use






17. Duplication of data or the storing of the same data in more than one place.






18. More than one entry at a single location in a table






19. The part of an SQL SELECT command that indicates a sort order






20. When sorting on two fields this is the more important field






21. An association between entities






22. The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users






23. The column on which two tables are joined






24. A relational data manipulation language in which new tables are created from existing tables through the use of a set of operations






25. An application program's or an individual user's picture of a database






26. A collection of actions in Access that are performed in response to an associated database operation - such as inserting or updating or deleting records.






27. The prevention of unauthorized access to a database






28. When sorting on two fields - the less important field






29. The area of memory in MySQL that stores the most recently entered command






30. The individual or group that is responsible for a database






31. The property that no record can exist in the database with a value in a field other than a legal value






32. Duplication of data or the storing of the same data in more than one place.






33. An access query that creates a table using the results of a query






34. The SQL command used to make changes to existing table data






35. The SQL command that creates an index in a table






36. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate






37. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate






38. The most common form of a join






39. A view that consists of a subset of the rows and columns in a table






40. An association between entities






41. A screen object you use to maintain or view and print data from a database






42. The individual who is responsible for a database or the head of database administration






43. A combination of two tables consisting of all records that are in either table






44. A field whose value is computed from other fields in the database






45. The property that lets you change the structure of a database without requiring you to change the programs that access the database






46. When comparing tables the set of all rows that are in the first table but that are not in the second table






47. Additional information required by an action in a data macro to complete the action






48. An index built on more than one field






49. A question the answer to which is found in the database






50. The property that lets you change the structure of a database without requiring you to change the programs that access the database