Database II - SS3 ICT Past Questions and Answers - page 2
What does the term "Normalization" mean in the context of databases?
Making data less secure
Organizing data efficiently by reducing redundancy and data anomalies
Adding more data to a database
Deleting data from a database
What is the purpose of a database backup?
To make the database run faster
To permanently delete data
To prevent data loss by creating a copy of the database
To hide sensitive data
Which SQL statement is used to add new records to a database table?
MODIFY
INSERT INTO
CREATE TABLE
DELETE FROM
What does SQL JOIN do?
Combine data from multiple tables based on a related column
Delete data from a table
Add new columns to a table
Create a new database
What is the purpose of database indexes?
To store large files
To physically arrange data in the database
To optimize query performance by allowing faster data retrieval
To categorize data
Explain the concept of database normalization
Describe the steps involved in creating a new table in a database: Creating a new table in a database involves several steps
How can you improve the performance of database queries: Database query performance can be enhanced through various strategies?
Why is it important to perform regular database backups, and how would you restore a database from a backup?