Question
What is the primary purpose of a firewall in computer
networks?Solution
A firewall is a security system that monitors and controls incoming and outgoing network traffic based on predetermined security rules, protecting a network from unauthorized access.
Which SQL query will correctly calculate the average salary of employees in each department and group them by department in a table named 'employees'?
In a snowflake schema of a data warehouse, which of the following consequences is most likely as a result of normalization of dimension tables?
A surrogate key is:
Which of these is NOT an ensemble method?
Which of the following best describes a Data Warehouse?
Which schema in data warehousing uses a central fact table connected to dimension tables?
Which of the following commands is part of the Transaction Control Language (TCL) in SQL?
In the context of a relational database, which of the following is NOT a characteristic of a candidate key ?
What is meant by 'cardinality' in data modeling?
Which OLAP operation allows users to view data at different levels of granularity?
Relevant for Exams:
