CSE 511 Midterm Exam Questions With
Verified And Updated Answers
Big data - answer✔volume of available data is huge. data keeps growing at staggering rate. data
comes from variety of sources in totally different formats
Scalable data processing allows database processing systems to cope with the _______,
________, and _________ aspects that big data brings into the system - answer✔volume,
velocity, variety
Best data processing system for operational workload (bank, online store, etc) -
answer✔Relational DBMS (Centralized, distributed)
Unstructured data (highly available systems) data processing system - answer✔NoSQL, graph,
document, key-value stores)
Analytics over massive-scale data (data processing system) - answer✔Hadoop, Spark, Kafka,
GraphX
Database - answer✔large, integrated collection of data
3 main functions of DBMS - answer✔store, retrieve, manage
Store (DBMS function) - answer✔persist and maintain data in storage systems with structure
Retrieve (DBMS function) - answer✔define the way of use/read the data by the upper layer
applications
Manage (DBMS function) - answer✔way of data being managed and manipulated
Benefits of DBMS - answer✔Data independence, efficient data access, data integrity and
security, data administration, concurrent access and crash recovery, reduced app development
time
Data Model - answer✔collection of concepts for describing data
ALL RIGHTS RESERVED.
schema - answer✔description of a particular collection of data, using given data model. ex.
students(sid: string, name: string, GPA: float)
Relational Model - answer✔relations shown with rows and columns. most widely used model
External schema - answer✔view describes how users see the data . Ex. Course_info(cid:string,
enrollment:integer)
conceptual schema - answer✔defines logical structure of the collection of data AKA logical. Ex
(three tables Students(), Course(), Enrolled())
physical schema - answer✔describes how data are managed in storage systems. Ex. relations
stored as unordered files, index on first column of students
Defines and creates schemas - answer✔data description language (DDL)
Modifies/queries data (think language) - answer✔Data Manipulation language (DML)
Logical Date Independence - answer✔Protection from changes in logical structure of data
Physical Data Independence - answer✔Protection from physical structure of data
2 parts of relation - answer✔Instance, schema
instance - answer✔a table, with rows and columns. # rows = cardinality, # fields = degree/arity
SQL statement to create new relation - answer✔CREATE TABLE Students
(sid CHAR(20),
name CHAR(20),
GPA REAL)
SQL statement to destroy relation - answer✔DROP TABLE Students
SQL statement to alter schema - answer✔ALTER TABLE Students
ADD COLUMN firstYear: integer
SQL statement to insert tuple - answer✔INSERT INTO Students(sid, name, login, age, gpa)
VALUE (...)
SQL statement to delete all tuples satisfying conditions - answer✔DELETE
FROM Students S
WHERE S.name = "Smith"
2|Page
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 TheStar. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
