Quiz 1 (Week 102)
CASE (Computer Aided software Engineering)
- design databases and app programs - generate CODE to create the database
Databases may be more expensive to maintain than files because of:
- specialized personnel. - complex database environment. -backup and recovery needs.
A data warehouse contains summarized and historical information. A. TURE B. FALSE
A. TRUE
E. F. Codd developed the relational data model during the 1970s. A.TRUE B.FALSE
A.TRUE
In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. A.TURE A.FALSE
A.TRUE
Information is processed data. A.TRUE A.FALSE
A.TRUE
Separation of metadata from application programs that use the data is called data independence. A.TRUE B.FALSE
A.TRUE
Because applications are often developed independently in file processing systems: A.unplanned duplicate data files are the rule rather than the exception. B.the data is always non-redundant. C.data can always be shared with others.
A.unplanned duplicate data files are the rule rather than the exception.
One application (a way of using ) data warehouses is: A.ORDER PROCESSING B.Decision SUPPORT C. SHIPPING INFO
B.Decisions support
All of the following are properties of metadata EXCEPT: A. data definitions. B. processing logic. C.rules or constraints. D.data structures.
B.processing logic
One of the most popular RAD methods is: A.automated design. B. structured C. walkthrough. D, prototyping. crafting.
D. prototyping
CASE is a class of tools that: A. assists the database administrator in maintaining a database. B. provides guidelines for the physical design of a database. C. provides management reporting tools. D.automates the design of databases and application programs.
D.automates the design of databases and application programs.
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n): A.ENTITY B.OBJECT C.ATTRIBUTE
Entity
An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: A.CASE. B.CAD. C.RAD
RAD
Cost and complexity are just two of the disadvantages of database processing A.TRUE B.FALSE
TRUE
A data model is a graphical system used to capture the nature and relationships among data. TRUE FALSE
True
A modern database management system automates more of the backup and recovery tasks than a file system. TRUE FALSE
True
A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. TRUE FALE
True
The systems development life cycle is the traditional methodology used to develop, maintain, and replace information systems.
True
An enterprise resource planning system integrates all functions of the enterprise. TRUE FALSE
True ex sales, finance , accounting ,payroll systems that are separate into one or connected.
DBMS Purpose
create data update data store data
Metadata
data that describes properties or characteristics and CONTEXT of end user data
Data warehouses
gather data from various databases and give users the opportunity to work with historical data to identify patterns and trends which is helpful for decision support.
Data Model
graphical system used to capture relationships among data
All of the following are primary purposes of a database management system (DBMS) EXCEPT: A. creating data. B. updating data. C. storing data D. providing an integrated development environment.
providing an integrated development environment.
Data independence
separation of data descriptions (METADATA) from Applications programs
RAD (Rapid application development)
software development methodology that uses minimal planning in favor of rapid prototyping. Apart of prototyping information system development approach prototyping