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. The table obtained by concatenating every row in the first table with every row in the second table






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






3. A data value meaning "unknown" or "not applicable"






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






5. In an Access query the line drawn between tables to indicate how they are related






6. An access tool that provides documentation about the objects in a database






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






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






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






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






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






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






13. The portion of the system catalog that contains index information






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






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






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






17. The plural of Criterion






18. A collection of relations






19. A query that deletes all records that satisfy some criterion






20. A data value meaning "unknown" or "not applicable"






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






22. A structure that satisfies the properties required to be a relation with the exception of allowing repeating groups






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






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






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






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






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






28. A person or place or object or event or idea for which you want to store and process data






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






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






31. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns






32. A Characteristic or property of an entity






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






34. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.






35. What type of an operator is >= ?






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






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






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






39. The relational algebra command used to select columns from a table






40. A program or a collection of programs through which users interact with a database






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






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






43. The SQL statement that is used to revoke privileges from users of a database






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






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






46. The field on which data are sorted






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






48. Two simple criteria in a query the are combined with the AND or OR operators






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






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