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. More than one entry at a single location in a table






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






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






4. A data manipulation language for relational databases in which users indicate the action to be taken by completing on-screen forms






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






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






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






8. A collection of relations






9. A Characteristic or property of an entity






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






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






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






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






14. In Access the query that updates the contents of a table






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






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






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






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






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






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






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






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






23. An index built on a single field






24. The field on which data are sorted






25. A word that is part of the SQL language






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






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






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






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






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






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






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






33. An index built on more than one field






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






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






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






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






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






39. The SQL command used to delete a table






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






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






42. The prevention of unauthorized access to a database






43. A collection of relations






44. A characteristic or property of an entity






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






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






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






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






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






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