• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 3 out of 23 pages
Exam (elaborations)

CSC460 - Database Design Final Exam Study Set With Complete Solutions

Document preview thumbnail
Preview 3 out of 23 pages

CSC460 - Database Design Final Exam Study Set With Complete Solutions...

Content preview

CSC460 - Database Design Final Exam Study
Set With Complete Solutions

Database - ANSWER Main ideas:
Collection of (Inter) Related Data/Records

Other key ideas:
For Enterprise/Organization/Common Purpose
For Sharing
For Minimized Redundancy
For Persistence

Cell phone contact list is a database. Wallet is a database.

What does DBMS stand for? - ANSWER Database Management System

What is a DBMS or Database Management System? - ANSWER A software
system/computerized record-keeping system/collection of programs/program
product/set of programs to enable users to create, maintain, and manage data

What are the components of the DBMS? - ANSWER The Database

Administration (Database Administrator/DBA to handle
maintenance/performance/security...)

Application Programs (for queries and interacting with data)

Hardware (often a dedicated cluster of servers)

What are the advantages of a DBMS? - ANSWER Data Sharing
...one common location for data helps maintain data consistency
Redundancy Control
...Data Normalization handles intra-file redundancy
Centralized Control
...DBAs provide experienced oversight while allowing users to stay users
Data Integrity
...DBMSs support user-defined integrity rules
Data Security
...DBMS can flexibly limit access to users
Management of types of data views
...automatically manages presentations of data for clarity/convenience/security

,Data Independence:
- Logical
...Difficult to achieve, allows schema to change without applications changing
- Physical
...Allows physical storage to change without applications changing

What are the disadvantages of a DBMS? - ANSWER Design is complex
Cost
...licenses are expensive, so are admins
Size (it's a large piece of software, needs a lot of memory to run well)
Cost (Software licenses, maintenance people, servers, additional hardware,
conversion...)
Performance (if it's generalized, performance may not be good)
Greater impact of failure

What are the types of Data Languages? - ANSWER Query Language (Read-only,
just answers questions)
Data Description Language/DDL (turns conceptual schema into a physical
database description)
Data Manipulation Language/DML (insertion/deletion of data)
Data Control Language/DCL (handles security)

What is a schema? - ANSWER The description of the structure of the database -
what tables does it consist of? What are the attributes? Various granularities.

What is architecture? - ANSWER A total description of the DBMS components
and how they interconnect - includes the schema, hardware, etc.

What is SPARC? - ANSWER Standards Planning and Requirements Committee

What is ANSI? - ANSWER American National Standards Institute

What were the goals of ANSI/SPARC architecture? - ANSWER Allow for multiple
user views of data
Allow for disk-level description of data
Provide an abstraction layer to separate the two

What does ANSI/SPARC architecture look like? - ANSWER External level views
mapped to each other and the conceptual level, mapped to internal level,
mapped to DB
External communicates with user
Conceptual defines field groupings/relationships, etc.
Internal is record sizes, indices, record ordering, low-level metadata

, Why did DBMSs move away from centralized architecture? - ANSWER All
components being on one computer created performance bottlenecks, and
computers soon became less expensive and more powerful

What does two-tier architecture consist of? - ANSWER The client - user side
The server - runs DBMS and fields requests

What might a four-tier architecture consist of? - ANSWER Client, web server,
application server, DBMS connected to DB

Why are single DBMS servers bad and distributed DBMSs good? - ANSWER A
single server is a single point of failure - if one goes, everything goes.
Distributing allows for some, all, or none of the DB to be stored locally, and
spreads things out to multiple failure points.

What constitutes primary storage? - ANSWER CPU Registers, Cache, Main
Memory (RAM)

Is primary storage volatile or non-volatile? - ANSWER volatile

Are CPU registers primary, secondary, or tertiary storage? - ANSWER Primary

Is cache primary, secondary, or tertiary storage? - ANSWER Primary

Is RAM primary, secondary, or tertiary storage? - ANSWER Primary

Is secondary storage volatile or non-volatile? - ANSWER non-volatile

Is tertiary storage volatile or non-volatile? - ANSWER non-volatile

Is SSD primary, secondary, or tertiary storage? - ANSWER Secondary

Is HDD primary, secondary, or tertiary storage? - ANSWER Secondary

Is tape/optical storage primary, secondary, or tertiary storage? - ANSWER
Tertiary

What constitutes secondary storage? - ANSWER SSD and HDD

What constitutes tertiary storage? - ANSWER Tape/optical storage

What are the parts of the Hard Drive? - ANSWER An axle holding platters with
two surfaces, a Read/Write arm, and a Read/Write head

Document information

Uploaded on
June 26, 2026
Number of pages
23
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers
$18.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Zayla
3.2
(20)
Sold
163
Followers
13
Items
18631
Last sold
6 days ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions