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 file used to store data about a single entity. Such a file can be thought of as a table.






2. A Characteristic or property of an entity






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






4. A characteristic or property of an entity






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






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






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






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






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






10. The portion of the system catalog that contains table information






11. The SQL command used to add new data to a table






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






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






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






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






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






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






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






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






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






21. An association between entities






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






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






24. An index built on more than one field






25. The SQL clause that is used to enforce legal-values integrity






26. When comparing tables an intersection is a new table containing all rows that are in both original tables






27. A characteristic or property of an entity






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






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






30. The SQL command used to delete a table






31. A Characteristic or property of an entity






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






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






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






35. The column on which two tables are joined






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






37. A file that relates key values to records that contain those key values






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






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






40. A query in SQL that appears within another






41. The plural of Criterion






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






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






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






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






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






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






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






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






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