Database - Chapter 1
1. Basic concepts and definitions
2. File Processing System versus Database System
3. Evolution of Database System
Questions and Answers
- 1.
Explain Data Abstraction
- 2.
State the reasons why file based system are disadvantageous, state a minimum of 5
- 3.
State the 8 reasons why the database approach is more advantageous than the file based approach
- 4.
An organized collection of logically related data
Explanation
A database is an organized collection of logically related data. It is a structured way of storing and managing data, allowing for efficient retrieval, manipulation, and analysis. Databases are designed to store information in a structured format, with tables, fields, and relationships between data elements. This organization enables users to easily access and retrieve specific information, as well as perform complex queries and generate reports. By organizing data in this way, databases provide a reliable and efficient means of storing and managing large amounts of information.Rate this question:
- 5.
Facts that could be recorded and stored on storage media
Explanation
The question is asking for the facts that can be recorded and stored on storage media. The term "data" refers to any information that can be stored and processed by a computer. This can include text, numbers, images, audio, video, and any other form of digital information. Therefore, "data" is the correct answer as it encompasses all types of facts that can be recorded and stored on storage media.Rate this question:
- 6.
Data processed in such a way that it can increase the knowledge of the person who uses it
- A.
Metadata
- B.
Information
- C.
Related data
Correct Answer
B. InformationExplanation
The correct answer is "information." Information refers to data that has been processed and organized in a meaningful way, providing knowledge and understanding to the person using it. It is the result of analyzing and interpreting data, making it useful and valuable for decision-making or gaining insights. Metadata, on the other hand, refers to data that provides information about other data, such as its structure or characteristics. Related data refers to data that is connected or associated with a particular topic or subject.Rate this question:
-
- 7.
Data that describe the properties or characteristics of other data.
- A.
Information
- B.
Related data
- C.
Metadata
Correct Answer
C. MetadataExplanation
Metadata refers to data that provides information about other data. It describes the properties, characteristics, and attributes of the actual data. It helps in understanding and organizing the data by providing context and meaning. Metadata can include details such as the source, format, size, date created, and author of the data. It plays a crucial role in data management, data integration, and data analysis processes.Rate this question:
-
- 8.
It is an abstract, self-contained, logical definition of the objects, operators, which users interact with
- A.
Relation Model
- B.
Formal Model
- C.
Data Model
Correct Answer
C. Data ModelExplanation
A data model is a logical definition of the objects and operators that users interact with. It provides an abstract and self-contained representation of the data and its relationships. This model helps in organizing and understanding the structure and behavior of the data, allowing users to manipulate and retrieve information efficiently.Rate this question:
-
- 9.
A distinct object that is to be represented in the database
Correct Answer
entityExplanation
An entity refers to a distinct object that is represented in a database. It could be a person, place, thing, or event that is important to the organization's operations and needs to be stored and managed in the database. Entities have attributes that describe their characteristics, and they are typically represented as tables in a relational database. By organizing data into entities, the database can efficiently store, retrieve, and manipulate information related to these objects.Rate this question:
- 10.
Corresponds to a row in a table
Correct Answer
tupleExplanation
A tuple corresponds to a row in a table. In a relational database, a table is made up of rows and columns, where each row represents a set of related data. A tuple is a specific instance of a row in the table, containing values for each column. It is a collection of attributes that describe a single entity or record in the table. Therefore, the correct answer for this question is "tuple".Rate this question:
- 11.
A property that describes some aspect of the object that we wish to record
Correct Answer
attributeExplanation
An attribute refers to a property that describes some aspect of an object that we want to record. It could be a characteristic, feature, or quality that helps define or differentiate the object. Attributes are used to provide additional information and details about the object, allowing for better understanding and organization of data.Rate this question:
- 12.
An association between several entities
Correct Answer
relationshipExplanation
The given answer "relationship" is the correct answer because it accurately describes the association between several entities. A relationship refers to the connection or link between two or more entities, indicating how they are related or connected to each other. This term is commonly used in various fields such as database management, social sciences, and business analysis to describe the connections and interactions between different entities or objects.Rate this question:
- 13.
Data by itself is useless unless it is some how aggregated, organized and prepared in a form convenient for decision making or other organization activities, now check the essential parts needed for an organized databse
- A.
Metadata
- B.
Information
- C.
Formal logic
- D.
Data
- E.
Entity
- F.
Action
- G.
Relationship
Correct Answer(s)
B. Information
D. Data
F. ActionExplanation
The correct answer includes the essential parts needed for an organized database. "Information" is necessary to provide context and meaning to the data. "Data" is the raw facts and figures that need to be organized. "Action" refers to the operations or processes performed on the data. These three components are crucial in creating a structured and useful database.Rate this question:
-
- 14.
One who understands that data and the needs of the enterprise with respect to that data, at a senior management level
Correct Answer(s)
data administrator
DAExplanation
A data administrator, also known as DA, is a person who holds a senior management position and possesses a deep understanding of data and the enterprise's requirements related to that data. This individual is responsible for managing and overseeing the organization's data assets, ensuring data integrity, security, and compliance. They play a crucial role in developing data strategies, implementing data governance policies, and making informed decisions regarding data management.Rate this question:
- 15.
One who creates the actual database and to implement the technical controls needed to enforce the various policy decisions
Correct Answer(s)
database administrator
DBAExplanation
A database administrator (DBA) is responsible for creating and managing the actual database system. They implement the necessary technical controls to enforce policy decisions, ensuring that the database operates efficiently and securely. This includes tasks such as designing the database structure, configuring access controls, monitoring performance, and troubleshooting any issues that arise. The DBA plays a crucial role in ensuring the integrity, availability, and security of the database, making them essential for effective database management.Rate this question:
- 16.
Kinds of data independence
- A.
Conventional
- B.
Logical
- C.
Mechanical
- D.
Relational
- E.
Physical
Correct Answer(s)
B. Logical
E. PhysicalExplanation
The given answer includes the types of data independence, which are logical and physical. Logical data independence refers to the ability to modify the logical structure of the database without affecting the application programs that use it. Physical data independence refers to the ability to modify the physical storage structure of the database without affecting the logical structure or application programs. Therefore, the answer is correct as it includes both logical and physical data independence.Rate this question:
-
- 17.
The immunity of applications to change in physical representation and access technique
Correct Answer(s)
data independenceExplanation
Data independence refers to the ability of an application or program to access and manipulate data without being affected by changes in its physical representation or the way it is accessed. In other words, it allows applications to be independent of the underlying database structure or technology. This means that changes made to the database, such as adding or modifying tables, do not require modifications to the application code. Data independence ensures flexibility and adaptability, making it easier to maintain and modify applications without disrupting their functionality.Rate this question:
- 18.
A database management system used in the apollo landing project
Correct Answer(s)
GUAM
generalized update access methodExplanation
GUAM stands for Generalized Update Access Method, which was a database management system used in the Apollo landing project. GUAM provided a way for multiple users to access and update data in the database simultaneously. It allowed for efficient and reliable data management during the project, ensuring that the various teams working on the Apollo mission had access to the most up-to-date information.Rate this question:
- 19.
A structure used in a database management system that conforms to an upside-down tree
Correct Answer(s)
hierarchical structureExplanation
A hierarchical structure is a type of structure used in a database management system that follows an upside-down tree pattern. In this structure, data is organized in a parent-child relationship, where each parent can have multiple children but each child can have only one parent. This allows for easy navigation and retrieval of data, as each level of the hierarchy represents a different level of detail. The hierarchical structure is commonly used in systems where data has a clear and defined hierarchy, such as organizational charts or file systems.Rate this question:
- 20.
In the 1960's file processing were dominant
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
During the 1960s, file processing was indeed dominant. This refers to the practice of storing and managing data in physical files, where each file contains records that are accessed sequentially. This approach was widely used before the advent of modern database management systems. It involved manual processes and lacked the efficiency and flexibility offered by today's electronic databases. Therefore, the statement "True" accurately reflects the dominance of file processing during the 1960s.Rate this question:
-
- 21.
An early pioneer of database systems which led to the development of a new type of database system known as network DBMS
Correct Answer
charles bachmanExplanation
Charles Bachman is the correct answer because he is recognized as an early pioneer of database systems. His work led to the development of a new type of database system called network DBMS. This suggests that Bachman's contributions and innovations in the field of database systems were significant and influential, leading to advancements in the way data is organized and managed.Rate this question:
- 22.
A group that defines standard specifications for an environment that would allow database creation and data manipulation
Correct Answer
DBTG
database task groupExplanation
The correct answer is DBTG, which stands for database task group. DBTG is a group that defines standard specifications for an environment that would allow database creation and data manipulation. They are responsible for setting guidelines and standards in the field of database management, ensuring consistency and compatibility across different database systems.Rate this question:
- 23.
A logical organization of the entire database as seen by the DBA – this includes a definition of the database name, the type of each record, and the components of each record type
Correct Answer
network schemaExplanation
A network schema refers to the logical organization of the entire database, including the definition of the database name, the type of each record, and the components of each record type. It provides a structure and framework for understanding the relationships between different data elements within the database. The network schema allows the database administrator (DBA) to have a comprehensive view of the database, facilitating efficient management and maintenance of the database system.Rate this question:
- 24.
The part of the database as seen by the user or application program
Correct Answer
subschemaExplanation
A subschema refers to the part of the database that is visible or accessible to a specific user or application program. It represents a customized view of the overall database, tailored to meet the specific needs and requirements of the user or program. This allows different users or programs to have different levels of access and visibility to the data, ensuring data security and privacy. The subschema includes only the relevant tables, views, and attributes that are necessary for the user or program, hiding the rest of the database schema.Rate this question:
- 25.
A language that define the data characteristics and the data structure, and to manipulate the data.
Correct Answer
data management languageExplanation
The given correct answer is "data management language". A data management language is a language that is used to define the characteristics and structure of data, as well as to manipulate the data. It provides a set of commands and operations that allow users to create, modify, and delete data in a database. Examples of data management languages include SQL (Structured Query Language) and DDL (Data Definition Language).Rate this question:
- 26.
A language that enables the DBA to define the schema
Correct Answer
data definition language
DDLExplanation
A data definition language (DDL) is a language that allows a database administrator (DBA) to define the schema of a database. It is used to create, modify, and delete database objects such as tables, views, indexes, and constraints. DDL statements are used to specify the structure and organization of the data in a database, including data types, relationships between tables, and constraints on the data. By using a DDL, the DBA can control the overall structure and design of the database, ensuring data integrity and consistency.Rate this question:
- 27.
The standard language for relational DBMS in the 1970's
Correct Answer
SQL
Structured Query LanguageExplanation
SQL, or Structured Query Language, was the standard language for relational DBMS (Database Management Systems) in the 1970s. It was developed by IBM in the early 1970s and was later adopted as a standard by the American National Standards Institute (ANSI) and the International Organization for Standardization (ISO). SQL is a programming language used for managing and manipulating relational databases. It allows users to create, retrieve, update, and delete data from databases. SQL became widely popular due to its simplicity and ease of use, and it continues to be the standard language for relational databases today.Rate this question:
- 28.
A period in which object-oriented databases were introduced to cope with massive amounts of data, multimedia such as pictures, flash, videos, games
- A.
2000's
- B.
1980's
- C.
1990's
Correct Answer
C. 1990'sExplanation
During the 1990s, object-oriented databases were introduced to handle large volumes of data, including multimedia content such as pictures, flash, videos, and games. This period saw a shift towards using object-oriented principles in database management, allowing for more efficient storage and retrieval of complex data structures. This was a response to the increasing need for databases to handle the growing amounts of multimedia data being generated.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Jun 19, 2011Quiz Created by
Bawbawbiscuit
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top