Database Management Concepts Quiz! Test
(120).jpg "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. RecordExplanation
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. FieldExplanation
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. RowExplanation
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. ColumnExplanation
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. TableExplanation
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 viewExplanation
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 tablesExplanation
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 keyExplanation
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 typeExplanation
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. FieldExplanation
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. TextExplanation
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. SortExplanation
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. CurrencyExplanation
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. TrueExplanation
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, recordExplanation
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. DatabaseExplanation
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. AutoNumberExplanation
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 viewExplanation
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. TextExplanation
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 TypesExplanation
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. CellExplanation
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 fieldExplanation
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 wizardExplanation
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 queriesExplanation
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 searchExplanation
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.3Explanation
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 99Explanation
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 QueryExplanation
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 viewExplanation
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, DatabaseExplanation
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-RowsExplanation
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. TrueExplanation
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 ViewExplanation
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 ViewExplanation
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 FieldExplanation
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. LinkExplanation
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. TrueExplanation
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 voteRate 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 SelectionExplanation
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. TrueExplanation
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 conditionsExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 22, 2012Quiz Created by
Angievance
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top