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 most common form of a join






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






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






4. An association between entities






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






6. The field or fields on which an index is built






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






8. The prevention of unauthorized access to a database






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






10. A file that relates key values to records that contain those key values






11. The table obtained by concatenating every row in the first table with every row in the second table






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






13. An index built on more than one field






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






15. A rule in Access that data entered in a field must satisfy






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






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






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






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






20. A collection of relations






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






22. The field on which data are sorted






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






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






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






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






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






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






29. An association between entities






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






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






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






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






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






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






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






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






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






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






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






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






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






43. The table obtained by concatenating every row in the first table with every row in the second table






44. The query that is used to define the structure of a viewk






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






46. A Characteristic or property of an entity






47. The SQL command used to describe the layout of a table. The word table is followed by the name of the table to be created and then by the names and data types of the column (fields) that comprise the table






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






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






50. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)