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. Two simple criteria in a query the are combined with the AND or OR operators






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






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






4. A very popular relational data definition and manipulation language that is used in many relational DBMS's






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






6. A collection of relations






7. An association between entities






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






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






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






11. The part of an SQL SELECT command that indicates the condition rows must satisfy to be displayed in the query results






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






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






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






15. What type of an operator is >= ?






16. The field on which data are sorted






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






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






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






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






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






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






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






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






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






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






27. An index built on a single field






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






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






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






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






32. The most common form of a join






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






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






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






36. A characteristic or property of an entity






37. The rule that if table A contains a foreign key that matches the primary key of table B then the value of this foreign key must either match the value of the primary key for some row in table B or be null






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






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






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






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






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






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






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






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






46. An index built on more than one field






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






48. A characteristic or property of an entity






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






50. An association between entities