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 source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database






2. A word that is part of the SQL language






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






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






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






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






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






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






9. A Characteristic or property of an entity






10. A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate






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






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






13. An index built on more than one field






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






15. A structure that contains information about the objects (tables or columns or indexes or views and so on) in a database






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






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






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






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






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






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






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






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






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






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






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






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






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






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






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






31. The SQL command used to delete a table






32. A characteristic or property of an entity






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






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






35. The relational algebra command for performing the intersection of two tables






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






37. An index built on more than one field






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






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






40. The portion of the system catalog that contains view information






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






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






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






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






45. A Characteristic or property of an entity






46. A collection of relations






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






48. The part of an SQL SELECT command that indicates grouping






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






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