Exam (elaborations)
CSCI 3700 Midterm Exam Questions And Verified Detailed Answers
- Course
- Institution
CSCI 3700 Midterm Exam Questions And Verified Detailed Answers...
[Show more]
Content preview
CSCI 3700 Midterm Exam Questions AndVerified Detailed Answers
Database management system - ANS A collection of interrelated data in an environment
that is convenient and efficient to use.
Collections that are highly valuable, relatively large, and accessed by multiple users and
applications, often at the same time. - ANS Database systems are used to manage this
kind of data.
Database management system - ANS A sophisticated software system whose task is to
manage a large, complex collection of data.
Data that is redundant, inconsistent, and hard to access. - ANSWER Such data arose
when applications of a database were stored directly in file systems.
False - ANSWER True or false: Integrity constraints, when databases were implemented
on top of file systems, were well-defined and were clearly explained.
Atomicity of updates - ANSWER A key characteristic of databases, whereby it is ensured
that tables can never be in an inconsistent state.
True - ANSWER True or false: Databases allow controlled concurrent access.
Database management system - ANSWER A collection of interrelated data and a set of
programs that enable users to access and modify this data.
Data model - ANSWER A collection of conceptual tools for describing data, data
relationships, data semantics, and consistency constraints.
,Data abstraction - ANSWER It hides the complexity of data structures to show them
more presentable for the users.
False - ANSWER True or false: SQL databases use a semi-structured data model.
Relational model - ANSWER The type of data model used by SQL databases.
Physical level - ANSWER Describes how a record is stored.
Logical level - ANSWER Describes data stored in a database and the relationships
among the data.
View level - ANSWER Hides certain details so different user roles can see various
amounts of data.
Schema logical - ANSWER The overall logical structure of a database.
Schema physical - ANSWER The overall physical structure of a database.
Instance - ANSWER The actual content of a database at a particular point in time.
Physical data independence - ANSWER The ability to change the physical schema
without changing the logical schema.
True - ANSWER True or false: Interfaces between different database levels must be
appropriately defined such that changes in one portion do not seriously impact the
others.
, Data definition language (DDL) - ANSWER Specification notation for the definition of the
database schema.
Data dictionary - ANSWER Maintains table templates created by a DDL compiler.
Database schemas, integrity constraints, and authorization. - ANSWER The mentioned
types of metadata are stored in data dictionaries.
DML Data manipulation language - ANSWER A language for accessing and updating the
data organized by a particular data model.
Procedural - ANSWER A type of DML that requires a user to specify what data is needed
and how to get that data.
Declarative - ANSWER A type of DML that requires a user to specify what data is needed
without specifying how to get it.
Query language - ANSWER The portion of a DML that relates to informational retrieval.
Structured query language (SQL) - ANSWER A nonprocedural query language that
accepts one or more tables as input and returns only one.
False - ANSWER True or false: SQL is a Turing complete language.
Turing equivalent - ANSWER A term meaning that a computer language can, in principle,
fairly accurately mimic the computational aspects of any other real-world,
general-purpose computer language.
pgAdmin4 - ANSWER An application program interface through which SQL queries can
be forwarded to the database.
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 Easton. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75323 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now