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 plural of Criterion






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






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






4. The most common form of a join






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






6. The relational algebra command for performing the intersection of two tables






7. A word that is part of the SQL language






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






9. What type of an operator is >= ?






10. The SQL command that drops (deletes) and index from a table






11. The portion of the system catalog that contains table information






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






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






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






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






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






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






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






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






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






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






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






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






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






25. The portion of the system catalog the contains column information






26. A collection of relations






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






28. The SQL command that is used to change the structure of a table






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






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






31. An instruction by a user that directs a database to perform a certain way






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






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






34. A characteristic or property of an entity






35. The combination of two or more rows in an operation - such as a join - or the combination of two or more columns for a primary key field to uniquely identify a given row in a table






36. The part of an SQL SELECT command that restricts the groups to be displayed






37. A punctuation mark - such as a semicolon - that separates pieces of data






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






39. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null






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






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






42. A Characteristic or property of an entity






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






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






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






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






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






48. A characteristic or property of an entity






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






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