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. The prevention of unauthorized access to a database






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






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






4. A collection of relations






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






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






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






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






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






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






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






12. An instruction by a user that directs a database to perform a certain way






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






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






15. A characteristic or property of an entity






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






17. What type of an operator is >= ?






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






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






20. The column on which two tables are joined






21. The most common form of a join






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






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






24. A Characteristic or property of an entity






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






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






27. The clause in a SQL CREATE TABLE or ALTER TABLE command that specifies referential integrity






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






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






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






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






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






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






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






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






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






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






38. A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity and each occurrence of the second entity is related to or at most one occurrence of the first entity






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






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






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






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






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. Combination of criteria in which both criteria must be true






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






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






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






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






49. The field on which data are sorted






50. The relational algebra command for performing the difference of two tables