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