Question 1

Data encryption concept is used for ______________ purposes.
A)data hidden
B)data display
C)data processing
D)data transfer

Accepted Answer

Data encryption concept is used for data transfer purposes. Encryption is the process of converting data into a form that cannot be easily understood by unauthorized people. This is done by using a key to scramble the data. The key is then used to unscramble the data when it is needed. Encryption is used to protect data from unauthorized access, such as when it is being transmitted over a network.

Question 2

The ______________ is monitors the activities of the computer system
A)processor.
B)ram.
C)rom
D)operating system.

Accepted Answer

The operating system monitors the activities of the computer system, managing hardware and software resources, and providing common services for computer programs.

Question 3

Accounting, finance, marketing, and human resources are known as
A)executive information systems
B)functional business areas
C)geographic information system
D)local information system

Accepted Answer

These are all considered functional business areas within a company, each focusing on specific aspects of the business operations such as financial management, marketing strategies, human resources management, and overall accounting practices.

Question 4

Relational calculus is a
A)procedural language.
B)non- procedural language.
C)data definition language.
D)high level language.

Accepted Answer

Relational calculus is a non-procedural language, meaning it focuses on what to do rather than how to do it. It allows users to specify the data they want to query without specifying how to compute it.

Question 5

The most creative and challenging phase of system life cycle is
A)feasibility study
B)maintenance
C)design
D)none of the above

Accepted Answer

The design phase is considered the most creative and challenging in the system life cycle because it involves creating a solution that meets all specified requirements and constraints, often requiring innovative problem-solving and decision-making.

Question 6

The most important feature of spiral model is
A)requirement analysis
B)risk management
C)quality management
D)configuration management.

Accepted Answer

Risk management is the most important feature of the spiral model. The spiral model is a risk-driven software development process model that emphasizes iterative development and risk management. The spiral model is designed to help software developers identify and mitigate risks early in the development process, which can help to improve the quality and reliability of the software.

Question 7

Which of these items is a major component of today's IT infrastructure?
A)data management technology
B)networking
C)technology services
D)all of me above

Accepted Answer

All the options listed (data management technology, networking, and technology services) are major components of today's IT infrastructure.

Question 8

______________ converts ciphertext back into plaintext.
A)encryption
B)a firewall
C)decryption
D)an encoder

Accepted Answer

Decryption is the process of converting ciphertext back into its original form, which is plaintext. Encryption is the process of converting plaintext into ciphertext, not the reverse. A firewall is a network security device that monitors and filters incoming and outgoing network traffic based on an organization's previously established security policies. An encoder converts data from one form to another and does not specifically refer to the process of converting ciphertext back to plaintext.

Question 9

Relational calculus is a
A)Procedural language.
B)None- Procedural language.
C)Data definition language.
D)High level language.

Accepted Answer

Relational calculus is a non-procedural language, meaning it allows users to specify what they want without having to describe how to get it.

Question 10

The view of total database content is
A)Conceptual view
B)Internal view.
C)External view.
D)Physical view.

Accepted Answer

The conceptual view represents the entire database as a whole, showing how all the data is related and structured, without getting into the details of physical storage or how data is actually stored on the disk.

Question 11

DML is provided for
A)Description of logical structure of database.
B)Addition of new structure in the database system.
C)Manipulation &processing of database.
D)Definition of physical structure of database system.

Accepted Answer

DML (Data Manipulation Language) is used for the manipulation and processing of data within a database, including tasks such as inserting, updating, deleting, and querying data.

Question 12

Architecture of the database can be viewed as
A)Two levels.
B)Four levels.
C)Three levels.
D)One level.

Accepted Answer

The architecture of a database can typically be viewed as three levels: internal, conceptual, and external. This three-level architecture aims to separate the user's view, the conceptual logic, and the physical storage of data, which helps in database abstraction and data independence.

Question 13

The database schema is written in
A)HLL
B)DML
C)DDL
D)DCL

Accepted Answer

The database schema is defined using Data Definition Language (DDL), which is used for specifying the database structure or schema.

Question 14

In the architecture of a database system external level is the
A)Physical level.
B)Logical level.
C)Conceptual level
D)View level.

Accepted Answer

The external level in the architecture of a database system refers to the view level, which is the highest level of abstraction and describes how the data is viewed by individual end-users.

Question 15

In a Hierarchical level model records are organized as
A)Graph.
B)List .
C)Links.
D)Tree.

Accepted Answer

In a Hierarchical level model, records are organized in a tree structure, where records have a parent-child relationship.

Question 16

The language used in application programs to request data from the DBMS is referred to as the
A)DML
B)DDL
C)VDL
D)SDL

Accepted Answer

DML stands for Data Manipulation Language, which is used in application programs to request, insert, delete, and update data in a database.

Question 17

The DBMS language component which can be embedded in a program is
A)The data definition language (DDL)
B)The data manipulation language(DML)
C)The database administrator(DBA)
D)A query language.

Accepted Answer

The Data Manipulation Language (DML) is the component of the database management system (DBMS) that can be embedded in a program to enable users to access and manipulate data. It includes commands such as INSERT, UPDATE, DELETE, and SELECT, allowing programs to perform these operations within the database.

Question 18

Which one of the following statement is false?
A)The data dictionary is normally maintained by the database administrator.
B)Data elements in the database can be modified by changing the data dictionary.
C)The data dictionary contains the name and description of each data element.
D)The data dictionary is a tool used exclusively by the database administrator.

Accepted Answer

B) is false because the data dictionary itself does not modify data elements in the database; it only contains metadata about the structure of the database, such as names and descriptions of data elements. Modifying the data dictionary changes the metadata, not the data itself.

Question 19

An advantage of the database management approach is
A)Data is dependent on programs.
B)Data redundancy increase.
C)Data is integrated and can be accessed by multiple programs.
D)None of the above.

Accepted Answer

Data integration and the ability to be accessed by multiple programs is a key advantage of the database management approach, as it allows for efficient data management and accessibility across different applications.

Question 20

A DBMS query language is designed to
A)Support end users who use English-like commands.
B)Support in the development of complex applications software.
C)Specify the structure of a database.
D)All of the above.

Accepted Answer

A DBMS (Database Management System) query language is designed to support various aspects of database management and interaction. This includes supporting end users with commands that are often designed to be somewhat intuitive or English-like to facilitate easier querying (A), aiding in the development of complex applications by providing a means to interact with and manipulate the database (B), and allowing for the specification of the database structure, such as defining tables, fields, and relationships (C). Therefore, all of the provided options are correct aspects of what a DBMS query language is designed to do.

Quiz 6: IT Infrastructure, Database Management, and System Life Cycle: Exploring Key Concepts and Terminologies

Data encryption concept is used for ______________ purposes.

The ______________ is monitors the activities of the computer system

Accounting, finance, marketing, and human resources are known as

Relational calculus is a

The most creative and challenging phase of system life cycle is

The most important feature of spiral model is

Which of these items is a major component of today's IT infrastructure?

______________ converts ciphertext back into plaintext.

Relational calculus is a

The view of total database content is

DML is provided for

Architecture of the database can be viewed as

The database schema is written in

In the architecture of a database system external level is the

In a Hierarchical level model records are organized as

The language used in application programs to request data from the DBMS is referred to as the

The DBMS language component which can be embedded in a program is

Which one of the following statement is false?

An advantage of the database management approach is

A DBMS query language is designed to