CCC151 Prelim Exam Questions With All
Correct & Verified Answers
What is a File System? Correct answer-A method of organizing and storing data on a computer.
What were the initial functions of early computer systems in business applications? Correct
answer-Used for normal record-keeping functions.
hat was the main problem with file systems in managing organizational data? Correct answer-
Organizational data were kept in numerous computer files, and these files were managed
independently.
List some disadvantages of file systems. Correct answer-Program-Data Dependence
Duplication of Data
Limited Data Sharing
Lengthy Development Times
Compromises Data Integrity
What is the solution to the disadvantages of file systems? Correct answer-DATABASE Approach.
What is a database? Correct answer-A collection of logically related data that can be processed by
multiple application systems and can be shared by multiple users.
What are the advantages of using a Database Management System (DBMS)? Correct answer-Some
advantages include reduced program maintenance, broader sharing of data, improved productivity
for developers and end-users, and the ability to use data as an organizational resource.
What is a Database Management System (DBMS)? Correct answer-A software system used to
create, maintain, and provide controlled access to user databases.
What are the advantages of database systems? Correct answer-Reduced data redundancy
Improved data consistency
Integrated systems for preserving the security, privacy, and integrity of data
Broader sharing of data
Ease of application development
What is a data dictionary in a DBMS? Correct answer-Describes the structure of data and how they
are to be used, containing metadata or data about data.
What is a query language in a DBMS used for? Correct answer-Used to retrieve selected data from
a database, primarily for ad-hoc queries.
What does a cross-entity linking mechanism in a DBMS allow? Correct answer-It allows related
entities in a database to be linked together, eliminating the need for multiple copies of the same
data.
What is host language interface software used for in a DBMS? Correct answer-Allows database
commands to be combined with standard programming language commands to create applications,
simplifying programming by letting the database handle data-oriented parts of the application.
, What are some features of a DBMS? Correct answer-4GL application development software, form
and report generators, disaster recovery, and concurrency control mechanisms.
Name some popular DBMS on the market. Correct answer-Microsoft Access
IBM DB2
Microsoft SQL Server
Oracle
MySQL
PostgreSQL
What is a central repository of shared data that manages data in a standardized form? Correct
answer-DATABASE Approach.
What is the main purpose of a Database Management System (DBMS)? Correct answer-Used to
create, maintain, and provide controlled access to user databases.
How does a DBMS reduce data redundancy and improve data consistency? Correct answer-By
providing mechanisms for cross-entity linking, eliminating the need for multiple copies of the same
data.
What is a data dictionary in a DBMS used for? Correct answer-Describes the structure of data and
how they are to be used, containing metadata or data about data.
What is a query language in a DBMS used for? Correct answer-Used to retrieve selected data from
a database, primarily for ad-hoc queries.
What impact do databases and database technology have on computer usage? Correct answer-
Databases have a major impact on computer usage and are critical in various areas, including
business, electronic commerce, engineering, medicine, law, education, and library science.
What is the intended purpose of a database? Correct answer-A database is designed, built, and
populated with data for a specific purpose, with an intended group of users and preconceived
applications.
Can a database be of any size and complexity? Correct answer-Yes, a database can vary in size and
complexity, from small lists of records to large catalogs with hundreds of thousands of entries.
What is an example of a database like Amazon.com? Correct answer-Amazon.com is an example
with data for over 20 million items, occupying over 2 terabytes of storage and used by about 15
million visitors daily.
What is the role of a Database Management System (DBMS)? Correct answer-Enables users to
create and maintain databases, facilitating defining, constructing, manipulating, and sharing data
among various users and applications.
What does "meta-data" refer to in a DBMS? Correct answer-The descriptive information about the
database, including data types, structures, and constraints, stored by the DBMS.
What are some functions involved in manipulating a database using a DBMS? Correct answer-
Functions include querying the database, updating data, and generating reports.
Correct & Verified Answers
What is a File System? Correct answer-A method of organizing and storing data on a computer.
What were the initial functions of early computer systems in business applications? Correct
answer-Used for normal record-keeping functions.
hat was the main problem with file systems in managing organizational data? Correct answer-
Organizational data were kept in numerous computer files, and these files were managed
independently.
List some disadvantages of file systems. Correct answer-Program-Data Dependence
Duplication of Data
Limited Data Sharing
Lengthy Development Times
Compromises Data Integrity
What is the solution to the disadvantages of file systems? Correct answer-DATABASE Approach.
What is a database? Correct answer-A collection of logically related data that can be processed by
multiple application systems and can be shared by multiple users.
What are the advantages of using a Database Management System (DBMS)? Correct answer-Some
advantages include reduced program maintenance, broader sharing of data, improved productivity
for developers and end-users, and the ability to use data as an organizational resource.
What is a Database Management System (DBMS)? Correct answer-A software system used to
create, maintain, and provide controlled access to user databases.
What are the advantages of database systems? Correct answer-Reduced data redundancy
Improved data consistency
Integrated systems for preserving the security, privacy, and integrity of data
Broader sharing of data
Ease of application development
What is a data dictionary in a DBMS? Correct answer-Describes the structure of data and how they
are to be used, containing metadata or data about data.
What is a query language in a DBMS used for? Correct answer-Used to retrieve selected data from
a database, primarily for ad-hoc queries.
What does a cross-entity linking mechanism in a DBMS allow? Correct answer-It allows related
entities in a database to be linked together, eliminating the need for multiple copies of the same
data.
What is host language interface software used for in a DBMS? Correct answer-Allows database
commands to be combined with standard programming language commands to create applications,
simplifying programming by letting the database handle data-oriented parts of the application.
, What are some features of a DBMS? Correct answer-4GL application development software, form
and report generators, disaster recovery, and concurrency control mechanisms.
Name some popular DBMS on the market. Correct answer-Microsoft Access
IBM DB2
Microsoft SQL Server
Oracle
MySQL
PostgreSQL
What is a central repository of shared data that manages data in a standardized form? Correct
answer-DATABASE Approach.
What is the main purpose of a Database Management System (DBMS)? Correct answer-Used to
create, maintain, and provide controlled access to user databases.
How does a DBMS reduce data redundancy and improve data consistency? Correct answer-By
providing mechanisms for cross-entity linking, eliminating the need for multiple copies of the same
data.
What is a data dictionary in a DBMS used for? Correct answer-Describes the structure of data and
how they are to be used, containing metadata or data about data.
What is a query language in a DBMS used for? Correct answer-Used to retrieve selected data from
a database, primarily for ad-hoc queries.
What impact do databases and database technology have on computer usage? Correct answer-
Databases have a major impact on computer usage and are critical in various areas, including
business, electronic commerce, engineering, medicine, law, education, and library science.
What is the intended purpose of a database? Correct answer-A database is designed, built, and
populated with data for a specific purpose, with an intended group of users and preconceived
applications.
Can a database be of any size and complexity? Correct answer-Yes, a database can vary in size and
complexity, from small lists of records to large catalogs with hundreds of thousands of entries.
What is an example of a database like Amazon.com? Correct answer-Amazon.com is an example
with data for over 20 million items, occupying over 2 terabytes of storage and used by about 15
million visitors daily.
What is the role of a Database Management System (DBMS)? Correct answer-Enables users to
create and maintain databases, facilitating defining, constructing, manipulating, and sharing data
among various users and applications.
What does "meta-data" refer to in a DBMS? Correct answer-The descriptive information about the
database, including data types, structures, and constraints, stored by the DBMS.
What are some functions involved in manipulating a database using a DBMS? Correct answer-
Functions include querying the database, updating data, and generating reports.
