NEW
Font size
WorksheetsMUITICT_06_test
Total questions: 72
Worksheet time: 54mins
What is a database?
A collection of unrelated data
A hardware component of a computer
An organized collection of data stored electronically
A type of software for word processing
What does DBMS stand for?
Data Base Management System
Database Management Software
Data Backup Management System
Database Backup Software
Which of the following is a characteristic of a flat-file database?
Stores data in a single file
Enforces data integrity
Uses SQL for queries
Supports multiple tables
What is a primary key?
A type of data format
A unique identifier for each record in a table
A method of data retrieval
A key that links to another table
Which type of database is designed for unstructured data?
Flat File Database
NoSQL Database
Relational Database
Object-oriented Database
What is the main advantage of using a relational database?
Lower cost of implementation
Human-readable format
Data integrity through constraints
Simplicity in design
What does SQL stand for?
Structured Query Language
Structured Quick Language
Simple Query Language
Standard Query Language
Which of the following is NOT a function of a database?
Data retrieval
Data manipulation
Data encryption
Data definition
What is a foreign key?
A unique identifier for a record
A method of data storage
A key that links to a primary key in another table
A type of data format
What is a disadvantage of flat-file databases?
High cost of implementation
Multi-user access
Data redundancy
Complex querying capabilities
Which of the following is a use case for relational databases?
Creating backup copies of data
Managing customer information
Storing simple text files
Transferring data between applications
What is normalization in the context of databases?
The process of creating backups
The process of importing data
The process of organizing data to reduce redundancy
The process of encrypting data
What is a characteristic of NoSQL databases?
They offer flexibility in data storage
They are designed for structured data
They require complex hardware
They use SQL for queries
What is the main purpose of a database management system (DBMS)?
To create hardware components
To manage and manipulate databases
To store data in a flat file
To perform data encryption
What is a relation in the context of relational databases?
A unique identifier for each record
A set of tuples sharing the same attributes
A collection of related data entries
A specific piece of data within a record
What does a table represent in a relational database?
A mathematical concept
A collection of related data entries
A unique identifier for records
A property of an entity
What is a field in a database?
A type of data structure
A collection of records
A single piece of data within a record
A unique identifier for a table
What is an attribute in a database?
A collection of related data
A property or characteristic of an entity
A specific data type
A unique identifier for a record
What is a record in a database?
A unique identifier for a table
A single instance of an entity
A type of data structure
A collection of fields
What defines the kind of data that can be stored in a field?
Field Properties
Field Length
Data Type
Field Name
What is a primary key?
A collection of related data entries
A unique identifier for each record in a table
A type of data structure
An attribute that references another table
What is a foreign key?
A specific data type
An attribute that links to the primary key of another table
A unique identifier for a record
A collection of fields in a table
What is the purpose of data types in a database?
To define the structure of a table
To enforce data integrity by ensuring valid data
To create relationships between tables
To represent a unique identifier
What is the difference between a relation and a table?
A relation is unordered, while a table is ordered
A relation is a physical implementation, while a table is abstract
A relation can have duplicate tuples, while a table cannot
A relation is a collection of fields, while a table is a collection of records
What is a composite attribute?
An attribute that is calculated from other attributes
An attribute that can be broken down into smaller sub-attributes
An attribute that holds multiple values
An attribute that cannot be divided further
What is the role of attributes in database design?
To define the relationships between tables
To describe the properties of entities
To enforce data integrity
To represent unique identifiers
What type of relationship allows one record in Table A to relate to multiple records in Table B?
Many-to-One
One-to-Many
Many-to-Many
One-to-One
What is a derived attribute?
An attribute that is calculated from other attributes
An attribute that cannot be divided further
An attribute that can hold multiple values
An attribute that holds a single value
What is a record in database terminology?
A single unit of data stored in a table
A collection of unrelated data
A type of data manipulation
A method for data retrieval
What does a primary key do in a database?
Links two tables together
Stores large binary objects
Ensures data is stored in a specific format
Uniquely identifies each record in a table
Which of the following is NOT a category of data types?
Graph Data Types
String Data Types
Numeric Data Types
Boolean Data Types
What is the purpose of a foreign key?
To store large text data
To maintain referential integrity between tables
To create a unique identifier for records
To define the structure of a table
Which SQL command is used to define a primary key?
PRIMARY KEY
ALTER TABLE
CREATE TABLE
INSERT INTO
What does a NULL value in a primary key indicate?
It is not allowed
It is acceptable
It can be used for indexing
It represents an unknown value
In a database, what is the role of a composite key?
To define data types
To store binary data
To combine multiple attributes for uniqueness
To link multiple tables
Which of the following is an example of a string data type?
VARCHAR
DATE
FLOAT
INT
What is the significance of choosing the correct data type?
It is only relevant for large databases
It determines the number of records in a table
It influences storage requirements and performance
It affects the visual representation of data
What is a characteristic of foreign keys?
They can accept NULL values
They must always be unique
They are used for indexing
They cannot reference primary keys
What does the term 'referential integrity' refer to?
The structure of a database
The ability to retrieve data quickly
The relationship between primary and foreign keys
The accuracy of data within a table
Which of the following is a numeric data type?
FLOAT
VARCHAR
BLOB
TEXT
What is the first step in creating a database structure?
Organizing data into tables
Requirements analysis
Creating relationships
Defining data types
In SQL, how can you define a foreign key?
Using the UNIQUE constraint
Using the FOREIGN KEY constraint
Using the PRIMARY KEY constraint
Using the INDEX command
What is the purpose of a data type in a database?
To create relationships between tables
To ensure data is visually appealing
To specify the kind of value that can be stored in a column
To define the structure of a table
What is the purpose of a primary key in a database table?
To define the data type of a column
To create relationships between tables
To uniquely identify each record in a table
To store multiple values in a single column
Which of the following is NOT a part of the normalization process?
Third Normal Form (3NF)
Second Normal Form (2NF)
First Normal Form (1NF)
Data Aggregation
What does the SQL command 'DELETE' do?
Adds new records to a table
Retrieves data from a table
Modifies existing records
Removes records from a table
Which SQL command is used to retrieve data from a database?
INSERT
UPDATE
SELECT
DELETE
What is the main purpose of data manipulation?
To establish relationships between tables
To design database structures
To prepare data for analysis
To create new databases
In an Entity-Relationship Diagram (ERD), what does each box represent?
An entity with its attributes
A primary key
A relationship between tables
An attribute of an entity
Which of the following is a data manipulation technique?
Data Normalization
Data Cleaning
Data Definition
Data Structuring
What does the 'JOIN' operation in SQL do?
Updates existing records
Deletes records from a table
Creates new tables
Combines data from multiple tables
Which of the following tools is NOT typically used for data manipulation?
Microsoft Excel
Power BI
Tableau
Notepad
What is the purpose of filtering in data manipulation?
To remove duplicates from a dataset
To select specific rows or columns based on criteria
To sort data in a specific order
To aggregate data into summary statistics
Which SQL command is used to modify existing records?
INSERT
UPDATE
SELECT
DELETE
What does the term 'data transformation' refer to?
Changing the format or structure of data
Filtering data based on conditions
Cleaning data for accuracy
Aggregating data for analysis
Which of the following is an example of an aggregate function in SQL?
DELETE
UPDATE
SUM
SELECT
What is the role of foreign keys in a database?
To define the primary key of a table
To establish relationships between tables
To create indexes for faster searches
To store data types for columns
Which of the following best describes data normalization?
Filtering data for analysis
Combining data into larger tables
Organizing data to reduce redundancy
Creating new records in a database
What does SQL stand for?
Simple Query Language
Structured Query Language
Standard Query Language
Systematic Query Language
Which command is used to create a new table in SQL?
NEW TABLE
ADD TABLE
INSERT TABLE
CREATE TABLE
What is the purpose of the ALTER TABLE command?
To delete a table
To modify an existing table structure
To create a new table
To retrieve data from a table
Which SQL command is used to remove records from a table?
DELETE
CLEAR
REMOVE
DROP
What is a primary key in a database?
A key that links two tables
A key used for data retrieval
A unique identifier for each record
A key that allows multiple records
Which of the following is a feature of NoSQL databases?
Supports only structured data
Allows flexible schema design
Uses SQL for data manipulation
Requires ACID compliance
What type of database management system organizes data in a tree-like structure?
Hierarchical DBMS
Object-Oriented DBMS
Relational DBMS
Network DBMS
Which command is used to start a transaction in SQL?
START
INITIATE
OPEN
BEGIN
What is the purpose of data normalization?
To enhance security
To minimize redundancy
To increase redundancy
To improve performance
Which of the following is NOT a type of data presentation?
Textual Presentation
Tabular Presentation
Diagrammatic Presentation
Statistical Presentation
What is a key advantage of using visual data presentation?
It is always more accurate
It captures attention better
It requires less data
It is easier to create
Which tool is known for its powerful visualization capabilities?
Notepad
Excel
Tableau
Microsoft Word
What is the first step in producing a report?
Review and Revise
Choose Visualization Techniques
Define Objectives
Gather Data
Which of the following is a feature of Object-Oriented Database Management Systems?
Stores data as objects
Organizes data in a tree structure
Uses SQL for data manipulation
Stores data in tables
