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 characteristic or property of an entity






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






3. The most common form of a join






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






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






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






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






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






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






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






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






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






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






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






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






16. A message in Access that is displayed when a validation rule is violated






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






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






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






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






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






22. The SQL statement that is used to grant different types of privileges to users of a dataabase






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






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






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






26. The prevention of unauthorized access to a database






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






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






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






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






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






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






33. A collection of relations






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






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






36. An association between entities






37. The prevention of unauthorized access to a database






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






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






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






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






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






43. A Characteristic or property of an entity






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






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






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






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






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






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






50. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity