1.  A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems. True 2.  Vertical fragmentation refers to the division of a relation into attribute (column) subsets. True  3.  A distributed data…

1. One of the main functions of a database system is to provide timely answers to end users. True 2. Which of the following is a general guideline for creating and using indices. Do not use indices in small tables…

 1. The developer used ____________SQL statements in the creation of the transaction database.  One 2. A transaction is a logical unit of work that must be entirely completed or removed. True 3.  The DBMS guarantees that the semantic meaning of…

 1. Systems analysis establishes the need for an information system and its extent. True 2.  The term “database development” is used to describe the process of database design and implementation. True 3.  The Systems Development Life Cycle (SDLC) traces the…

 1.A view is a virtual table based on a SELECT query. True 2.  Authentication is the process the DBMS uses to verify that only registered users access the database. True 3.  SQL supports the conditional execution of procedures (IF-THEN-ELSE statements)…

True 2.  A(n) asterisk character is a symbol that can be used as a general substitute for other characters or commands. False 3.  The COUNT function is designed to tally the number of non-null “values” of an attribute and is…

 1.Normalization works through a series of stages called normal forms. True 2.  Normalization is a process that is used for changing attributes to entities. False 3.  In order to meet performance requirements, portions of the database design may need to…

True 2. The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype. completeness 3. The relationships depicted within the specialization hierarchy are sometimes described in terms of “is-a” relationships. True 4.…