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






2. DBMS (Database Management System) statements used to manage data (tables and other objects) within a database






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






4. Data from a table - form - query which is displayed in a row-and-column format.






5. A window that shows the design or structure of the database objects: tables - queries - forms - reports - macros and data access pages.






6. A control that indicates whether an option is selected or not. A tick mark appears in the box when the option is selected.






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






8. A DBMS created by Microsoft - it is a collection of data and objects - such as tables - queries - or forms - related to a particular topic or purpose.






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






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






11. Stored procedures that may be configured to automatically execute (fire) when certain events take place.






12. The dominant database model






13. An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of0 - 1 - or many records in the related table.






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






15. The set of fields in a table which stores unique values and so any one from the list can be selected to be the primary key.






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






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






18. In an access databse - a window in which you work with tables in design view or datasheet view.






19. No multiple multi-valued dependencies.






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






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






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






23. A combination of attributes that can be used to uniquely identify a database record. Candidate keys are a special subset of super keys that do not have any extraneous information in them






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






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






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






27. Dependency where determinant determines a list of values.






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






29. A value that may be assigned to an attribute when no other value applies or when the applicable value is unknown.






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






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






32. Groups of database commands which are to be treated as a single atomic event.






33. A characteristic of a field that determines what kind of data it can store and what type of operations can be performed on it.






34. Relations which allow you to retrieve related records from the same table.






35. All determinants are candidate keys.






36. A primary key that is comprised of more than one field.






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






38. The components of a data abase i.e. tables - queries - forms - reports - pages - macros and modules.






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






40. The DBMS language component used to create - alter and destroy databases and database objects i.e. schemas - tables - views - sequences - catalogs - indexes - and aliases.






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






42. Data about data.






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






44. A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows of a table.






45. No Transitive Dependencies.






46. A table which is not only in 2NF but whose non-primary key fields are dependent only on the primary key and therefore have no dependence on (relationship to) any other non-primary key field in the table.






47. A candidate key that coud have been the primary key but was not selected as such ; OR a field that is not the primary key but has been used for indexing nevertheless.






48. That structure which contains description of objects created by a user - such as base tables - views and constraints - as a part of a database.






49. Functional dependency involving only non-key attributes.






50. a.k.a record







Sorry!:) No result found.

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