Computer Based Test On Data-processing

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 Chekwube
C
Chekwube
Community Contributor
Quizzes Created: 1 | Total Attempts: 194
Questions: 10 | Attempts: 194

SettingsSettingsSettings
Computer Based Test On Data-processing - Quiz


Exam administered by Guru Instructor
Ifetike Chekwube Hope
08062608637


Questions and Answers
  • 1. 

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

    • A.

      Microsoft Access

    • B.

      Microsoft Power Point

    • C.

      DBase III

    • D.

      FoxBase

    • E.

      Oracle

    • F.

      Oracle

    Correct Answer
    B. Microsoft Power Point
    Explanation
    Microsoft Power Point is not a database management system software. It is a presentation software used for creating slideshows and presentations. The other options listed, such as Microsoft Access, DBase III, FoxBase, and Oracle, are all examples of database management system software that are used for storing, managing, and manipulating data.

    Rate this question:

  • 2. 

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

    • A.

      Database Normalization

    • B.

      Database Query

    • C.

      Database Table

    • D.

      Database Field

    • E.

      Database Report

    • F.

      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. Typing Data repeatedly in database when data is in First Normal form is referred to

    • A.

      Dependency

    • B.

      Normalization

    • C.

      Normal Form

    • D.

      Redundency

    Correct Answer
    D. 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:

  • 4. 

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

    • A.

      Charles Babbage

    • B.

      Edger .F. Codd

    • C.

      Ada Augusta Byron

    • D.

      Blaise Pascal

    Correct Answer
    B. 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:

  • 5. 

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

    • A.

      Short Text

    • B.

      Currency

    • C.

      Data Structure

    • D.

      Date/Time

    • E.

      Numerical

    Correct Answer
    C. 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. In relational database model the -------------- define the object set.

    • A.

      Entity

    • B.

      Relation

    • C.

      Attribute

    • D.

      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:

  • 7. 

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

    • A.

      Attribute

    • B.

      Cardinality

    • C.

      Tuple

    • D.

      Table degree

    • E.

      Relation

    Correct Answer
    C. 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:

  • 8. 

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

    • A.

      First Normal

    • B.

      Second Normal

    • C.

      Third Normal

    • D.

      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:

  • 9. 

    1. All these are determinant of Normal form EXCEPT.

    • A.

      Primary Key

    • B.

      Candidate key

    • C.

      Foriegn Key

    • D.

      Attribute Key

    Correct Answer(s)
    A. Primary Key
    D. 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:

  • 10. 

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

    • A.

      Field

    • B.

      Report

    • C.

      Query

    • D.

      Table

    • E.

      Record

    Correct Answer
    A. Field
    Explanation
    The correct answer is "Query". Asking questions about data stored in a database is commonly referred to as querying the database. A query is a request for specific information from the database, and it allows users to retrieve, manipulate, and analyze data according to their needs.

    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 24, 2023
    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.