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. When sorting on two fields this is the more important field






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






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






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






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






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






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






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






9. The plural of Criterion






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






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






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






13. What type of an operator is >= ?






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






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






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






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






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






19. A source of data - usually stored in hidden database tables - about the types of entities or attributes and relationships in a database






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






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






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






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






24. The SQL command used to delete a table






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






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






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






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






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






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






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






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






33. A characteristic or property of an entity






34. An association between entities






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






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






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






38. The most common form of a join






39. The portion of the Query Design window in Access where you enter fields or criteria or sort orders and so on






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






41. An action that automatically occurs in response to an associated database operation such as INSERT or UPDATE or DELETE






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






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






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






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






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






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






48. The relational algebra command that combines tables and searches for rows in the first table that match all rows in the second table






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






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