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

Chekwube

Community Contributor

Quizzes Created: 1 | Total Attempts: 257

Questions: 10 | Attempts: 258 | Updated: Mar 24, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

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

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
0
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:

1
0
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:

1
0
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:

1
0
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:

1
0
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

Computer Based Test On Data-processing

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

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

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

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

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

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

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

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

All these are determinant of Normal form EXCEPT.

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

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