question archive Modern Database Management(The Database Environment and Development Process) 1)    One application of data warehouses is: A)    shipping of information

Modern Database Management(The Database Environment and Development Process) 1)    One application of data warehouses is: A)    shipping of information

Subject:ManagementPrice:7.87 Bought7

Modern Database Management(The Database Environment and Development Process)
1)    One application of data warehouses is:
A)    shipping of information.
B)    order processing.
C)    decision support.
D)    file updating.

2)    Older systems that often contain data of poor quality are called    systems.
A)    controlled
B)    legacy
C)    database
D)    mainframe

3)    A database is an organized collection of    related data.
A)    logically
B)    physically
C)    loosely
D)    badly

4)    Which of the following types of data can be stored in a database?
A)    Voice 
B) Letters
C)    Numbers
D)    All of the above

5)    Data processed in a way that increases a user's knowledge is:
A)    text.
B)    graphics
C)    information.
D)    hyperlink.

6)    Data that describe the properties of other data are:
A)    relationships.
B)    logical.
C)    physical.
D)    none of the above.

7)    All of the following are properties of metadata EXCEPT:
A)    data definitions.
B)    processing logic.
C)    rules or constraints.
D)    data structures.

8)    One disadvantage of file processing systems is:
A)    reduced data duplication.
 
B)    program-data independence.
C)    limited data sharing.
D)    enforcement of integrity constraints.

9)    Program-data dependence is caused by:
A)    file descriptors being stored in each application.
B)    data descriptions being stored on a server.
C)    data descriptions being written into programming code.
D)    data cohabiting with programs. 

10)    Because applications are often developed independently in file processing systems:
A)    the data is always non-redundant.
B)    unplanned duplicate data files are the rule rather than the exception.
C)    data can always be shared with others.
D)    there is a large volume of file I/O.

 
11)    Organizations that utilize the file processing approach spend as much as development budget on maintenance.
A)    40 percent
B)    25 percent
C)    60 percent
D)    80 percent
 
12)    A graphical system used to capture the nature and relationships among data is called a(n):
A)    logical data model.
B)    hypertext graphic.
C)    ERD.
D)    data model.

13)    A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
A)    relationship.
B)    object.
C)    attribute.
D)    entity.

14)         are established between entities in a well-structured database so that the desired information can be retrieved.
A)    Entities
B)    Relationships
C)    Lines
D)    Ties

15)    Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
A)    entity.
 
B)    relationship.
C)    relation.
D)    association.

16)    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.

17)    A(n)    is often developed by identifying a form or report that a user needs on a regular basis.
A)    enterprise view
B)    reporting document
C)    user view
D)    user snapshot

18)    With the database approach, data descriptions are stored in a central location known as a(n):
A)    server.
B)    mainframe.
C)    PC.
D)    repository.

19)    A user view is:
A)    what a user sees when he or she looks out the window.
B)    a table or set of tables.
C)    a logical description of some portion of the database.
D)    a procedure stored on the server.

20)    Which organizational function should set database standards?
A)    Management
B)    Application development
C)    Technical services
D)    None of the above

21)         is a tool even non-programmers can use to access information from a database.
A)    ODBC
B)    Structured query language
C)    ASP
D)    Data manipulation query language

22)    Which of the following is NOT an advantage of database systems?
A)    Redundant data
B)    Program-data independence
C)    Better data quality
D)    Reduced program maintenance
 

23)    The most common source of database failures in organizations is:
A)    lack of planning.
B)    inadequate budget.
C)    inadequate hardware.
D)    failure to implement a strong database administration function.

24)    A rule that CANNOT be violated by database users is called a:
A)    password.
B)    constraint.
C)    program.
D)    view.

25)    In a file processing environment, descriptions for data and the logic for accessing the data are built into:
A)    application programs.
B)    database descriptors.
C)    fields.
D)    records.

26)    Databases may be more expensive to maintain than files because of:
A)    the need for specialized personnel.
B)    the complexity of the database environment. 
C) backup and recovery needs.
D) all of the above.

27)    Which of the following is NOT a cost and/or risk of the database approach?
A)    Specialized personnel
B)    Cost of conversion
C)    Improved responsiveness
D)    Organizational conflict

28)    The need for consensus on data definitions is an example of which type of risk in the database environment?
A)    Specialized personnel needs
B)    Organizational conflict
C)    Conversion costs
D)    Legacy systems

29)    A knowledge base of information on facts about an enterprise is called a(n):
A)    enterprise information system.
B)    repository.
C)    systems information unit.
D)    database process.

30)    Which of the following is software used to create, maintain, and provide controlled access to databases?
 
A)    Network operating system
B)    User view
C)    Database management system (DBMS)
D)    Attribute

31)    A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
A)    index.
B)    data warehouse.
C)    repository.
D)    database management system.

32)    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.

33)    Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
A)    client.
B)    user interface.
C)    icon.
D)    development environment.

34)    Database development begins with    , which establishes the range and general contents of organizational databases.
A)    database design
B)    cross-functional analysis
C)    departmental data modeling
D)    enterprise data modeling

35)    The traditional methodology used to develop, maintain and replace information systems is called the:
A)    Enterprise Resource Model.
B)    Systems Development Life Cycle.
C)    Unified Model.
D)    Systems Deployment Life Cycle.

36)    The SDLC phase in which every data attribute is defined, every category of data is listed and every business relationship between data entities is defined is called the    phase.
A)    planning
B)    design
C)    analysis
D)    implementation

37)    The SDLC phase in which database processing programs are created is the    phase.
 
A)    planning
B)    design
C)    analysis
D)    implementation

38)    The SDLC phase in which the detailed conceptual data model is created is the      
phase.
A)    planning
B)    design
C)    analysis
D)    implementation

39)    Organizing the database in computer disk storage is done in the    phase.
A)    design
B)    maintenance
C)    analysis
D)    implementation

40)    An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called:
A)    CASE.
B)    CAD.
C)    RAD.
D)    MST.

41)    One of the most popular RAD methods is:
A)    automated design.
B)    structured walkthrough.
C)    prototyping.
D)    crafting.

42)    The three-schema approach includes which of the following schemas?
A)    Internal
B)    Logical
C)    Cross-functional
D)    Dissecting

43)         analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.
A)    Programmers
B)    Users
C)    Systems analysts
D)    Database analysts

44)         concentrate on determining the requirements for the database component of an information system.
A)    Database analysts
 
B)    Systems analysts
C)    Programmers
D)    All of the above

45)    E. F. Codd developed the relational model in the:
A) 1960s.
 B) 1970s. 
C) 1980s.
D) 1990s.

46)    Which of the following is NOT an objective that drove the development and evolution of database technology?
A)    The need to provide greater independence between programs and data
B)    The desire to manage increasing complex data types and structures
C)    The desire to require programmers to write all file handling functionality
D)    The need to provide ever more powerful platforms for decision support applications

47)    The period that can be considered a "proof of concept" time was the: A) 1950s.
B) 1960s.
C) 1970s.
D) 1990s.

48)    A relatively small team of people who collaborate on the same project is called a(n):
A)    server group.
B)    workgroup.
C)    data collaborative.
D)    typical arrangement.

49)    A workgroup database is stored on a central device called a(n):
A)    client.
B)    server.
C)    remote PC.
D)    network.

50)    Which of the following is an integrated decision support database with content derived from various operational databases?
A)    Corporate data structure
B)    Relational DBMS
C)    Data warehouse
D)    Client-server system

51)    A data warehouse derives its data from:
A)    on-line transactions.
B)    various operational data sources.
C)    reports.
D)    a datamart.
 
52)    Which of the following will interfere with access to operational databases?
A)    Unstructured and unpredictable use of data
B)    Predictable use of data
C)    Efficient transaction processing systems
D)    All of the above

Option 1

Low Cost Option
Download this past answer in few clicks

7.87 USD

PURCHASE SOLUTION

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 7 times

Completion Status 100%