Free Networking and Internet MCQs with Answers

• A. Centralized
• B. Partitioned
• C. Replicated
• D. All of the above

Explanation: In distributed database systems, data distribution strategies determine how data is physically scattered across multiple locations or…

• A. Attribute
• B. Relationship
• C. Both A and B
• D. Normalization

Explanation: Attributes are the properties or characteristics of an object. They define the state of an object.

• A. Physical pointer
• B. Retrieval program
• C. File organization
• D. Update program

Explanation: File organization is the method used to physically structure and store records of a file on a secondary storage device.

• A. Data accessibility
• B. Response times
• C. Security
• D. All of the above

Explanation: (a) Data accessibility is impacted by physical database design decisions.

• A. Different views may need to be integrated.
• B. New data requirements may produce new relations to be merged.
• C. Both A and B
• D. To decrease the cardinality of a relation.

Explanation: The correct answer is Both A and B.Different views may need to be integrated.

• A. Splitting
• B. Partitioning
• C. Replication
• D. Dividing

Explanation: Partitioning is a method of distributing a database across multiple storage locations or servers.

• A. Data volume and usage analysis
• B. Data distribution strategy
• C. Normalization of relations
• D. File organization
• E. Schema refinement

Explanation: Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity.

• A. Data flow diagram
• B. Decision Tables
• C. Decision Trees
• D. All of these

Explanation: Decision trees are a supervised learning technique that uses a tree-like model to classify data.

• A. Teacher
• B. Student
• C. Aero Plane
• D. All of these

Explanation: In an Entity-Relationship Model (ERM), an entity refers to a real-world object or concept that can be uniquely identified and has its own…

• A. Relation
• B. E-R Diagram
• C. Cardinality
• D. Modality

Explanation: Cardinality refers to the minimum and maximum number of times an instance of one entity can be associated with an instance of another…

• A. Relation
• B. Entity-relationship model
• C. Cardinality
• D. Database entity diagram

Explanation: An entity-relationship model (ERM) is a conceptual data model that depicts the relationships between entities (e.g., customers, and…

• A. View integration
• B. View entities
• C. View integrity
• D. View independence

Explanation: View integration refers to the process of combining data from multiple views into a single, unified view.

• A. Recursive relationship
• B. One-to-many relationship
• C. Many-to-many relationship
• D. One-to-one relationship

Explanation: A recursive relationship is a type of relationship in an Entity-Relationship (ER) model where an entity can be related to itself.

• A. Object Oriented Data Model
• B. Network Data Model
• C. Implementation Model
• D. Hierarchical Data Model

Explanation: The conceptual data model is a high-level representation of the data that is needed by the database system.

• A. Diamond symbol
• B. Rectangular box
• C. Oval symbol
• D. Line

Explanation: In an entity-relationship diagram (ERD), a diamond symbol represents the relationship between two entities.

• A. Entity
• B. Attributes
• C. Relationships
• D. Cardinals

Explanation: An entity is a real-world object or concept that is represented in a database.

• A. E-R diagram
• B. Model
• C. Data Structure
• D. Both A and B

Explanation: The conceptual view of a database refers to a high-level representation of the data that focuses on the business entities and their…

• A. Relationship
• B. Cardinality
• C. Modality
• D. Attribute

Explanation: Attribute refers to a characteristic of an entity in a data model. It describes the properties of an object.

• A. Logical Design
• B. File organization
• C. Normalization
• D. Physical design

Explanation: This is the process of organizing database tables to minimize redundancy and improve data integrity.

• A. Logical database structure
• B. Data value & usage analysis
• C. User-processing requirement
• D. Integrity constraint

Explanation: User-processing requirement refers to the specific needs of users when interacting with a system.