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. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms






2. A statement the can be either true or false. Also called a condition






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






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






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






6. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column






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






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






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






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






11. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on






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






13. A condition that involves only a single field and a single value






14. A Characteristic or property of an entity






15. A collection of relations






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






17. An association between entities






18. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE






19. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column






20. A database has integrity if the data in it satisfies all established integrity constraints






21. A rule that must be followed by data in a database






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






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






24. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column






25. The form of a join in which all records appear - even if they don't match






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






27. A characteristic or property of an entity






28. A rule that must be followed by data in a database






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






30. The part of an SQL SELECT command that indicates the columns to be included in the query results






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






32. Combination of criteria in which both criteria must be true






33. The prevention of unauthorized access to a database






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






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






36. What type of an operator is >= ?






37. A characteristic or property of an entity






38. To indicate the table (relation) of which a given column (attribute) is a part by preceding the column name with the table name.






39. A function used to calculate the number of entries and the sum or average of all the entries in a given column or the largest or smallest of the entries in a given column






40. A combination of criteria in which at least on the criteria must be true






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






42. The column on which two tables are joined






43. A file used to store data about a single entity. Such a file can be thought of as a table.






44. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database






45. 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






46. In relational algebra the operation in which two tables are connected on the basis of common data.






47. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on






48. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity






49. When comparing tables an intersection is a new table containing all rows that are in both original tables






50. A Characteristic or property of an entity