CSDB101 Module 1 Practice

Collected resources itself, which are the basic data discovered, investigated, collected and created in the real world.
Data
Information
Knowledge
Fact
Various data that are organized, classified and systematized for certain purposes according to certain rules.
Information
Knowledge
Wisdom
Data
It is the matter generalized from several items of concrete information.
Knowledge
Information
Fact
Wisdom
A state of disorder in reality. Something that exists without being observed by others.
Fact
Knowledge
Information
Wisdom
Data is a realistic data that exist widely in the real world.
True
False
When data are organized into meaningful patterns, they become knowledge.
True
False
Information of the same type is accumulated and organized into a generalized form.
Knowledge
Information
Data
Fact
A state in which an individual can understand and apply knowledge.
Knowledge
Wisdom
Learnings
Three (3) Types of data processing System (Click next to see correct answers)
Online Processing System
Batch Processing System
Distributed Processing System
Time-Sharing Processing System
Multi-Processing System
In Batch Processing System data is collected for a certain period or a certain amount to process it at once
True
False
When data are transferred to a computer the computer immediately processes the data. (Real-time processing system)
Online Processing System
Batch Processing System
Distributed Processing System
File Processing System
In Distributive Processing System, data are processed by disconnecting processors and databases. Which are geographically dispersed, over the network.
True
False
Method of storing and retrieving paper documents used before the computer was invented.
File Processing System
Online Processing System
Batch Processing System
Distributed Processing System
File Processing System is program dependent.
True
False
This means that the same data are not duplicated in principle.
Integrated Data
Stored Data
Operational Data
Shared Data
Data are saved in a storage medium that can be accessed by a computer (tape, disk, etc)
Integrated Data
Stored Data
Operational Data
Shared Data
Data which are required to perform the unique functions of an organization.
Integrated Data
Stored Data
Operational Data
Shared Data
Data which are jointly owned, maintained, and used by several application programs within an organization.
Integrated Data
Stored Data
Operational Data
Shared Data
Computer-centered system that creates necessary information by storing and managing data in a database.
Database System
Database
Database Management System
Database Language
A set of operational data Integrated and stored with minimal redundancy, so that the multiple application systems of organization can share it.
Database System
Database
Database Management System
Database Language
A tool that provides an interface between people and system.
Database System
Database
Database Management System
Database Language
Database administrator (DA), database application programmer, database user.
Users
Database
Database Management System
Database Language
System software that provides database construction and utilization functions.
Users
Database
Database Management System
Database Language
Is composed of several users' viewpoints in the view phase, that is, a personal database schema viewed by everyone in each user's phase.
External Schema
Conceptual Schema
Internal Schema
Composed of one conceptual schema in the conceptual phase. The database of the entire organization is describe, which has integrated all its users' perspective.
External Schema
Conceptual Schema
Internal Schema
Is composed of an internal phase and an internal schema. The format in which the database is physically stored.
External Schema
Conceptual Schema
Internal Schema
When a concept schema is changed, an external schema is not affected.
Logical Independence
Physical Independence
When an internal schema is changed, an external schema is not affected.
Logical Independence
Physical Independence
The correlation between the external view and the conceptual view is defined.
External/Conceptual Mapping (Logical Thought)
Conceptual/Internal Mapping (Physical Thought)
The correlation between the conceptual view and the stored database is defined.
External/Conceptual Mapping (Logical Thought)
Conceptual/Internal Mapping (Physical Thought)
Responsible for the configuration and overall administration of the database to ensure that the functions of the database systems are performed properly.
Database Administrator
Database Architect
Database Engineer
Establishes models and systemizes the policies and standards for data-related elements such as data, database, data standard and data security.
Database Administrator
Database Architect
Database Engineer
Three (3) Functions of Database (Click next to see correct answers)
Controls duplication from the as ects of data stora e and development and maintenance.
Ensures the integrity of the database.
Enables data sharing among multiple users.
Provides network based database
Control access to data by authorized users.
Expresses connectives relationships between data
Processes the schema specified in the DDL as an Internal schema, I.e. metadata, and stores It in the system catalog.
DDL Compiler
Query Processor
DML Pre-compiler
DML Compiler
Processes advanced queries submitted by general users I.e. Queries are analyzed, parsed, and compiled
DDL Compiler
Query Processor
DML Pre-compiler
DML Compiler
DML commands inserted into an application program are extracted and sent to the DML compiler to be compiled as an object code for database access.
DDL Compiler
Query Processor
DML Pre-compiler
DML Compiler
Generates an object code by parsing and compiling the received DML command.
DDL Compiler
Query Processor
DML Pre-compiler
DML Compiler
Database access is managed at runtime. That is, database operations such as search, or update are executed in the database using the storage data manager.
Run Time Database Handler
Transaction Manager
Stored Data Manager
Checks compliance with integrity constraints and the users' rights while accessing the database.
Run Time Database Handler
Transaction Manager
Stored Data Manager
Manages access to the user database and catalog stored in the disk. (Request to the file manager of the OS)
Run Time Database Handler
Transaction Manager
Stored Data Manager
{"name":"CSDB101 Module 1 Practice", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Collected resources itself, which are the basic data discovered, investigated, collected and created in the real world., Various data that are organized, classified and systematized for certain purposes according to certain rules., It is the matter generalized from several items of concrete information.","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
Make your own Survey
- it's free to start.