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 rule that must be followed by data in a database






2. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms






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






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






5. A collection of relations






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






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






8. An index built on a single field






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






10. The process of creating collections of records that share some common characteristics






11. The SQL command that drops (deletes) a table from a database






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






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






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






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






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






17. The process of arranging rows in a table or results of a query in a particular order






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






19. An update option in which related records are automatically updated






20. An index built on more than one field






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






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






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






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






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






26. The process of arranging rows in a table or results of a query in a particular order






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






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






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






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






31. The column on which two tables are joined






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






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






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






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






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






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






38. What type of an operator is >= ?






39. The portion of the system catalog that contains view information






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






41. An association between entities






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






43. A word that is part of the SQL language






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






45. An association between entities






46. The prevention of unauthorized access to a database






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






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






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. A rule that must be followed by data in a database