Test your basic knowledge |

Database Management

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. Two or more controls that can be treated as one unit while designing a form or report. You can select the group instead of selecting each individual control as you are arranging controls or assigning properties.






2. An association/link established between common fields in two different tables. A relationship can be one-to-one - many-to-many or more usually one-to-many.






3. A location within a database table that stores one particular type of data i.e. a field






4. A value that is automatically entered in a field or control when you add a new record.






5. An association between two tables in which several records in one table can relate to 0 - 1 or many records in the other table.






6. Arrange the records in a view set in order according to a particular field






7. When a relation is not just in Boyce-Codd Normal Form - but also contains at most one multivalued dependency.






8. A control - also called an edit field - used on a form - report or data access page to display text or accept data entry.It can have a label attached to it.






9. A graphical representation of any portion of a database scheme.






10. A record as seen in the data sheet view.






11. The program which is used to organize - access and manage the data in a database - Creates - processes - and administers databases.






12. A data type that is used for fields and calculations involving money






13. This is a property of data which - when satisfied - requires every value of one field (attribute) of a table to exist as a value of another field in another related table.






14. A question about the data stored in your tables - or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form. report or data access page.






15. Dependency where determinant determines a list of values.






16. A query ( SQL statement ) that creates a new table and then creates records in it by coping records from an existing table.






17. The persons or things that a database table is about.






18. An MS Access tool that simplifies a task. For example - you can quickly create a complex expression with the Expression Builder.






19. A key that consists of 2 or more attributes that uniquely identify an entity occurrence.






20. No Transitive Dependencies.






21. A relational database management system from Microsoft that combines the relational MS Jet Database Engine with a graphical user interface and software-development tools.






22. A normalization which falls between 3NF and 4NF and involves the elimination of non-trivial dependencies






23. A database object that prints information formatted and organised according to your specifications.






24. A section of a record containing data relating to one single characteristic of an entity; also called an attribute






25. A type of computer file system that stores all data in a single file.






26. Knowingly violates one or more rules of normalization.






27. The DML statement used to choose data from a database. The result is stored in a temporary table - called the result-set.






28. The window that appears when you open an Access database or an Access project. It displays the commands for creating new database objects and opening and manipulating existing objects.






29. A graphical representation of entities and their relationship to each other - typically used in computing in regard to the organization of data within databases or information systems






30. The dominant database model






31. A field - set up in a query - that displays the result of an evaluated expression rather than displaying stored data.The value of the calculated field is re-calculated each time a value in the expression changes.






32. A database object that stores data in records and fields. The data is usually about a particular category of things.






33. A query that displays a summary calculation - such as an average or a sum - for values in a table or tables. A totals query is not a seperate kind of query; rather it extends the flexibility of select queries.






34. A function such as sum - count or average that you use to include summary data in a report.






35. A field in a table with unique values that although it is not the primary key - it could have been used as such.






36. A referential integrity constraint is a statement that limits the values of the foreign key to those already existing as primary key values in the corresponding table.






37. An attribute utilized to sort and/or identify data in some manner. Each table should have a primary key which uniquely identifies records.






38. All key attributes defined - attributes depend on key and no repeating groups.






39. a.k.a record






40. A central repository for databases across an entire enterprise.






41. A self-describing collection of integrated tables. The tables are called integrated because they store data about the relationships between the rows of data.






42. Many-to-many relationships occur when each record in TableA may have 0 - 1 or many linked records in TableB and vice-versa.






43. This is an exact numeric data type that holds from 10^38 - 1 through 10^38 - 1.






44. A database object on which you place controls for entering - displaying and editing records in a table.






45. A characteristic of the items in a database i.e. a field






46. A database computer language designed for the retrieval and management of data in relational database management systems (RDBMS) - database schema creation and modification - and database object access control management.






47. Functional dependency involving only non-key attributes.






48. A Key composed of more than one attribute.






49. No multiple multi-valued dependencies.






50. A query that removes records which match the criteria you specify from one or more tables