CIA 3103 - Database Design and Admin - DFo_1

*______ is the examination of a business and business data to determine the structure of business information and the rules that govern it. This structure forms the basis for database design.* A. Conceptual data modeling B. Physical data modeling (AKA Database building)

Conceptual data modeling

*Collected facts about a topic or item* A. Data B. Information

Data

*______ is raw material from which you can draw conclusions; facts from which you can deduce new facts.* A. Data B. Information

Data

*______ is represented as a collection of tables.* A. Data B. Column C. Row D. Table

Data

*All of an organization's computers in different locations can be utilized just like a pool of computing resources. It builds a software infrastructure that can run on a large number of networked servers. A user makes a request for information or computation from his or her workstation and that request is processed somewhere in the grid as efficiently as possible. It treats computing as a utility, like the electric company.* A. Mainframe Computing B. Desktop Computing C. Client/Server Computing D. Grid Computing

Grid Computing

*The physical "bits and pieces" of a computer; for example, keyboard, screen, mouse, disk drive, memory.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Hardware

*In ______, data is represented as a tree of records, with each record having one parent record and many children.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Hierarchical Model

*In a ______, the data is organized in a tree-like structure.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Hierarchical Model

*The data is stored as records that are connected to one another through links.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Hierarchical Model

*To retrieve data from a ______, the whole tree needs to be traversed, starting from the root node.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Hierarchical Model

*SQL (structured query language) becomes widely used.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

Mid-1980s

*In ______ each record can have multiple parent and child records, forming a generalized graph structure.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Network Model

*______ enables a more natural way of modeling the relationship between records.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Network Model

*______ is a database model that can be regarded as a flexible way of representing objects and their relationships.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Network Model

*______ is comprised of a collection of records connected to one another through links.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Network Model

*A DBMS is hardware that controls the storage, organization, and retrieval of data.* A. True B. False

*False* A DBMS is software that controls the storage, organization, and retrieval of data.

*A database is usually managed by a chief executive officer (CEO).* A. True B. False

*False* A database is usually managed by a database administrator (DBA).

*A database provides facilities for retrieving, adding, modifying, and deleting the data when required.* A. True B. False

*False* A database provides facilities for retrieving, adding, modifying, and deleting the data when required.

*An advantage of hierarchical model is: Increased storage space* A. True B. False

*False* A disadvantage of hierarchical model is: Increased storage space

*A field is a collection of records.* A. True B. False

*False* A record is a collection of fields.

*A disadvantage of hierarchical model is: Easy addition and deletion of new information* A. True B. False

*False* An advantage of hierarchical model is: Easy addition and deletion of new information

*Features of a relational database model: Each field can contain multiple values.* A. True B. False

*False* Each field can contain only one value.

*Each record is a collection of fields, each field contains multiple data values.* A. True B. False

*False* Each record is a collection of fields, each of which contains only one data value.

*Early computer applications accessed data stored in computer files, converted the data into meaningful information, and generated reports to fulfill the organization's requirements. These systems were called data-based systems.* A. True B. False

*False* Early computer applications accessed data stored in computer files, converted the data into meaningful information, and generated reports to fulfill the organization's requirements. These systems were called *file*-based systems.

*No organization needs to collect and maintain data to meet its requirements.* A. True B. False

*False* Every organization needs to collect and maintain data to meet its requirements.

*Flat files does not offer the functionality to store information, manipulate fields, print or display formatted information and exchange information with others, through email and over the Internet.* A. True B. False

*False* Flat files offer the functionality to store information, manipulate fields, print or display formatted information and exchange information with others, through email and over the Internet.

*If you decide to merge data between two relational models, you need to copy and paste relevant information from one model to the other.* A. True B. False

*False* If you decide to merge data between two flat files, you need to copy and paste relevant information from one file to the other.

*If you have two or more flat files that contain client addresses, for example, and a client moved, the flat file will automatically update the client information.* A. True B. False

*False* If you have two or more flat files that contain client addresses, for example, and a client moved, you would have to manually modify the address parameters in each file that contains that client's information.

*Most organizations today use an information system to automate their databases.* A. True B. False

*False* Most organizations today use a database to automate their information systems.

*Features of a relational database model: Table names don't have to be unique, but column names within each table must be unique.* A. True B. False

*False* Table names must be unique, and column names within each table must be unique.

*The entity type of a field defines which record the field contains.* A. True B. False

*False* The entity type of a record defines which fields the record contains.

*Features of a relational database model: The order of the rows and columns is important.* A. True B. False

*False* The order of the rows and columns is not important.

*The rationale of a database is to disperse, few, and break related data for use by database applications* A. True B. False

*False* The rationale of a database is to collect, store, and retrieve related data for use by database applications

*In a hierarchical database model: • Each parent record has only one child.* A. True B. False

*False* • Each child record has only one parent.

*Computers become cost-effective for private companies along with increased storage capability.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

1960s

*E.F. Codd proposes the relational model for databases, disconnecting the logical organization from the physical storage.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

1970-72

*Mainframe Computing belongs to which time period?* A. 1970s B. 1980s C. 1990s D. 2000s

1970s

*P. Chen proposes the entity relationship model (ERM) for database design.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

1976

*Desktop Computing belongs to which time period?* A. 1970s B. 1980s C. 1990s D. 2000s

1980s

*Client/Server belongs to which time period?* A. 1970s B. 1980s C. 1990s D. 2000s

1990s

*The large investment in Internet companies helps create a tools market boom for web/internet/DB connectors.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

1990s

*Grid Computing belongs to which time period?* A. 1970s B. 1980s C. 1990s D. 2000s

2000s

*A workstation or desktop computer, including a screen, a keyboard, and a mouse. They communicate directly with human computer users.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Client

*Upgradation was one of the issues with multiple applications on multiple client workstations. To resolve this issue, one of the strategies adopted in the 1990s was the use of Internet and fast processing servers to meet the needs of organizations in storing data and producing information.* A. Mainframe Computing B. Desktop Computing C. Client/Server Computing D. Grid Computing

Client/Server Computing

*Each ______ represents attributes that belong to the table. For example, in the student table, you could have name, address, student ID, Birth_Date, and so on.* A. Data B. Column C. Row D. Table

Column

*______ is relatively stable over long periods of time.* A. Conceptual data modeling B. Physical data modeling AKA Database building

Conceptual data modeling

*A software program that carries out specific tasks on behalf of computer users.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Application

*As PCs became faster and widely available, processing moved from mainframes to clients. Because PCs had their own software and were capable of doing some processing on their own, they came to be known as "smart clients" or "workstations." Having the processing power within the client machine ushered in a wave of graphical user interface (GUI) applications. Many of today's common applications (Word, Excel, PowerPoint) were created during this era.* A. Mainframe Computing B. Desktop Computing C. Client/Server Computing D. Grid Computing

Desktop Computing

*The first commercially available relational database systems start to appear at the beginning of the 1980s with Oracle Version 2.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

Early 1980s

*Solid growth of DB applications continues. Examples: commercial websites (yahoo.com, amazon.com), government systems (Bureau of Citizenship and Immigration Services, Bureau of the Census), art museums, hospitals, schools.* A. 1960s B. 1970-72 C. 1976 D. Early 1980s E. Mid-1980s F. 1990s G. Early 21st century

Early 21st century

*______ are generally in plain-text form, where each line holds only one record. The fields in the record are separated with delimiters, such as tabs and commas.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Flat File Model

*______ is a database designed around a single table.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Flat File Model

*______ may contain many fields, often with duplicate data that is prone to data corruption.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Flat File Model

*______ puts all database information in one table, or list, with fields to represent all parameters.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Flat File Model

*In one class, if every student receives a numbered score, the scores can be calculated to determine a class average. The class averages can be calculated to determine the school average. So in this scenario, how can you differentiate between data and information?* A. For data, each student's test score is one piece of data. Information is the class's average score or the school's average score. B. For information, each student's test score is one piece of information. Data is the class's average score or the school's average score.

For data, each student's test score is one piece of data. Information is the class's average score or the school's average score.

*The result of combining, comparing, and performing calculations on data.* A. Data B. Information

Information

*______ is knowledge, intelligence, a particular piece of data with a special meaning or function.* A. Data B. Information

Information

*______ is often the result of combining, comparing, and performing calculations on data.* A. Data B. Information

Information

*______ manages memory and storage for the DBMS.* A. Kernel code B. Repository of metadata C. Query language

Kernel code

*In the 1970s, attempts were made to build database systems with integrated hardware and software. Smaller computers, or "dumb terminals," were used to access the large mainframe and execute commands. The terminals depended on the mainframe and displayed the results only after the processing was completed in the mainframe. They were not capable of much processing on their own.* A. Mainframe Computing B. Desktop Computing C. Client/Server Computing D. Grid Computing

Mainframe Computing

*A entity is modeled as an object.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*An object must belong to only one class as an instance of that class.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*Every object has a state (the set of values for the attributes of the object) and a behavior (the set of methods that operate on the state of the object).* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*The relationship between the objects is through sharing of access rather than through pointers or joins.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*The values and methods in an object can be accessed or invoked outside the object only through explicit implementation.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*You can derive a new class (subclass) from an existing class (superclass).* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Object-Oriented Model

*A software program that directly controls and manages the hardware; for example, Microsoft Windows.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Operating system

*______ is concerned with implementation in a given technical software and hardware environment.* A. Conceptual data modeling B. Physical data modeling AKA Database building

Physical data modeling AKA Database building

*______ is highly dependent on the current state of technology and is subject to change as available technologies rapidly change.* A. Conceptual data modeling B. Physical data modeling AKA Database building

Physical data modeling AKA Database building

*______ enables applications to access the data.* A. Kernel code B. Repository of metadata C. Query language

Query language

*Each ______ table contains rows of records and columns with fields of information about each record.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Relational Model

*Each table of records will have a relationship with another table of records when the two tables share a field (or column).* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Relational Model

*______ describes a database in terms of tables, columns, rows, and joins between tables* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Relational Model

*______ represents a database as collections of records that are stored in tables.* A. Flat File Model B. Hierarchical Model C. Relational Model D. Network Model E. Object-Oriented Model

Relational Model

*______ is called a data dictionary.* A. Kernel code B. Repository of metadata C. Query language

Repository of metadata

*Each ______ represents the instance of the table. For example, in the student table, 110, Jones, 12 Oxford Street, and 03-03-66 represents one student instance.* A. Data B. Column C. Row D. Table

Row

*A more powerful computer that accepts work requests from clients, does the work, and sends results back to the client.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Server

*Programs (sets of instructions) that tell the hardware what to do.* A. Hardware B. Software C. Operating system D. Application E. Client F. Server

Software

*Each ______ is the visual representation of columns and rows.* A. Data B. Column C. Row D. Table

Table

*Every ______ has a field or a set of fields that uniquely identifies the row. For example, in the student table, the student ID column uniquely identifies each student.* A. Data B. Column C. Row D. Table

Table

*A database application is a software program that interacts with a database to access and manipulate data* A. True B. False

True

*A database is a centralized and structured set of data stored on a computer system.* A. True B. False

True

*A database is an organized collection of data put together as a unit* A. True B. False

True

*A database provides facilities for transforming retrieved data into useful information.* A. True B. False

True

*A disadvantage of hierarchical model is: Slower access to data at the bottom of the hierarchy* A. True B. False

True

*A link is an association between two records.* A. True B. False

True

*A record in the hierarchical database model corresponds to a row in the relational database model. An entity type corresponds to a table.* A. True B. False

True

*An advantage of hierarchical model is: Faster access to data at the top of the hierarchy* A. True B. False

True

*An advantage of object-oriented model is: Reduced maintenance* A. True B. False

True

*An information system can be defined as a formal system for storing and processing data* A. True B. False

True

*Changing information in one flat file has no bearing on other flat files.* A. True B. False

True

*Data modeling is the first part of the database development process.* A. True B. False

True

*Each field contains only one value.* A. True B. False

True

*Early computer applications focused on tasks that were clerical in nature; for example, payroll, accounting, and inventory.* A. True B. False

True

*Features of a relational database model: Every row is unique. There is a value in each row that is different from that value in another row.* A. True B. False

True

*Features of a relational database model: Values within a column of fields are from the same domain. (For example, a column defined as a date column would not contain a salary amount.)* A. True B. False

True

*In a hierarchical database model: • A parent record can have one or more child records.* A. True B. False

True

*Some flat files may be attached to external files, such as text editors, to extend functionality and manage related information.* A. True B. False

True

*The decades-long evolution in computer technology, coupled with the needs and demands of organizations, has resulted in the development of a database technology from the primitive file-based systems to the robust, integrated database systems of today.* A. True B. False

True

*There is no automation between flat files.* A. True B. False

True