©THESTAR EXAM SOLUTIONS 2024/2025
ALL RIGHTS RESERVED.
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
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
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
ALL RIGHTS RESERVED.
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
1|Page
, ©THESTAR EXAM SOLUTIONS 2024/2025
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
