CS 340 Chapter 1 - Comprehensive Exam (30 Questions)

📋 Exam Instructions

This comprehensive exam covers ALL topics from Chapter 1
30 questions total: 20 Multiple Choice + 10 Short Answer
Answer all questions to receive full credit
Instant feedback provided with detailed explanations
Short answer questions use intelligent keyword matching
Click "Submit Exam" when finished for your final score

Question 1 5 points

What is the primary difference between a database and a database management system (DBMS)?

A database is hardware, while a DBMS is software A database is the data itself, while a DBMS is the software that manages the data A database is for small datasets, while a DBMS is for large datasets There is no difference; the terms are interchangeable

Question 2 5 points

Which of the following is NOT a typical advantage of using a DBMS over a file-based system?

Controlled redundancy Data consistency Concurrent access control Lower initial development cost

Question 3 5 points

In which scenario would using a DBMS NOT be recommended?

A banking system requiring ACID compliance and multiple concurrent users A simple embedded system with static data and severe hardware limitations A university managing student records with frequent updates An e-commerce platform handling thousands of transactions daily

Question 4 5 points

What are "queries" and "transactions" in the context of database applications?

Queries are requests for data retrieval; transactions are collections of database operations Queries modify data; transactions retrieve data Both terms refer to the same concept Queries are used by DBAs; transactions are used by end users

Question 5 5 points

List three main objectives/goals of a DBMS.

Question 6 5 points

What is "program-data independence" and why is it important in database systems?

Question 7 5 points

Which characteristic of the database approach allows a database to be "self-describing"?

The database stores the system catalog (metadata) along with the actual data The database automatically creates documentation The database uses natural language processing The database includes user manuals within its structure

Question 8 5 points

What is the difference between logical data independence and physical data independence?

Question 9 5 points

What are the three levels of data abstraction in a database system?

Physical level, Logical level, View level Input level, Processing level, Output level User level, Application level, System level Hardware level, Software level, Network level

Question 10 5 points

What is the difference between a database schema and a database instance?

Schema is the structure/design that rarely changes; instance is the actual data at a specific moment Schema is the data; instance is the structure Schema is for small databases; instance is for large databases They are the same thing with different names

Question 11 5 points

Which schema describes the database design at the storage/physical level?

Physical schema Logical schema External schema Conceptual schema

Question 12 5 points

Explain what "data abstraction" means in the context of database systems.

Question 13 5 points

Why do different users (e.g., students, registrars, DBAs) need different "views" of the same database?

Question 14 5 points

What does the "A" in ACID stand for, and what does it guarantee?

Atomicity - ensures the "all or nothing" rule; transactions execute completely or not at all Availability - ensures the database is always accessible Accuracy - ensures all data is correct Authentication - ensures only authorized users access data

Question 15 5 points

Explain the "Consistency" property in ACID. What must be maintained before and after a transaction?

Question 16 5 points

What problem does the "Isolation" property solve in concurrent database systems?

It prevents transactions from interfering with each other when executing concurrently It prevents data loss during system failures It prevents unauthorized access to data It prevents data redundancy

Question 17 5 points

Explain "Durability" in ACID. What happens to committed transactions?

Question 18 5 points

If a bank transfer transaction fails after deducting money from Account A but before adding it to Account B, which ACID property was violated?

Atomicity - the transaction should have been all-or-nothing Consistency - the total balance is no longer preserved Both Atomicity and Consistency Isolation

Question 19 5 points

What does OLTP stand for and what is its significance in database systems?

Online Transaction Processing - handles hundreds of concurrent transactions per second Offline Transaction Processing - handles batch transactions Online Testing and Production - for quality assurance Optimized Linear Transaction Protocol - for faster processing

Question 20 5 points

What are the main responsibilities of a Database Administrator (DBA)?

Question 21 5 points

What is the difference between "Casual End Users" and "Naive/Parametric-End-Users"?

Casual users access the database occasionally (e.g., managers); Naive users perform routine tasks with canned transactions (e.g., bank tellers) Casual users are beginners; Naive users are experts Casual users modify data; Naive users only read data There is no significant difference

Question 22 5 points

What is the primary role of Database Designers?

Define the database content, structure, constraints, and communicate with end-users to understand their needs Monitor database performance and authorize user access Create the user interface for database applications Backup and restore database data

Question 23 5 points

Give two examples of "canned transactions" that Naive/Parametric end users perform.

Question 24 5 points

What are the three main sources of database security risks?

Malicious insider, Negligent person within organization, External attacker Viruses, Hackers, Hardware failures Software bugs, Network issues, Power outages User errors, System crashes, Data corruption

Question 25 5 points

Which security component restricts database access ensuring only authorized users can view or modify data?

Access Control Encryption Audit Trails Data Masking

Question 26 5 points

Explain the purpose of "Audit Trails" in database security.

Question 27 5 points

What is the difference between "Encryption" and "Data-Masking/Redaction"?

Question 28 5 points

What is the system catalog (data dictionary) and what information does it store?

Question 29 5 points

What is "metadata" in the context of database systems?

Data about data - the description and structure information stored in the system catalog The actual data stored in database tables Backup copies of the database Encrypted database content

Question 30 5 points

The system catalog can be queried using standard query languages like SQL. True or False, and why?

Chapter 1: Comprehensive Database Systems Exam

📋 Exam Instructions

📊 Section 1: DBMS Fundamentals (8 questions)

🔍 Section 2: Data Abstraction & Schemas (5 questions)

⚡ Section 3: ACID Properties & Transactions (6 questions)

👥 Section 4: Database Users & Roles (4 questions)

🔒 Section 5: Database Security (4 questions)

📖 Section 6: System Catalog (3 questions)

Chapter 1: Comprehensive Database Systems Exam

📋 Exam Instructions

📊 Section 1: DBMS Fundamentals (8 questions)

🔍 Section 2: Data Abstraction & Schemas (5 questions)

⚡ Section 3: ACID Properties & Transactions (6 questions)

👥 Section 4: Database Users & Roles (4 questions)

🔒 Section 5: Database Security (4 questions)

📖 Section 6: System Catalog (3 questions)

Exam Results