Exam (elaborations)
Database Design & Management Exam 1 Review Questions and Answers 100% Correct
- Course
- Institution
Database Design & Management Exam 1 Review
[Show more]
Content preview
Database Design & Management Exam 1Review
False - answer Conversion from a manual file system to a database system is simply a
matter of importing the data into the DBMS.
True - answer The most important advantage of the DBMS is its ability to let the
user/designer operate in a human logical environment.
True - answer Business rules help you determine the relationships that exist between
entities.
False - answer The order of rows and columns is extremely important to the DBMS.
True - answer When constructing database tables it is the metadata that determines the
data type and column properties.
True - answerThe E-R model is a tool which is commonly used to translate different
views of data among managers, users, and programmers to fit into a common
framework.
True - answerAn Entity is a person, place, or thing about which data are to be collected
and stored.
True - answerEntity integrity must exist before you can evaluate referential integrity
between two tables.
True - answerIn a relational table, each table must have an attribute or a combination of
attributes that uniquely identifies each row.
True - answerEach column in a relational table has a specific range of values known as
the attribute domain.
False - answerTo maintain entity integrity, a null value is permitted in the primary key.
True - answerControlled redundancy makes a relational database work.
False - answerA field filled with a null value is the same as a field filled with spaces.
True - answerIn SQL, the difference between DDL and DML is that one defines the data
structure while the other allows users to extract the data.
, True - answerSQL allows the user to specify WHAT must be done, without specifying
HOW it must be done.
Use - answerProper database design requires the database designer to precisely
identify the database's expected......
Dictionary management - answerThe DBMS function that stores the definitions of the
data elements and their relationships, is:......
Restoring the database after a failure - answerDBMS recovery management deals
with......
Distributed - answerA DBMS that supports a database located at several different sites
is called a......DBMS.
Sharing of data in the database
Promoting a clearer view of the big picture
Providing better access to more and better managed data
(All of the above) - answerThe advantages of DBMS include which of the following?
Islands of information - answerOne drawback to a file based system that leads to
potential data anomalies is:
It is the structural blueprint of the database - answerWhat does logical design mean?
Tables - answerThe user perceives the relational database as a collection of......in
which data are stored.
Hierarchical - answerThe......structure is an ordered data arrangement that logically
resembles an upside-down tree.
Parent - answerWithin the hierarchical model, the top layer or root is perceived as
the......of the segment directly beneath it.
Navigational data access environment - answerLike the hierarchical model, the network
model provides a......
Set - answerIn network terminology, a relationship is called a......
Crow's Foot - answerAnother common ER modeling technique used primarily in the
business sector for ERD's is......
Inheritance - answerThe ability of an object to use the attributes and methods of classes
of objects in an Object-Oriented database is called......
Process - answerWhich of the following is NOT a component of the E-R data model?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller julianah420. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
85169 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now