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






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






3. A collection of relations






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






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






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






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






8. The field on which data are sorted






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






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






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






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






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






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






15. The part of an SQL SELECT command that restricts the groups to be displayed






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






17. The most common form of a join






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






19. An association between entities






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






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






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






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






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






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






26. The field on which data are sorted






27. The column on which two tables are joined






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






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






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






31. A column (attribute) or collection of columns in a table whose value is required either to match the value of a primary key in a table or to be null






32. The area of memory in MySQL that stores the most recently entered command






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






34. The SQL command that creates an index in a table






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






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






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






38. A Characteristic or property of an entity






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






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






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






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






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






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






45. A collection of relations






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






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






48. A word that is part of the SQL language






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






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