CS5200 Database Management Systems Northeastern ||
CS5200 Database Management Systems Northeastern ||
Exam (elaborations)
CS5200 Database Management Systems Northeastern || A+ Verified Solutions.
6 views 0 purchase
Course
CS5200 Database Management Systems Northeastern ||
Institution
CS5200 Database Management Systems Northeastern ||
independence correct answers A database management systems supports and simplifies application and data ___________.
Which of the following below are among the main objectives of a modern DBMS? Check all that apply. correct answers security from unauthorized access, methods for manipulating data...
CS5200 Database Management Systems Northeastern || A+
Verified Solutions.
independence correct answers A database management systems supports and simplifies
application and data ___________.
Which of the following below are among the main objectives of a modern DBMS? Check all that
apply. correct answers security from unauthorized access, methods for manipulating data,
methods for defining data, recovery of data during failures, methods for retrieving data
Edger F. Codd correct answers IBM research scientist is credited with the invention of the
relational model for storing data and non-procedural methods for retrieving data
common drawbacks (disadvantages) of a file-based approach to storing data correct answers lack
of insulation between application and data, frequent data inconsistency, no enforcement of data
integrity constraints, increased data redundancy
SQLite is a _________ database. correct answers relational
A database can be defined as a set or collection of ________ data from which users can
efficiently retrieve the desired information. correct answers related
________ is the main language used to define queries in relational database system and is based
on relational algebra. correct answers SQL
_______ and XPath is the main query mechanism for XML databases. correct answers Xquery
Which three of the following are the levels that are part of the three-schema architecture? correct
answers conceptual schema, external schema, internal schema
The way that data is stored on disk devices and spread across devices, such as in RAID systems,
is known as the ___________ level. correct answers internal
The ________ level in database architecture describes what data is stored, the relationships
among the various kinds of data without concern how the data is actually stored in storage
devices. correct answers conceptual
The person responsible in an organization for, among other things, maintenance, security, and
recovery of databases is the _________. correct answers DBA
One of the oldest data models is the ________ data model which organizes data in a tree
structure in which child nodes are related to parent nodes. correct answers hierarchical
Which of the following is not a relational database management system? correct answers
MongoDB
, The DBMS ensures that after every update that the database is in a _______ state. correct
answers valid
SQL is both a data ______ and ______ language. correct answers definition, manipulation
In a centralized database system, the database, application code, and user interface are all on the
same computer or virtual machine while in a __________ architecture, the database resides on a
remote computer and is accessed over the network by application programs. correct answers
client/server
In which of the following types of databases is the data stored on multiple computers and storage
devices connected either through a SAN or a LAN? correct answers distributed database
Only after requirements collection and analysis are substantially complete should the
______________ phase of the database implementation process start. correct answers conceptual
design
Determining how the physical disk devices are accessed to retrieve the data efficiently is the
responsibility of the __________. correct answers query engine in the database
https://imgur.com/a/sFAqwEz Which of the following statements about the UML Class Diagram
below are correct? correct answers no video has more than two narrators, every video is narrated,
a video must have at least one narrator
https://imgur.com/Z974lQL correct answers lessons are collections of tutorials and examples,
some learning assets may not be allocated to a lesson, there are some examples which are not
included in any lesson, some lessons may not have any examples
Which multiplicity expressions are valid in a UML Class Diagram showing relationships
between domain entities? correct answers 5..5, 2..10, 0..*, 1, 1..C.N
https://imgur.com/AT1olwd What relationship exists between domain entities (business objects)
Highlighter and WritingInstrument? correct answers Generalization
Inheritance relationships are represented in the UML notation by which of these? correct answers
Lines with hollow triangular arrow at one end
In the UML Class Diagram below, the connection (relationship) between Zoo and Animal is a(n)
_________ . https://imgur.com/I5Iib7J correct answers association
An aggregation relationship (in which the part is not permanently fused to its container) is
represented in UML notation by a _______. correct answers Line with hollow diamond at one
end
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 FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.09. You're not tied to anything after your purchase.
