Database Management Concepts Quiz! Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Angievance
A
Angievance
Community Contributor
Quizzes Created: 4 | Total Attempts: 11,173
Questions: 44 | Attempts: 553

SettingsSettingsSettings
Database Management Concepts Quiz! Test - Quiz


How strong is your knowledge of database management concepts? A database is a collection of data with the same characteristics. The database management system a firm uses is expected to use the ability to transfer data and retrieval of the same. By taking this quiz, you will see just how good you are at using a database management system in the application. Test yourself and see what you need to work more on.


Questions and Answers
  • 1. 

    If you have a database containing information about students, then all the information about one student would be referred to as a _____.

    • A.

      Table

    • B.

      Field

    • C.

      Record

    • D.

      File

    Correct Answer
    C. Record
    Explanation
    In a database, each row represents a separate entity or object, such as a student. A record refers to all the information or data related to a particular entity or object, in this case, a student. Therefore, the correct answer is "record."

    Rate this question:

  • 2. 

    If you have a database containing information about students, then the student's last name would be an example of a _____.

    • A.

      Table

    • B.

      Field

    • C.

      Record

    • D.

      File

    Correct Answer
    B. Field
    Explanation
    In a database containing information about students, the student's last name would be an example of a field. A field is a single piece of data within a database table that represents a specific attribute of the entity being stored. In this case, the last name is a specific attribute or piece of data that is associated with each student in the database.

    Rate this question:

  • 3. 

    Within an Access table, each record is represented by one _____.

    • A.

      Row

    • B.

      Column

    • C.

      Datasheet

    • D.

      File

    Correct Answer
    A. Row
    Explanation
    Within an Access table, each record is represented by one row. In a table, data is organized into rows and columns. A row represents a single record, which contains all the information related to that specific entry. Each field or attribute of the record is stored in a separate column. Therefore, the correct answer is row.

    Rate this question:

  • 4. 

    Within an Access table, each field is represented by one _____.

    • A.

      Row

    • B.

      Column

    • C.

      Datasheet

    • D.

      File

    Correct Answer
    B. Column
    Explanation
    Within an Access table, each field is represented by one column. In a table, data is organized in rows and columns, with each column representing a specific field. Fields contain the actual data values for each record in the table. Therefore, the correct answer is column.

    Rate this question:

  • 5. 

    Each database must contain at least one _____.

    • A.

      Table

    • B.

      Form

    • C.

      Report

    • D.

      Module

    Correct Answer
    A. Table
    Explanation
    In a database, a table is a collection of related data organized in rows and columns. It is the fundamental structure that holds the data and allows for efficient storage, retrieval, and manipulation of information. Therefore, each database must contain at least one table to store and manage the data. Forms, reports, and modules are components that can be used to interact with or analyze the data stored in the tables, but they are not a mandatory requirement for a database.

    Rate this question:

  • 6. 

    Use this view to display a table in columns and rows.

    • A.

      Form view

    • B.

      Design view

    • C.

      Table view

    • D.

      Datasheet view

    Correct Answer
    D. Datasheet view
    Explanation
    The correct answer is "datasheet view" because it allows the user to display data in a tabular format with columns and rows, similar to a spreadsheet. This view is particularly useful for entering and editing data in a structured manner, as well as sorting, filtering, and searching for specific records. It provides a clear and organized representation of the data, making it easier to work with and analyze.

    Rate this question:

  • 7. 

    The first step in designing a new database is _____.

    • A.

      Entering data

    • B.

      Building queries

    • C.

      Planning the tables

    • D.

      Printing reports

    Correct Answer
    C. Planning the tables
    Explanation
    The first step in designing a new database is planning the tables. This involves determining the structure of the database by identifying the different tables that will be needed and defining the fields and relationships within each table. This step is crucial as it lays the foundation for the entire database design and ensures that the data is organized and stored efficiently. Entering data, building queries, and printing reports are tasks that come after the initial planning stage.

    Rate this question:

  • 8. 

    _____ is a field, or combination of fields, that uniquely identifies each record in a table.

    • A.

      Data type

    • B.

      Form

    • C.

      Relationship

    • D.

      Primary key

    Correct Answer
    D. Primary key
    Explanation
    A primary key is a field, or combination of fields, that uniquely identifies each record in a table. It ensures that each record has a unique identifier, which helps in distinguishing and accessing specific records in the table. The primary key is crucial for maintaining data integrity and enforcing data uniqueness within the table.

    Rate this question:

  • 9. 

    Which of the following is NOT a part of the Query Design window?

    • A.

      Criteria

    • B.

      Field

    • C.

      Or

    • D.

      Data type

    Correct Answer
    D. Data type
    Explanation
    The Query Design window is used to design and create queries in a database. It allows users to specify criteria, select fields, and use operators like "Or" to define query conditions. However, the data type is not a part of the Query Design window. Data types are typically defined at the table or field level, and the Query Design window focuses on defining the structure and conditions for the query, rather than the specific data types.

    Rate this question:

  • 10. 

    _____ is a column in a table that contains a category of information.

    • A.

      Field

    • B.

      Table

    • C.

      Query

    • D.

      Label

    Correct Answer
    A. Field
    Explanation
    A field is a column in a table that contains a category of information. In a database, a table is made up of rows and columns, where each column represents a field. Fields store specific types of data, such as names, dates, or numbers, and allow for the organization and categorization of information within a table.

    Rate this question:

  • 11. 

    Which Data Type would you use for the field "First Name"?

    • A.

      Text

    • B.

      Memo

    • C.

      Number

    • D.

      Currency

    • E.

      Yes/No

    Correct Answer
    A. Text
    Explanation
    The field "First Name" typically contains alphabetic characters and does not require any mathematical calculations. Therefore, the most suitable data type for this field would be "Text." This data type allows for the input and storage of textual information, such as names, without any restrictions on the length of the data.

    Rate this question:

  • 12. 

    All of the following are Data Types in Access EXCEPT _____.

    • A.

      Sort

    • B.

      Date/Time

    • C.

      Yes/No

    • D.

      OLE Object

    • E.

      Attachment

    Correct Answer
    A. Sort
    Explanation
    In Access, "Sort" is not a data type. The other options listed - Date/Time, Yes/No, OLE Object, and Attachment - are all valid data types in Access.

    Rate this question:

  • 13. 

    Which Data Type would you use for the field "Basic Salary"?

    • A.

      Text

    • B.

      Memo

    • C.

      Number

    • D.

      Currency

    • E.

      Yes/No

    Correct Answer
    D. Currency
    Explanation
    The field "Basic Salary" typically involves numerical values that represent a specific amount of money. Therefore, the most appropriate data type to use for this field would be "Currency." This data type allows for the storage and manipulation of monetary values, ensuring accurate calculations and formatting for financial data.

    Rate this question:

  • 14. 

    A report is an effective way of presenting your data in an organized format.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A report is a document that presents information in a structured and organized manner. It allows for clear communication of data, findings, and analysis. By presenting data in a systematic way, a report helps to convey information effectively and facilitates understanding for the intended audience. Therefore, the statement that a report is an effective way of presenting data in an organized format is true.

    Rate this question:

  • 15. 

    A _____ is a unit of information in a _____.

    • A.

      Record, field

    • B.

      Data source, field

    • C.

      Record, data source

    • D.

      Field, record

    Correct Answer
    D. Field, record
    Explanation
    A "field" is a unit of information in a "record". In a database, a record is a collection of related data fields that are grouped together. Each field within a record contains a specific piece of data. Therefore, the correct answer is "field, record".

    Rate this question:

  • 16. 

    An organized collection of logically related data is known as _____.

    • A.

      Meta data

    • B.

      Data

    • C.

      Database

    • D.

      Information

    Correct Answer
    C. Database
    Explanation
    A database is an organized collection of logically related data. It is designed to store, manage, and retrieve large amounts of information efficiently. A database provides a structure for organizing and storing data, allowing for easy access and manipulation of the data. It ensures data integrity and security while facilitating data sharing and collaboration among users.

    Rate this question:

  • 17. 

    Which type of field is incremented automatically?

    • A.

      Auto Elevate

    • B.

      AutoNumber

    • C.

      Auto Increment

    • D.

      Auto Value

    Correct Answer
    B. AutoNumber
    Explanation
    AutoNumber is a type of field that is incremented automatically. This means that whenever a new record is added to the database, the value of the AutoNumber field will be automatically incremented by a predefined increment value. This ensures that each record has a unique identifier without the need for manual input or management.

    Rate this question:

  • 18. 

    Which of the following is NOT a view for interacting with a form object?

    • A.

      Layout view

    • B.

      Datasheet view

    • C.

      Design view

    • D.

      Form view

    Correct Answer
    B. Datasheet view
    Explanation
    Datasheet view is not a view for interacting with a form object. Datasheet view is used for interacting with tables or queries in a tabular format, allowing users to view and edit multiple records at once. It is not specifically designed for interacting with individual form objects. The other views mentioned (Layout view, Design view, and Form view) are all specifically used for interacting with form objects in different ways.

    Rate this question:

  • 19. 

    Which Data Type is better to use for storing a phone number in the following format: 304-555-5555?

    • A.

      Text

    • B.

      Currency

    • C.

      AutoNumber

    • D.

      Number

    Correct Answer
    A. Text
    Explanation
    The phone number format "304-555-5555" contains both numbers and hyphens, which are not mathematical operations. Therefore, it is more appropriate to store it as a text data type rather than a numeric data type. Text data types can accommodate alphanumeric characters and special characters like hyphens, making it the better choice for storing phone numbers in this format.

    Rate this question:

  • 20. 

    Which of the following is a valid Data Type in Access?

    • A.

      Hyperlink

    • B.

      Currency

    • C.

      Memo

    • D.

      OLE Object

    • E.

      Attachment

    • F.

      All are valid Data Types

    • G.

      All except Attachment

    Correct Answer
    F. All are valid Data Types
    Explanation
    All of the options listed (Hyperlink, Currency, Memo, OLE Object, Attachment) are valid data types in Access. Access allows for a variety of data types to be used in tables, such as text, numbers, dates, and more. These specific data types mentioned are commonly used in Access to store different types of information. Therefore, the correct answer is that all of the options are valid data types in Access.

    Rate this question:

  • 21. 

    What is the intersection of a row and a column?

    • A.

      Cursor

    • B.

      Form

    • C.

      Record

    • D.

      Cell

    Correct Answer
    D. Cell
    Explanation
    The intersection of a row and a column refers to the point where they meet or cross each other. In a table or spreadsheet, each cell represents this intersection, containing specific data or information. Therefore, the correct answer is "Cell."

    Rate this question:

  • 22. 

    What determines a table's sort order?

    • A.

      AutoNumber field

    • B.

      Field order

    • C.

      Primary key

    • D.

      Index field

    Correct Answer
    D. Index field
    Explanation
    The sort order of a table is determined by the index field. An index field is a field that is created to improve the performance of searching, sorting, and filtering data in a table. It allows for faster retrieval of data by organizing the data in a specific order. When sorting a table, the index field is used as the basis for arranging the records in ascending or descending order. Therefore, the index field plays a crucial role in determining the sort order of a table.

    Rate this question:

  • 23. 

    Which tool do you use to create a query object?

    • A.

      Simple filter wizard

    • B.

      Table query wizard

    • C.

      Database wizard

    • D.

      Simple query wizard

    Correct Answer
    D. Simple query wizard
    Explanation
    The Simple query wizard is used to create a query object. This tool provides a user-friendly interface that allows users to easily define the criteria and parameters for their queries. It simplifies the process of creating queries by guiding users through the necessary steps and providing options for selecting tables, fields, and conditions. With the Simple query wizard, users can quickly create and customize query objects without the need for advanced technical knowledge or coding skills.

    Rate this question:

  • 24. 

    Which object(s) can be used to create a form?

    • A.

      Queries and reports

    • B.

      Tables only

    • C.

      Tables and queries

    • D.

      Tables and reports

    Correct Answer
    C. Tables and queries
    Explanation
    Tables and queries can be used to create a form. Tables store the data that will be displayed and manipulated in the form, while queries are used to retrieve and filter the data from the tables. By combining the functionality of tables and queries, a form can be created to provide an interface for users to input and view data in a structured manner.

    Rate this question:

  • 25. 

    What is the purpose of indexing?

    • A.

      To reduce table size

    • B.

      To speed up data search

    • C.

      Both A and B

    • D.

      Neither A nor B

    Correct Answer
    B. To speed up data search
    Explanation
    The purpose of indexing is to speed up data search. Indexing involves creating a separate data structure that organizes the data in a way that allows for faster retrieval of specific information. By creating an index, the system can quickly locate the desired data without having to search through the entire table. This improves the efficiency and performance of data search operations.

    Rate this question:

  • 26. 

    What does the expression [Detail] : [Product] * 1.30 do?

    • A.

      Multiplies the contents of Detail and Product fields by 1.3

    • B.

      First divides Detail by Product and then multiplies by 1.3

    • C.

      Multiplies the contents of Detail in the Product table by 1.3

    • D.

      Multiplies the contents of Product in the Detail table by 1.3

    Correct Answer
    D. Multiplies the contents of Product in the Detail table by 1.3
    Explanation
    The expression [Detail] : [Product] * 1.30 multiplies the contents of Product in the Detail table by 1.3.

    Rate this question:

  • 27. 

    What is the result of a query where Cust ID >10 and Cust ID < 100?

    • A.

      Displays all customers with Cust ID from 10 to 100

    • B.

      Displays all customers with Cust ID above 10

    • C.

      Displays all customers with Cust ID below 100

    • D.

      Displays all customers with Cust ID from 11 to 99

    Correct Answer
    D. Displays all customers with Cust ID from 11 to 99
    Explanation
    The result of the query where Cust ID > 10 and Cust ID < 100 is that it will display all customers with Cust ID from 11 to 99. This is because the query is looking for customers whose Cust ID is greater than 10 and less than 100, so it will exclude the customers with Cust ID 10 and 100, and include all other customers within that range.

    Rate this question:

  • 28. 

    In a query, which will return names beginning with the letter "K"?

    • A.

      Like "K"

    • B.

      Like "K*"

    • C.

      Like "K?"

    • D.

      Like "K#"

    Correct Answer
    B. Like "K*"
    Explanation
    The correct answer is "Like 'K*'". This is because the "LIKE" keyword is used in SQL to perform pattern matching. The "%" symbol is a wildcard character that represents any number of characters, so "Like 'K*'" will return any names that start with the letter "K" followed by any number of characters.

    Rate this question:

  • 29. 

    Which query do you use to answer the question "Which employees earn more than $5,000 a month"?

    • A.

      Search Query

    • B.

      Crosstab Query

    • C.

      Select Query

    • D.

      Update Query

    Correct Answer
    C. Select Query
    Explanation
    A select query is used to answer the question "Which employees earn more than $5,000 a month?" This type of query allows you to retrieve specific data from a database based on certain criteria. In this case, the select query would be used to select the employees who have a monthly salary greater than $5,000.

    Rate this question:

  • 30. 

    Which of the following is not a database object?

    • A.

      Design view

    • B.

      Tables

    • C.

      Queries

    • D.

      Forms

    • E.

      Reports

    Correct Answer
    A. Design view
    Explanation
    Design view is not a database object because it is a feature or mode within a database software that allows users to design or modify the structure and layout of the database objects such as tables, queries, forms, and reports. It is a tool used to create and edit the actual database objects, but it is not considered a database object itself.

    Rate this question:

  • 31. 

    Which of the following would represent the order of database concepts from narrowest to broadest?

    • A.

      Fields, Tables, Records, Database

    • B.

      Database, Table, Records, Information

    • C.

      Table, Form, Records, Database

    • D.

      Fields, Records, Table, Database

    Correct Answer
    D. Fields, Records, Table, Database
    Explanation
    The correct order of database concepts from narrowest to broadest is: Fields, Records, Table, Database. Fields are the smallest units of data in a database, followed by records which are collections of related fields. Tables are made up of multiple records and organize data into a structured format. Finally, a database is a collection of tables that are interrelated and store all the data for a particular system or application.

    Rate this question:

  • 32. 

    How are fields and records displayed?

    • A.

      Fields-Columns; Records-Rows

    • B.

      Fields-Horizontal; Records-Vertical

    • C.

      Fields-Database View; Records-Design View

    • D.

      Fields-Rows; Records-Columns

    Correct Answer
    A. Fields-Columns; Records-Rows
    Explanation
    Fields and records are displayed in a tabular format, similar to a spreadsheet. Fields are represented as columns, with each column containing a specific type of data. Records, on the other hand, are displayed as rows, with each row representing a unique set of data. This format allows for easy organization and manipulation of data, as well as efficient searching and sorting.

    Rate this question:

  • 33. 

    Queries allow you to ask questions about data in the database table or other queries to extract information.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given statement is true. Queries are used to ask questions about data in a database table or other queries in order to extract information. They allow users to retrieve specific data from a database by specifying certain criteria or conditions. Queries are an essential tool in database management systems as they provide a way to interact with and retrieve data from the database efficiently and effectively.

    Rate this question:

  • 34. 

    Which form and report view allows you to immediately see the design changes you are making?

    • A.

      Datasheet View

    • B.

      Design View

    • C.

      Layout View

    • D.

      Table View

    Correct Answer
    C. Layout View
    Explanation
    Layout View allows you to immediately see the design changes you are making. In this view, you can see both the design elements and the data simultaneously, making it easier to make and visualize changes to the layout of the form or report. This view is useful for adjusting the position and size of controls, adding or removing fields, and overall formatting of the form or report.

    Rate this question:

  • 35. 

    Which view is used to add, edit, and delete records in a table?

    • A.

      Datasheet View

    • B.

      Design View

    Correct Answer
    A. Datasheet View
    Explanation
    Datasheet View is used to add, edit, and delete records in a table. This view displays the data in a tabular form, similar to a spreadsheet, allowing users to easily enter, modify, and delete records. It provides a convenient way to work with the data in a table, especially when dealing with large amounts of data. In Datasheet View, users can directly interact with the table's data, making it the preferred view for managing records in a table. Design View, on the other hand, is used to create or modify the structure of a table, such as adding or removing fields.

    Rate this question:

  • 36. 

    Data should be split into smallest parts.

    • A.

      True. Birth dates should be tracked by age.

    • B.

      True. Last Name and First Name should have separate fields.

    • C.

      False. Macros should be as large as possible according to network guidelines.

    • D.

      False. It should be small or large.

    • E.

      None of the above

    Correct Answer
    B. True. Last Name and First Name should have separate fields.
    Explanation
    The correct answer is "True. Last Name and First Name should have separate fields." This is because it is generally considered best practice to store Last Name and First Name as separate fields in a database. This allows for easier sorting, searching, and manipulation of the data. It also allows for more flexibility in cases where a person may have multiple last names or multiple first names. Storing them separately also makes it easier to adhere to data normalization principles.

    Rate this question:

  • 37. 

    Which field appears as a check box in a table?

    • A.

      Text Field

    • B.

      Number Field

    • C.

      Yes/No Field

    • D.

      Memo Field

    • E.

      None of the above

    Correct Answer
    C. Yes/No Field
    Explanation
    A "Yes/No Field" appears as a check box in a table. This field allows users to select either a "Yes" or "No" option by checking or unchecking the box. It is commonly used to represent boolean values or to indicate the presence or absence of a certain condition or attribute.

    Rate this question:

  • 38. 

    Which of the following is NOT a field Data Type?

    • A.

      Lookup Wizard

    • B.

      OLE Object

    • C.

      Yes/No

    • D.

      Currency

    • E.

      Link

    Correct Answer
    E. Link
    Explanation
    The field data types mentioned in the question are Lookup Wizard, OLE Object, Yes/No, Currency, and Link. Among these options, "Link" is not a field data type. Lookup Wizard is a field data type that allows users to choose a value from a list or a table. OLE Object is a field data type that can store and display objects from other applications. Yes/No is a field data type that represents boolean values. Currency is a field data type that stores currency values. However, "Link" is not a recognized field data type in most database systems.

    Rate this question:

  • 39. 

    Field Size, Format, Validation Rule, Validation Text, Input Mask, Caption, Default Value, Required, Allow Length, and Indexed are ALL field properties.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Field Size, Format, Validation Rule, Validation Text, Input Mask, Caption, Default Value, Required, Allow Length, and Indexed are all examples of field properties in a database. These properties define the characteristics and behavior of a field, such as its data type, length, formatting, and validation rules. By setting these properties, the database can ensure data integrity, enforce data validation, and provide a consistent structure for the fields. Therefore, the statement that all of these are field properties is correct.

    Rate this question:

  • 40. 

    What symbol can be used to find a record when you only know part of a field entry?

    • A.

      &

    • B.

      #

    • C.

      *

    • D.

      @

    Correct Answer
    C. *
    Explanation
    The symbol "*" can be used to find a record when you only know part of a field entry. This symbol is often used as a wildcard character in database queries, allowing you to search for records that match a certain pattern or have a specific set of characters in a particular field. By using "*", you can effectively search for records that contain any combination of characters before or after the known part of the field entry.

    Rate this question:

  • 41. 

    You want to use the validation rule and validation text to create a database that only contains eligible voters in the next election.  Which of the following could be used in the field properties section of the Date of Birth field name where mm is the month, dd is the day, and yyyy is the year?  

    • A.

      Validation Rule:

    • B.

      Validation Rule: =mm/dd/yyyy Validation Text: Not eligible to vote

    • C.

      Validation Rule: ?mm/dd/yyyy Validation Text: Not eligible to vote

    • D.

      None are correct

    Correct Answer
    A. Validation Rule:
    Explanation
    =mm/dd/yyyy Validation Text: Not eligible to vote

    Rate this question:

  • 42. 

    The easiest way to filter is _____.

    • A.

      Filter by Entry

    • B.

      Filter by Form

    • C.

      Filter by Selection

    • D.

      Filter for Multiple Selections

    • E.

      Both A and C

    Correct Answer
    C. Filter by Selection
    Explanation
    The easiest way to filter is by selecting specific criteria or options from a list. This allows the user to narrow down the results and focus on a specific subset of data. By choosing the desired selections, the user can quickly filter and retrieve the relevant information they are looking for.

    Rate this question:

  • 43. 

    You can save a filter as a query.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    You can save a filter as a query, allowing you to easily access and reuse the filter criteria in the future. This can be helpful when you frequently need to apply the same filter to a dataset or when you want to share the filter with others. By saving a filter as a query, you can streamline your workflow and save time by avoiding the need to recreate the filter each time you need it.

    Rate this question:

  • 44. 

    In a query criteria row, AND means _____.

    • A.

      Match a pattern of characters

    • B.

      Match two or more conditions

    • C.

      Match any condition

    • D.

      Match values in a range

    Correct Answer
    B. Match two or more conditions
    Explanation
    In a query criteria row, using "AND" means that the query will match two or more conditions. This means that all of the specified conditions must be met in order for a record to be included in the query results. Using "AND" allows for more specific and targeted filtering of data.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 22, 2012
    Quiz Created by
    Angievance

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.