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

Question 1

Data encryption concept is used for ______________ purposes.

A)data hidden
B)data display
C)data processing
D)data transfer

Answer 1

data transfer

Question 2

The ______________ is monitors the activities of the computer system

A)processor.
B)ram.
C)rom
D)operating system.

Answer 2

operating system.

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

Answer 3

functional business areas

Question 4

Relational calculus is a

A)procedural language.
B)non- procedural language.
C)data definition language.
D)high level language.

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

Question 6

The most important feature of spiral model is

A)requirement analysis
B)risk management
C)quality management
D)configuration management.

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

Question 8

______________ converts ciphertext back into plaintext.

A)encryption
B)a firewall
C)decryption
D)an encoder

Question 9

Relational calculus is a

A)Procedural language.
B)None- Procedural language.
C)Data definition language.
D)High level language.

Question 10

The view of total database content is

A)Conceptual view
B)Internal view.
C)External view.
D)Physical view.

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.

Question 12

Architecture of the database can be viewed as

A)Two levels.
B)Four levels.
C)Three levels.
D)One level.

Question 13

The database schema is written in

A)HLL
B)DML
C)DDL
D)DCL

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.

Question 15

In a Hierarchical level model records are organized as

A)Graph.
B)List .
C)Links.
D)Tree.

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

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.

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.

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.

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.

Question 21

Key to represent relationship between tables is called

A)Primary key
B)Secondary Key
C)Foreign Key
D)None of these

Question 22

The full form of DDL

A)Dynamic Data Language
B)Detailed Data Language
C)Data Definition Language
D)Data Derivation Language

Question 23

Which database level is closest to the users?

A)External
B)Internal
C)Physical
D)Conceptual

Question 24

Hierarchical model is also called

A)Tree structure
B)Plex Stucture
C)Normalize Structure
D)Table Structure

Question 25

Which of the followwing is a network of facilities for procuring materials, transforming raw materials inti intermediate and finished products, and distributing the finished products to customers?

A)Production Chain
B)Primary Chain
C)Supply Chain
D)Distribution Chain