Font size
WorksheetsFDS_MIDTERM
Total questions: 60
Worksheet time: 35mins
What is the primary purpose of a Database Management System (DBMS)?
To create hardware interfaces
To store and retrieve user's data
To design network protocols
To develop application programs
T/F: Process is NOT a component of a database system.
True
False
In database terminology, these are raw and unorganized facts.
(a)
Which type of database organizes data in a tree-like structure?
(a)
What language is commonly used to access and manipulate data in relational databases?
(a)
Which of the following is NOT an example of a popular DBMS?
Oracle
MySQL
PostgreSQL
SQL
When was the first DBMS, known as Integrated Data Store, designed?
1950
1960
1970
1980
What type of database is designed for unstructured data and can store data in various formats?
Relational
Hierarchical
NoSQL
Network
Who introduced the Entity-relationship model in database design?
(a)
MS Access is a personal DBMS product, released in (a) , displaced all other personal DBMS products.
What is the primary goal of database design in DBMS?
To produce physical design models only
To produce logical and physical design models
To implement hardware resources
To implement software resources
Which of the following is NOT a benefit of a properly designed database?
Improved data consistency
Cost-effectiveness in terms of storage space
Increased data redundancy
Ease of maintenance
What does the logical model in database design focus on?
(a)
During which stage of the Database Development Life Cycle is the scope and boundaries of the proposed database system defined?
Requirement analysis
System definition
Logical model design
Physical model design
What is the primary concern of the physical data design model?
Defining user requirements
Translating logical to physical media
Creating entity-relationship diagrams
Analyzing business processes
Which statement best describes the relationship between database design and SQL operations?
SQL operations are more crucial than database design
Structuring databases outweighs proficiency in SQL queries
SQL operations and database design are equally complex
Database design is unnecessary if SQL is well-written
In the context of database development, what does the 'Implementation' phase include?
Requirement analysis and planning
Logical model design
Data conversion, loading, and testing
System definition and scoping
What is the purpose of the 'Testing' stage in database development?
To design the logical model
To convert data from old systems
To identify errors in the new system
To plan the entire development lifecycle
Which of the following is true about the database development life cycle?
It can be flexible in its application
It is only applicable to large database systems
It must always be followed in a strict sequential manner
It ends after the logical model is created
T/F: Considering the system of organization is the primary focus of the 'Planning' stage in database design.
True
False
The primary purpose of database normalization is to eliminate (a) in data manipulation.
Who proposed the theory of normalization of data?
Raymond E. Boyce
Edgar F. Codd
Donald D. Chamberlin
Charles W. Bachman
Which of the following is NOT a normal form in SQL?
First Normal Form (1NF)
Third Normal Form (3NF)
Seventh Normal Form (7NF)
Boyce-Codd Normal Form (BCNF)
What is a key characteristic of the First Normal Form (1NF)?
It eliminates all functional dependencies
It requires a composite primary key
Each table cell should contain a single value
It removes all foreign keys
T/F: A composite key in database design is composed of single column.
True
False
Which normal form deals with removing transitive functional dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Fourth Normal Form (4NF)
What is the main purpose of a foreign key in a database?
To ensure that each record in a table is unique
To speed up query performance
To encrypt sensitive data
To establish relationships between tables
In the context of normalization, what does BCNF stand for?
Boyce-Codd Normal Form
Boyce-Cadd Normal Form
Boyce-Chen Normal Form
Boyce-Crows Normal Form
Which normal form ensures that there are no multi-valued dependencies?
Second Normal Form (2NF)
Third Normal Form (3NF)
Fourth Normal Form (4NF)
Fifth Normal Form (5NF)
What is the highest normal form that is commonly used in practical database design?
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Fourth Normal Form (4NF)
Fifth Normal Form (5NF)
What is the primary purpose of Entity Relationship (ER) Modeling?
To create user interfaces for database systems
To graphically represent database design
To optimize database query performance
To implement security protocols in databases
Which of the following best describes an entity in ER Modeling?
A relationship between two tables
A column in a database table
A distinguishable object in the real world
A primary key in a relational database
What does EER stand for in the context of database modeling?
(a)
In ER Modeling, how are relationships typically represented using UML notation?
As class diagrams
As entity boxes
As associations between entities
As attribute lists
Why is ER Modeling considered important in database design?
It automatically generates SQL code
It eliminates the need for database normalization
It serves as a communication tool between stakeholders
It replaces the need for actual database implementation
What type of relationship exists between an Employee that belongs only to a specific Department?
One-to-one
One-to-many
Many-to-many
No direct relationship
Which of the following is NOT a characteristic of a junction table?
It is a link between keys
It is a solution to RDBMS limitation
It acts as a transaction table
It connects two tables
What does 'U' stands for in UML notation?
Universal
Unique
United
Unified
Which of the following is NOT a characteristic of entities in ER Modeling?
Entities have a set of properties
Entity properties can have values
Entities must always have a many-to-many relationship
Entities represent distinguishable objects in the real world
What notation does the Enhanced Entity Relationship (EER) model typically use?
SQL
XML
UML
JSON
What command is used to create a database in MySQL aside from the keyword CREATE DATABASE?
(a)
Which clause is used to check if a database already exists before creating it?
(a)
What is the purpose of collation in MySQL?
To encrypt the database
To compress the data
To set rules for data comparison
To define the storage engine
Which of the following is NOT a main category of data types in MySQL?
Numeric
Text
Date/Time
Boolean
What is the correct syntax to create a table in MySQL?
NEW TABLE tablename (fieldname datatype);
MAKE TABLE tablename (fieldname datatype);
CREATE TABLE tablename (fieldname datatype);
INSERT TABLE tablename (fieldname datatype);
T/F: The optional parameter AUTO_INCREMENT can be used to automatically increment a field value.
True
False
What is the purpose of the PRIMARY KEY in a table creation statement?
To encrypt the data in the column of a table
To uniquely identify each record in the table
To set the default value for the column of a table
To allow null values in the record in a table
Which storage engine is commonly used in MySQL table creation?
(a)
What is the recommended practice for naming schemas, tables, and fields in MySQL?
Use spaces between words
Use camelCase in the names
Use underscores between words
Use all capital letters in the names
T/F: The valid way to specify the character set when creating a database is: CREATE DATABASE dbname CHARSET utf8;
True
False
What is the primary purpose of the SELECT statement in MySQL?
To retrieve data from a database
To insert data into a database
To update existing records in a table
To delete data from a table
Which of the following is the correct syntax for selecting specific columns from a table?
SELECT FROM (column1, column2) table_name;
SELECT column1, column2 FROM table_name;
SELECT table_name FROM column1, column2;
SELECT * FROM column1, column2;
What does the asterisk (*) represent in a SELECT statement?
It selects only the primary key column
It selects a random sample of rows
It selects all columns from the specified table
It performs a mathematical operation on the data
Which keyword is used to eliminate duplicate values in the result set?
(a)
What is the purpose of the FROM clause in a SELECT statement?
To specify the columns to be selected
To filter the results based on a condition
To indicate the table from which to retrieve data
To sort the result set in a specific order
How would you select all columns from a table named 'Customers'?
(a)
Write a query that will return the number of distinct countries in the 'Customers' table.
(a)
What is the result of executing 'SELECT DISTINCT Country FROM Customers;'?
It returns all countries, including duplicates
It returns only the first occurrence of each country
It returns the total number of countries
It returns an error because DISTINCT is used incorrectly
Which of the following is true about the result-set in MySQL?
It is a permanent table stored in the database
It is a temporary table holding query results
It can only contain numeric data
It is limited to 100 rows by default
T/F: In the context of SELECT statements, an expression refer to a combination of column names and functions?
True
False
