Understanding Data and Information

What are the basic data types in programming?

• Integer, Float, Character, String, Boolean

• Date, Time, Timestamp

• Array, List, Dictionary

• Object, Class, Module

What is the difference between integer and float data types?

• Floats are used for counting; integers are used for measurements.

• Integers are whole numbers; floats can represent decimal values.

• Integers can represent decimal values; floats cannot.

• Integers can only be negative; floats can only be positive.

What is a string data type used for?

• To store numerical data.

• To create graphical user interfaces.

• To manage database connections.

• To store and manipulate text data.

What is a Boolean data type?

• A data type that can only be a number.

• A data type that represents a collection of values.

• A data type that can be either yes or no.

• A data type that can be either true or false.

What is the purpose of a Database Management System (DBMS)?

• To manage hardware components

• To create and design websites

• The purpose of a Database Management System (DBMS) is to manage and organize data in a structured way, allowing for efficient data storage, retrieval, and manipulation.

• To provide internet security

Name two types of Database Management Systems.

• Relational Database Management Systems (RDBMS) and NoSQL databases

• Hierarchical Database Management Systems

• Flat File Database Systems

• Object-Oriented Database Management Systems

What is SQL and what is it used for?

• SQL is used for creating mobile applications.

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

• SQL is a markup language for designing web pages.

• SQL is a programming language for web development.

What is the difference between a primary key and a foreign key?

• A primary key is used for indexing, while a foreign key is used for sorting.

• A primary key uniquely identifies records in a table, while a foreign key links records between two tables.

• A primary key is always a string, while a foreign key is always an integer.

• A primary key can be null, while a foreign key cannot be null.

What are the three main types of data models?

• Object-Oriented, Functional, Procedural

• Hierarchical, Network, Relational

• Flat, Dimensional, Graph

• Sequential, Associative, Distributed

What is the principle of least privilege in information security?

• Granting users full access to all systems.

• Restricting access to only administrative users.

• Allowing users to access any data they want.

• The principle of least privilege in information security means granting users only the access necessary to perform their tasks.