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 relational data manipulation language in which new tables are created from existing tables through the use of a set of operations






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






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






4. An index built on a single field






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






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






7. An access tool that provides documentation about the objects in a database






8. The plural of Criterion






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






10. A query in SQL that appears within another






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






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






13. The individual who is responsible for a database or the head of database administration






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






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






16. The prevention of unauthorized access to a database






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






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






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






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






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






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






23. The SQL command used to make changes to existing table data






24. What type of an operator is >= ?






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






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






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






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






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






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






31. The field on which data are sorted






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






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






34. The portion of the system catalog the contains column information






35. The individual who is responsible for a database or the head of database administration






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






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






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






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






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






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






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






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






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






45. An index built on a single field






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






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






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






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






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