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 structure that can store information about multiple types of entities - the attributes of these entities and the relationships among those entities






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






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






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






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






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






7. A Characteristic or property of an entity






8. The column on which two tables are joined






9. The plural of Criterion






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






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






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






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






14. A word that is part of the SQL language






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






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






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






18. The plural of Criterion






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






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






21. A view that consists of a subset of the rows and columns in a table






22. The rule that no column (attribute) that is part of the primary key may accept null values






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






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






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






27. The column on which two tables are joined






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






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






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






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






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






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






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






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






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






37. The prevention of unauthorized access to a database






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






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






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






41. Two tables are union compatible if they have the same number of fields and if their corresponding fields have identical data types






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






43. The portion of the system catalog that contains index information






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






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






46. An index built on a single field






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






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






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






50. A combination of two tables consisting of all records that are in either table