Computer Based Test On Data-processing

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Chekwube
C
Chekwube
Community Contributor
Quizzes Created: 1 | Total Attempts: 316
| Attempts: 316
SettingsSettings
Please wait...
  • 1/10 Questions

    1. These are example Database Management System Software EXCEPT.
    Select the ones you like

    • Microsoft Access
    • Microsoft Power Point
    • DBase III
    • FoxBase
    • Oracle
    • Oracle
Please wait...
About This Quiz

This COMPUTER BASED TEST ON DATA-PROCESSING assesses knowledge on Database Management Systems, focusing on concepts like normalization, redundancy, and data types. It evaluates understanding of theoretical foundations and practical applications, crucial for students and professionals in IT fields.

Computer Based Test On Data-processing - Quiz

Quiz Preview

  • 2. 

    1. Scientific process of Breaking-down complex table into a Simpler table in order to reduce redundancy and dependency.

    • Database Normalization

    • Database Query

    • Database Table

    • Database Field

    • Database Report

    • Database Calloction

    Correct Answer
    A. Database Normalization
    Explanation
    Database normalization is the scientific process of breaking down a complex table into a simpler table in order to reduce redundancy and dependency. This process helps to eliminate data anomalies and inconsistencies by organizing data into separate tables with logical relationships. It involves dividing large tables into smaller ones, defining primary and foreign keys, and ensuring that each table has a single purpose. Normalization helps improve data integrity, query performance, and overall database efficiency.

    Rate this question:

  • 3. 

    1. The relational database model, where data are organized and stored in tables was introduced by………

    • Charles Babbage

    • Edger .F. Codd

    • Ada Augusta Byron

    • Blaise Pascal

    Correct Answer
    A. Edger .F. Codd
    Explanation
    Edger F. Codd is credited with introducing the relational database model, where data is organized and stored in tables. This model revolutionized the way data is managed and allowed for efficient storage, retrieval, and manipulation of data. Codd's work laid the foundation for modern relational database management systems (RDBMS) and has had a significant impact on the field of database management.

    Rate this question:

  • 4. 

    1. In relational database model the -------------- define the object set.

    • Entity

    • Relation

    • Attribute

    • Tuple

    Correct Answer
    A. Entity
    Explanation
    In the relational database model, entities are used to define the object set. Entities represent real-world objects or concepts that have attributes and can be uniquely identified. They are used to organize and store data in a structured manner, allowing for efficient retrieval and manipulation of information. Entities form the basis for creating tables in a relational database, with each entity corresponding to a table and each attribute representing a column in that table.

    Rate this question:

  • 5. 

    1.  ONE of these is not a data type when selecting your value field values practically in data model

    • Short Text

    • Currency

    • Data Structure

    • Date/Time

    • Numerical

    Correct Answer
    A. Data Structure
    Explanation
    In data modeling, "Data Structure" is not considered a data type when selecting value field values practically. Data Structure refers to the way data is organized and stored, such as arrays, linked lists, or trees, rather than the actual type of data being stored, like text, currency, date/time, or numerical values. Therefore, "Data Structure" does not fit into the list of data types that can be chosen as value fields in a data model.

    Rate this question:

  • 6. 

    1. A database is redesign when extending the database structure, is a problem of Table in ….form.

    • First Normal

    • Second Normal

    • Third Normal

    • Fourth Normal

    Correct Answer
    A. First Normal
    Explanation
    When extending the database structure, the problem of table in First Normal form arises. First Normal form requires that each attribute in a table should have atomic values and there should be no repeating groups of attributes. Therefore, when extending the database structure, it is necessary to ensure that the table is in First Normal form by removing any repeating groups and ensuring that each attribute has atomic values.

    Rate this question:

  • 7. 

    1. Typing Data repeatedly in database when data is in First Normal form is referred to

    • Dependency

    • Normalization

    • Normal Form

    • Redundency

    Correct Answer
    A. Redundency
    Explanation
    When data is in the First Normal Form, it means that each attribute in a table contains only atomic values. In other words, there are no repeating groups or arrays of data within a single attribute. Therefore, when data is repeatedly typed into the database, it creates redundancy, which means that the same data is stored multiple times. This redundancy can lead to various issues such as data inconsistency, increased storage space, and difficulties in data manipulation. Hence, the correct answer is "Redundency".

    Rate this question:

  • 8. 

    1. In relational model of a database, all data is represented in terms of-----and grouped into relations.

    • Attribute

    • Cardinality

    • Tuple

    • Table degree

    • Relation

    Correct Answer
    A. Tuple
    Explanation
    In the relational model of a database, all data is represented in terms of tuples and grouped into relations. A tuple refers to a row or record in a table, which contains a collection of attributes or fields. These tuples are used to store and organize data in a structured manner within a database. Relations, on the other hand, are tables that consist of multiple tuples or rows. Therefore, the correct answer is "Tuple."

    Rate this question:

  • 9. 

    1. Asking questions about data stored in a database can be known as

    • Field

    • Report

    • Query

    • Table

    • Record

    Correct Answer
    A. Query
    Explanation
    A query is a request for information from a database. When you ask specific questions about the data stored—such as filtering, sorting, or retrieving certain fields—you are performing a query. It allows users to extract useful information from large datasets based on specific conditions.

    Rate this question:

  • 10. 

    1. All these are determinant of Normal form EXCEPT.

    • Primary Key

    • Candidate key

    • Foriegn Key

    • Attribute Key

    Correct Answer(s)
    A. Primary Key
    A. Attribute Key
    Explanation
    The correct answer is Primary Key and Attribute Key. Primary Key is a determinant of Normal form as it uniquely identifies each record in a table. Similarly, Attribute Key is also a determinant of Normal form as it helps in identifying and organizing data in a relational database. However, Candidate Key and Foreign Key are determinants of Normal form as well, as they play crucial roles in maintaining data integrity and relationships between tables in a database.

    Rate this question:

Quiz Review Timeline (Updated): May 6, 2025 +

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

  • Current Version
  • May 06, 2025
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 18, 2014
    Quiz Created by
    Chekwube
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.