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 statement the can be either true or false. Also called a condition






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






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






4. A delete option in which related records are automatically deleted






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






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






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






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






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






10. A query in SQL that appears within another






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






12. An access query that creates a table using the results of a query






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






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






15. The SQL clause that is used to enforce legal-values integrity






16. A file containing a collection of compiled and optimized SQL statements that are available for future use






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






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






19. A Characteristic or property of an entity






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






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






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






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






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






25. A characteristic or property of an entity






26. A collection of relations






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






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






29. A minimal collection of columns (attributes) in a table on which all columns are functionally dependent and that is chosen as the main direct-access vehicle to individual rows.






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






31. A collection of relations






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






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






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






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






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






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






38. A characteristic or property of an entity






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






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






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






42. The column on which two tables are joined






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






44. A collection of relations






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






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






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






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






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






50. An association between entities