CSEC IT Knowledge Assessment 2

What is a Database Management System (DBMS)?

• A Database Management System (DBMS) is a type of hardware used for data storage.

• A Database Management System (DBMS) is software that facilitates the creation, management, and manipulation of databases.

• A Database Management System (DBMS) is a programming language for web development.

• A Database Management System (DBMS) is a cloud service for file sharing.

Name three types of DBMS.

• Object-oriented DBMS

• Hierarchical DBMS, Relational DBMS, NoSQL DBMS

• Graph DBMS

• Flat-file DBMS

What is the purpose of normalization in databases?

• The purpose of normalization is to reduce data redundancy and improve data integrity.

• To eliminate all data from the database completely.

• To simplify database queries and reduce performance.

• To increase data redundancy and decrease data integrity.

Explain the difference between primary key and foreign key.

• The primary key uniquely identifies a record in its own table, while a foreign key links to a primary key in another table.

• A primary key can be duplicated in the same table, while a foreign key cannot.

• A primary key is used to link tables, while a foreign key is used to identify records within the same table.

• Both primary key and foreign key serve the same purpose in a database.

What is SQL and what is it used for?

• SQL is a type of spreadsheet software.

• SQL is a markup language for designing websites.

• SQL is used for creating web applications.

• SQL is a programming language used for managing and manipulating relational databases.

Describe the steps in the problem-solving process.

• Ask someone else to solve it for you

• Only focus on the first solution you think of

• Ignore the problem and move on

• Identify the problem, gather information, generate solutions, evaluate solutions, choose the best solution, implement it, and review results.

What is an algorithm and why is it important in programming?

• An algorithm is a graphical representation of data flow in programming.

• An algorithm is a random guess to solve a problem.

• An algorithm is a type of programming language used for coding.

• An algorithm is a step-by-step procedure for solving a problem, and it is important in programming for providing clear instructions and optimizing performance.

Define the term 'data structure' and give an example.

• An example of a data structure is a 'linked list'.

• A data structure is a programming language.

• An example of a data structure is a 'function'.

• A data structure is a type of algorithm.

What are the main components of a computer system?

• Network cables and routers

• Operating system and software applications

• Motherboard, power supply, and graphics card

• The main components of a computer system are CPU, memory (RAM), storage, and input/output devices.

Explain the difference between hardware and software.

• Hardware refers to the software applications used on a computer; software is the physical parts.

• Hardware is the physical components of a computer; software is the programs that run on the hardware.

• Hardware and software are interchangeable terms for computer components.

• Hardware is the data stored on a computer; software is the network connections.