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 database has integrity if the data in it satisfies all established integrity constraints






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






3. The plural of Criterion






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






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






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






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






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






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






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






11. The SQL command used to delete a table






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






13. The plural of Criterion






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






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






16. The part of an SQL SELECT command that indicates the tables in the query






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






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. A program or a collection of programs through which users interact with a database






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






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






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






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






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






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






26. An association between entities






27. A condition that involves only a single field and a single value






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






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






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






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






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






33. The prevention of unauthorized access to a database






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






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






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






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






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






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






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






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






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






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






44. A collection of relations






45. The relational algebra command to select rows from a table






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






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






48. A combination of criteria in which at least on the criteria must be true






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






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