Class VIII : Lesson 01 "Introduction To MS Access
Informal Assessment # 1
Questions and Answers
- 1.
Which database model is the most popular?
- A.
Network DB
- B.
Relational DB
- C.
Object Oriented DB
- D.
Hierarchical DB
Correct Answer
B. Relational DBExplanation
The most popular database model is the relational database (Relational DB). This model organizes data into tables with rows and columns, and establishes relationships between tables using keys. It is widely used in various industries due to its simplicity, flexibility, and ability to handle complex data structures. Relational databases provide efficient data storage, retrieval, and manipulation capabilities, making them the preferred choice for many applications and systems.Rate this question:
-
- 2.
Jumbled word.BTEALHint : It stores data in Database.
Correct Answer
table
TableExplanation
The jumbled word "BTEAL" can be rearranged to form the word "table", which is a term commonly used in the context of databases to refer to a structured collection of data. The word "Table" is also mentioned in the hint provided, further reinforcing the connection to a database. Therefore, "table" and "Table" are the correct answers.Rate this question:
- 3.
Which Data type is used to store combination of Text and Numbers like "HappyHome657"?
- A.
Text
- B.
Number
- C.
Number and Text
- D.
Memo
Correct Answer
A. TextExplanation
The correct answer is "Text" because the given combination "HappyHome657" is a combination of both text and numbers. In programming, the "Text" data type is used to store alphanumeric characters, including letters, numbers, and special characters. Therefore, "Text" is the appropriate data type for storing a combination of text and numbers like "HappyHome657".Rate this question:
-
- 4.
What is used to uniquely identify each record in a table?
Correct Answer
primary keyExplanation
A primary key is used to uniquely identify each record in a table. It is a column or a set of columns that have a unique value for each row in the table. The primary key ensures that there are no duplicate records in the table and allows for efficient retrieval of data. It is often used for referencing and joining tables in a database.Rate this question:
- 5.
What option is used to remove unwanted data from the table?
- A.
Advanced Filtering
- B.
Sorting
- C.
Field
- D.
Filter
Correct Answer
D. FilterExplanation
Filter is the correct answer because it is an option used to remove unwanted data from a table. By applying filters, users can specify criteria to display only the data that meets those criteria, effectively removing any unwanted data from view. This helps in narrowing down the data and focusing on specific records that are relevant to the user's needs.Rate this question:
-
- 6.
Information about an entity stored in a row
- A.
Record
- B.
Row
- C.
Column
- D.
Field
Correct Answer
A. RecordExplanation
The correct answer is "Record". In a database, information about an entity is typically stored in a row, and this row is referred to as a record. A record contains a collection of related data fields, each representing a specific attribute or characteristic of the entity. It is a fundamental unit of data storage and retrieval in a database system, allowing for efficient organization and management of data.Rate this question:
-
- 7.
To search for a data quickly, we use ______________ box
Correct Answer
searchExplanation
To search for data quickly, we use the search box. The search box allows us to enter specific keywords or phrases related to the data we are looking for. This helps in filtering and retrieving relevant information from a large database or website efficiently. By typing in the search box, we can initiate a search function that scans and matches our input with the available data, providing us with the desired results in a shorter amount of time.Rate this question:
- 8.
In which type of a database we do need to save a file before starting a work?
- A.
Template
- B.
Blank database
- C.
Both Template and Blank database
- D.
None of them
Correct Answer
C. Both Template and Blank databaseExplanation
In both a Template and Blank database, it is necessary to save a file before starting work. This is because saving the file creates a record and establishes a location for the database to be stored. Without saving the file, any changes or work done would not be retained or accessible in the future. Therefore, saving the file is a crucial step in both types of databases.Rate this question:
-
- 9.
Which object of a database is used to retrieve data and display it in easy-to-read format for printing?
Correct Answer
Report
reportExplanation
A report is the object of a database that is used to retrieve data and display it in an easy-to-read format for printing. Reports allow users to organize and present data in a structured manner, making it more understandable and accessible. They can include tables, charts, and graphs to present data visually, and can also include headers, footers, and page numbers for a professional look. Reports are commonly used in business environments to generate summaries, analyses, and presentations of data for decision-making purposes. They provide a convenient way to present data in a printable format.Rate this question:
- 10.
Field names are the combination of
- A.
Mixed cases
- B.
Upper case
- C.
Lower case
- D.
None of above
Correct Answer
A. Mixed casesExplanation
Field names can be a combination of mixed cases, meaning they can include both uppercase and lowercase letters. This allows for more flexibility and readability in naming fields. By using mixed cases, it becomes easier to distinguish between different words or parts of the field name, making it more understandable for users. This is in contrast to using only uppercase or lowercase letters, which may make the field names less clear and harder to interpret.Rate this question:
-
Back to top