/
Database and Web Basics
Save to my account
Sign up
Database and Web Basics
Database and Web Basics
Study
1
Question
What is a record in a database table?
Answer
A row representing a specific entity instance.
2
Question
What is a primary key?
Answer
A unique identifier for each record in a table.
3
Question
What is a relational database?
Answer
Structured database with tables and relationships (SQL-based).
4
Question
What characterizes a NoSQL database?
Answer
Unstructured data or flexible schemas for scalability.
5
Question
What is an object-oriented database?
Answer
Stores data as objects analogous to programming objects.
6
Question
What is a hierarchical database?
Answer
Data organized in a tree-like structure.
7
Question
What is a network database?
Answer
Graph-like structure enabling complex relationships.
8
Question
Name an example of a relational database system.
Answer
MySQL (or PostgreSQL, Oracle).
9
Question
Name an example of a NoSQL database.
Answer
MongoDB (or Cassandra).
10
Question
Name an example of an object-oriented database.
Answer
db4o (or ObjectDB).
11
Question
Name an example of a hierarchical database.
Answer
IBM IMS.
12
Question
What is the purpose of a primary key in a table?
Answer
To uniquely identify each record.
13
Question
How do relational databases organize data?
Answer
In tables with defined relationships.
14
Question
What is a record?
Answer
A single data row in a table.
15
Question
What is a table’s role?
Answer
To store data for a specific entity.
16
Question
What is a field’s role?
Answer
To store a specific attribute of the entity.
17
Question
What is data integrity in databases?
Answer
Accuracy, consistency, and reliability of data.
18
Question
What is the primary purpose of the DBMS implemented at ABC Boutique?
Answer
Replace manual spreadsheets with a centralized database system.
19
Question
Which CRUD operations are essential in interacting with the database?
Answer
Create, Read, Update, Delete (CRUD).
20
Question
During SDLC planning, why is understanding data requirements important for database design?
Answer
To define data scope and plan resources.
21
Question
What role does requirement analysis play in SDLC databases?
Answer
Defines data needs and relationships to meet user needs.
22
Question
How does database design influence software architecture in the design phase?
Answer
Data models determine tables, relationships, and constraints.
23
Question
Why are tests in the testing phase important for databases?
Answer
Validate data integrity and performance under load.
24
Question
What happens during the deployment phase regarding databases?
Answer
Migrate data and optimize the production database.
25
Question
What maintenance activities are typical for databases post-deployment?
Answer
Backups, updates, performance tuning, and security checks.
26
Question
Name a modern programming language commonly used in web development and its typical use?
Answer
Python for web development, data science, and automation.
27
Question
What is the role of HTML in modern programming?
Answer
Foundational markup for structuring web pages.
28
Question
What is the significance of CRUD in database interactions?
Answer
Core operations to manage persistent data.
29
Question
Why is user training important when deploying a DBMS?
Answer
Ensures staff can effectively use inventory and sales features.
30
Question
What challenge might ABC Boutique face before DBMS implementation?
Answer
Manual, error-prone inventory and sales tracking.