Microsoft Access Knowledge Exam Quiz: Trivia!
(172).jpg "Microsoft Access Knowledge Exam Quiz: Trivia! - Quiz")
.
- 1.
An organized collection of logically related data is known as?
- A.
Data
- B.
Meta data
- C.
Database
- D.
Information
Correct Answer
C. DatabaseExplanation
A database is an organized collection of logically related data. It is designed to store and manage large amounts of information in a structured manner, allowing for efficient storage, retrieval, and manipulation of data. By organizing data into tables, relationships can be established between different sets of data, enabling complex queries and analysis. Therefore, a database is the correct answer as it encompasses the concept of an organized collection of logically related data.Rate this question:
-
- 2.
In databases, the Locking level is also called?
- A.
Granularity
- B.
S lock
- C.
X lock
- D.
Dead lock
Correct Answer
A. GranularityExplanation
Granularity refers to the level at which locks are applied in a database. It determines the extent to which data is locked during a transaction. Different levels of granularity include table-level, page-level, and row-level locking. By applying locks at a finer level of granularity, concurrency can be increased, allowing multiple transactions to access different parts of the database simultaneously. Therefore, the correct answer is "Granularity" as it refers to the locking level in databases.Rate this question:
-
- 3.
Which of the following is not a database application?
- A.
DBase
- B.
Flash
- C.
FoxPro
- D.
Access
Correct Answer
B. Flash -
- 4.
HSAM stands for ________
- A.
Hierarchic Sequential Access Method
- B.
Hierarchic Standard Access Method
- C.
Hierarchic Sequential and Method
- D.
Hierarchic Standard and Method
Correct Answer
A. Hierarchic Sequential Access MethodExplanation
HSAM stands for Hierarchic Sequential Access Method. This method is used in computer systems to organize and retrieve data in a hierarchical structure. It provides a sequential access approach, meaning that data is accessed in a predetermined order, typically from the top of the hierarchy down to the desired level. This method is commonly used in hierarchical databases, where data is organized in a tree-like structure with parent-child relationships. HSAM allows for efficient storage and retrieval of data in this hierarchical structure.Rate this question:
-
- 5.
Which of the following is not a logical database structure?
- A.
Chain
- B.
Network
- C.
Tree
- D.
Relational
Correct Answer
A. ChainExplanation
A chain is not a logical database structure because it does not represent a relationship between entities in a database. In a chain structure, data is organized in a linear sequence, where each record is linked to the next one. However, this structure does not allow for complex relationships or hierarchies between entities. In contrast, network, tree, and relational structures are commonly used in databases to represent various types of relationships and dependencies between data entities.Rate this question:
-
- 6.
In a datasheet, what does each column represent?
- A.
Record
- B.
Field
- C.
Database
- D.
Table
Correct Answer
B. FieldExplanation
In a datasheet, each column represents a field. A field is a specific piece of information or data that is stored within a record. It is used to categorize or classify the data and provides a way to organize and retrieve information from the database. Each field typically has a unique name and a specific data type, such as text, number, or date, which determines the kind of data that can be stored in that field.Rate this question:
-
- 7.
In a datasheet, what does each row represent?
- A.
Record
- B.
Field
- C.
Database
- D.
Table
Correct Answer
A. RecordExplanation
Each row in a datasheet represents a record. A record is a collection of related data fields that contain information about a specific entity or object. In a datasheet, each row typically corresponds to a unique record, allowing for easy organization and retrieval of data.Rate this question:
-
- 8.
A ________ is a unit of information in a ________
- A.
Record, field
- B.
Field, record
- C.
Data source, field
- D.
Record, data source
Correct Answer
B. Field, recordExplanation
In this question, a field is defined as a unit of information, while a record is defined as a collection of related fields. Therefore, a field is a unit of information in a record.Rate this question:
-
- 9.
What do you call a primary key field included in another table?
- A.
Foreign key
- B.
Parent key
- C.
Child key
- D.
Index
Correct Answer
A. Foreign keyExplanation
A primary key field included in another table is called a foreign key. A foreign key is used to establish a relationship between two tables in a database. It refers to the primary key of another table and helps maintain data integrity and enforce referential integrity constraints. By using foreign keys, data can be linked and related across multiple tables in a database.Rate this question:
-
- 10.
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 each time a new record is added to the database table, the AutoNumber field will automatically generate a unique, sequential number for that record. This is useful for creating primary keys or unique identifiers for each record in the 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 22, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 10, 2012Quiz Created by
Mcqquestions
Back to top