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. An index built on more than one field






2. The query that is used to define the structure of a viewk






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






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






5. The prevention of unauthorized access to a database






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






7. A characteristic or property of an entity






8. An association between entities






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






10. The SQL clause that is used in a CREATE TABLE or ALTER TABLE command to set a table's primary key field(s)






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






12. A two-dimensional table-style collection of data in which all entries are single-valued - each column has a distinct name and all the values in a column are values of the attribute that is identified by the column name - and the order of the columns






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






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






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






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






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






18. The SQL command used to delete a table






19. More than one entry at a single location in a table






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






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






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






23. A characteristic or property of an entity






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






25. A delete option in which related records are automatically deleted






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






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






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






29. The prevention of unauthorized access to a database






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






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






32. The most common form of a join






33. A message in Access that is displayed when a validation rule is violated






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






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






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






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






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






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






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






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






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






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






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






45. When comparing tables the set of all rows that are in the first table but that are not in the second table






46. Duplication of data or the storing of the same data in more than one place.






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






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






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






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






Can you answer 50 questions in 15 minutes?



Let me suggest you:

Browse all subjects

Browse all tests

Most popular tests



Major Subjects

Tests & Exams


AP
CLEP
DSST
GRE
SAT
GMAT

Browse all subjects

Browse all tests

Most popular tests