cpt

Question 1

[Database Management] What is data warehousing?

Answer 1

A system for storing and analyzing large volumes of historical data.

Question 2

[Database Management] How does a database differ from a data warehouse?

Answer 2

Databases handle real-time transactions; data warehouses support analysis.

Question 3

[Database Management] What is data mining?

Answer 3

The process of extracting patterns and knowledge from large data sets.

Question 4

[Database Management] List forms of data collection.

Answer 4

Forms, RFID tags, cookies, transaction tracking, mobile data.

Question 5

[Database Management] What are examples of invisible online data collection?

Answer 5

Cookies, mobile location tracking, sensors.

Question 6

[Database Management] List ways to protect data.

Answer 6

Validation, verification, access control, logging, warehousing.

Question 7

[Database Management] What is metadata?

Answer 7

Data that describes other data, such as format, time of creation, author.

Question 8

[Database Design Concepts] What are key features of a good database?

Answer 8

Integrity, independence, low redundancy, security, easy maintenance.

Question 9

[Database Design Concepts] What is a primary key?

Answer 9

A field that uniquely identifies a record in a table.

Question 10

[Database Design Concepts] What is a foreign key?

Answer 10

A field in one table that refers to the primary key of another table.

Question 11

[Database Design Concepts] What is normalization?

Answer 11

Organizing data to eliminate redundancy and improve integrity.

Question 12

[Database Design Concepts] What is a composite key?

Answer 12

A primary key made up of two or more fields.

Question 13

[Database Design Concepts] What are anomalies in databases?

Answer 13

Problems such as redundancy or inconsistency in poorly designed databases.

Question 14

[Systems Technologies: Hardware] What is mobile technology?

Answer 14

Portable computing devices like smartphones, tablets, laptops.

Question 15

[Systems Technologies: Hardware] List advantages of mobile devices.

Answer 15

Lightweight, portable, access anywhere.

Question 16

[Systems Technologies: Hardware] List constraints of mobile technology.

Answer 16

Limited battery, performance, and screen size.

Question 17

[Systems Technologies: Hardware] What affects computer performance?

Answer 17

CPU/GPU speed, RAM, cache, storage type/speed, NIC speed.

Question 18

[Systems Technologies: Hardware] Why use a specific computer setup?

Answer 18

To match user needs like gaming, office work, or data analysis.

Question 19

[Systems Technology: Software] What is cloud computing?

Answer 19

Online storage and computing services, e.g., Google Drive, OneDrive.

Question 20

[Systems Technology: Software] What is SaaS?

Answer 20

Software as a Service, accessed via the Internet without installation.

Question 21

[Systems Technology: Software] What is virtual reality?

Answer 21

A simulated environment using hardware like headsets.

Question 22

[Systems Technology: Software] What is augmented reality?

Answer 22

Overlaying digital elements onto the real world.

Question 23

[Systems Technology: Software] What is virtualisation?

Answer 23

Creating virtual versions of hardware/software resources.

Question 24

[Social Implications] How does mobile tech impact privacy?

Answer 24

Data collection, tracking, data sharing without consent.

Question 25

[Social Implications] What are cyber crimes?

Answer 25

Phishing, malware, identity theft, ransomware.

Question 26

[Social Implications] Name types of internet-related attacks.

Answer 26

Worms, DoS, backdoors, botnets, spoofing.

Question 27

[Social Implications] What safeguards exist for cybercrime?

Answer 27

Firewalls, anti-virus, encryption, passwords.

Question 28

[Social Implications] Right to access vs. right to privacy?

Answer 28

Balancing public information access with personal data protection.

Question 29

[Programming and SQL] What does SQL SELECT do?

Answer 29

Retrieves data from one or more tables.

Question 30

[Programming and SQL] What is an SQL JOIN?

Answer 30

Combines rows from multiple tables using related columns.

Question 31

[Programming and SQL] What is the WHERE clause used for?

Answer 31

Filtering records based on specific conditions.

Question 32

[Programming and SQL] List SQL aggregate functions.

Answer 32

SUM, AVG, COUNT, MAX, MIN.

Question 33

[Programming and SQL] What does GROUP BY do?

Answer 33

Groups rows sharing a property to apply aggregate functions.

Question 34

[Programming and SQL] What are SQL wildcards?

Answer 34

Symbols like %, _ used in pattern matching with LIKE.

Question 35

[Programming and SQL] What are parameter queries?

Answer 35

SQL queries that accept input from users.

Question 36

[Programming and SQL] What are SQL date functions?

Answer 36

Functions like DAY(), MONTH(), YEAR(), DATE().

Question 37

[Object-Oriented Programming] What is a constructor?

Answer 37

A method used to initialize an object when created.

Question 38

[Object-Oriented Programming] Define accessor and mutator methods.

Answer 38

Accessors return field values; mutators modify them.

Question 39

[Object-Oriented Programming] What is ToString used for?

Answer 39

Returns a string that represents the object.

Question 40

[Object-Oriented Programming] What is encapsulation?

Answer 40

Hiding data by making attributes private and using methods to access.

Question 41

[Object-Oriented Programming] What is instantiation?

Answer 41

Creating an actual object from a class.

Question 42

[Arrays and Data Structures] What is a 2D array?

Answer 42

A grid-like structure with rows and columns.

Question 43

[Arrays and Data Structures] How do you loop through a 2D array?

Answer 43

Using nested loops.

Question 44

[Arrays and Data Structures] What operations can you perform on a 2D array?

Answer 44

Row/column sums, search, edit values.

Question 45

[Networks and Internet] What is a switch?

Answer 45

A device that connects network devices and directs data.

Question 46

[Networks and Internet] What is a router?

Answer 46

Connects networks and directs internet traffic.

Question 47

[Networks and Internet] What is VPN?

Answer 47

Virtual Private Network, creates secure remote connections.

Question 48

[Networks and Internet] What is BitTorrent?

Answer 48

A peer-to-peer file-sharing protocol.

Question 49

[Networks and Internet] List online services examples.

Answer 49

Dropbox, GSuite, Office365, remote desktop.

Question 50

[E-Communication and Security] What is SSL?

Answer 50

Secure Sockets Layer encrypts data for safe transmission.

Question 51

[E-Communication and Security] What is a digital certificate?

Answer 51

Verifies a website's identity and enables encryption.

Question 52

[E-Communication and Security] What is a firewall?

Answer 52

A system that prevents unauthorized access to or from a network.

Question 53

[General Concepts] How to choose a computer?

Answer 53

Consider CPU, RAM, storage, usage needs.

Question 54

[General Concepts] What are benefits of knowing IT basics?

Answer 54

Solve problems, make informed tech decisions, protect data.

Question 55

[General Concepts] How can technology help career paths?

Answer 55

Enables remote work, automation, communication, data analysis.