Database Quiz 2 Bestari

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 Khamarul

Khamarul

Community Contributor

Quizzes Created: 1 | Total Attempts: 117

Questions: 10 | Attempts: 117 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

A database is a systematic collection of data. Databases support storage, manipulation of data and help in making data management easy. This second quiz will test what you are conversant with so far about the database and its components. Tackle it and gauge your understanding! All the best while at it!

Questions and Answers

1.

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
A database is the computer equivalent of an
organized list of information. Typically, this information has a
common subject or purpose, such as the list of employees,
phonebook guide or a classmates address book.

Rate this question:
2.

Use to enter new information, to edit or remove existing information orto locate information.
- A.
  
  Report
- B.
  
  Table
- C.
  
  Form
- D.
  
  Query
Correct Answer
C. Form

Explanation
Forms are used to enter new information, as they provide a structured way for users to input data into a database or system. Unlike tables, which store the data, forms act as a user interface for data entry. They allow users to easily input and edit information in a visually organized manner, with fields and controls that guide the user through the input process. Forms can also be used to locate information by allowing users to search and filter data within the form itself. Therefore, the correct answer is "Form".

Rate this question:
3.

The image show a table wizard in microsoft access. Noticed that the field 'ID' has a key icon at the right. This key icon represent______________

Correct Answer
primary key

Explanation
The key icon next to the field 'ID' in the table wizard in Microsoft Access represents the primary key. The primary key is a unique identifier for each record in a table and is used to ensure data integrity and facilitate efficient data retrieval.

Rate this question:

4
4.

Datatype Autonumber is any alphabetical/numerical data that youdesire-up to a maximum of 255 characters.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The statement is incorrect because the Autonumber datatype is used to generate a unique, sequential number automatically for each record in a table. It does not store alphabetical or numerical data of up to 255 characters.

Rate this question:
5.

Multiple answerdatabase software tools are primarily used for _________, __________, _________, and __________ for information within a database.
- A.
  
  Storing
- B.
  
  Modifying
- C.
  
  Extracting
- D.
  
  Searching
Correct Answer(s)
A. Storing
B. Modifying
C. Extracting
D. Searching

Explanation
Database software tools are primarily used for storing, modifying, extracting, and searching information within a database. These tools allow users to store large amounts of data in an organized and structured manner, making it easier to access and retrieve information when needed. Additionally, users can modify the data by adding, deleting, or updating records. They can also extract specific data or generate reports based on certain criteria. Finally, these tools enable users to search for specific information within the database using various search parameters.

Rate this question:
6.

A collection of records that identify a category of data, such asCustomers, Orders, or Inventory. Data inside a table is arrange bycolumn name __________ and row named ___________.
- A.
  
  Query, report
- B.
  
  Report, query
- C.
  
  Record, field
- D.
  
  Field, record
Correct Answer
D. Field, record

Explanation
In a table, data is organized into columns and rows. The column names represent different categories of data, such as Customers, Orders, or Inventory. Each column contains specific information related to that category, and these columns are referred to as fields. On the other hand, the rows in the table represent individual records or instances of data. Each row contains a set of related information across all the fields/columns. Therefore, the correct arrangement is "field, record" where the column names are fields, and the rows are named records.

Rate this question:
7.

A __________ is a collection of records.

Correct Answer
file
File

Explanation
A file is a collection of records. It is a storage unit that holds data in a structured manner. Files can be stored in various formats and can contain different types of information. They are commonly used in computer systems to organize and store data for easy retrieval and manipulation.

Rate this question:

4
8.

What have you learn today?
- A.
  
  Table
- B.
  
  Foreign Key
- C.
  
  Report
- D.
  
  Query
- E.
  
  Form
- F.
  
  Primary Key
Correct Answer(s)
A. Table
C. Report
D. Query
E. Form
F. Primary Key

Explanation
The correct answer consists of a list of terms related to databases. A table is a collection of related data organized in rows and columns. A report is a formatted presentation of data from a database. A query is a request for specific data from a database. A form is a user interface that allows users to interact with a database. A primary key is a unique identifier for each record in a table. Foreign key, which is not included in the correct answer, is a field in a table that links to the primary key in another table.

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 21, 2023

Quiz Edited by
ProProfs Editorial Team
Aug 31, 2015

Quiz Created by
Khamarul

Database Quiz 2 Bestari

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.

Use to enter new information, to edit or remove existing information orto locate information.

The image show a table wizard in microsoft access. Noticed that the field 'ID' has a key icon at the right. This key icon represent______________

Datatype Autonumber is any alphabetical/numerical data that youdesire-up to a maximum of 255 characters.

Multiple answerdatabase software tools are primarily used for ___, , _, and ______ for information within a database.

A collection of records that identify a category of data, such asCustomers, Orders, or Inventory. Data inside a table is arrange bycolumn name and row named _.

A __________ is a collection of records.

What have you learn today?

Database Quiz 2 Bestari

A database is a collection of information that is organized so that it can easily be accessed, managed, and updated.

Use to enter new information, to edit or remove existing information orto locate information.

The image show a table wizard in microsoft access. Noticed that the field 'ID' has a key icon at the right. This key icon represent______________

Datatype Autonumber is any alphabetical/numerical data that youdesire-up to a maximum of 255 characters.

Multiple answerdatabase software tools are primarily used for _________, __________, _________, and __________ for information within a database.

A collection of records that identify a category of data, such asCustomers, Orders, or Inventory. Data inside a table is arrange bycolumn name __________ and row named ___________.

A __________ is a collection of records.

What have you learn today?

Multiple answerdatabase software tools are primarily used for ___, , _, and ______ for information within a database.

A collection of records that identify a category of data, such asCustomers, Orders, or Inventory. Data inside a table is arrange bycolumn name and row named _.