You are asked to write an SQL query to calculate the total revenue from the "Sales" table for a specific date range. Which SQL clause should be used to filter the results based on the date?
- GROUP BY
- HAVING
- ORDER BY
- WHERE
The WHERE clause is used to filter rows based on a specified condition. In this scenario, you would use the WHERE clause to specify the date range for which you want to calculate the total revenue from the "Sales" table. This clause ensures that only the relevant rows within the specified date range are included in the calculation.
Which type of cybersecurity threat involves disguising malicious activities as legitimate requests to gain unauthorized access?
- DDoS Attack
- Malware
- Phishing
- Social Engineering
Social Engineering is a form of cyberattack where the attacker manipulates people into revealing confidential information or performing actions. It often involves disguising malicious activities as legitimate requests to trick victims. Phishing, Malware, and DDoS attacks are different types of cyber threats.
SSL/TLS uses _______ keys to encrypt the data and ensure secure transmission.
- Asymmetric
- Private
- Public
- Symmetric
SSL/TLS uses asymmetric keys, including a public key for encryption and a private key for decryption, to secure data transmission.
When securing web applications, what does the principle of "least privilege" mean?
- Giving just enough access
- Giving the least
- Giving the most
- Giving unlimited access
The principle of "least privilege" in web application security means providing users or processes with the minimum level of access necessary to perform their tasks. This helps limit potential damage and unauthorized actions.
Which component of an operating system ensures that only authorized users can access specific resources?
- Access Control
- Authentication
- Firewall
- UEFI
Authentication mechanisms, such as passwords, biometrics, or smart cards, are used to verify the identity of users. Once verified, the system grants access to specific resources, ensuring that only authorized users can access them.
Which type of firewall filtering technique makes decisions based on the application layer protocol?
- Application Layer Gateway (ALG)
- Network Address Translation (NAT)
- Packet Filtering
- Stateful Packet Inspection (SPI)
An Application Layer Gateway (ALG) is a firewall filtering technique that makes decisions based on the application layer protocol. ALGs are responsible for understanding and processing application-specific protocols, making them suitable for filtering at the application layer.
What is the primary function of an Intrusion Detection System (IDS)?
- Assign IP addresses to devices
- Block network connections
- Monitor and detect suspicious activities
- Optimize data transfer rates
The primary function of an Intrusion Detection System (IDS) is to monitor and detect suspicious activities on a network or system for enhanced security.
What is the primary objective of performance testing in databases?
- Assessing database speed and responsiveness
- Ensuring data consistency
- Evaluating database security
- Monitoring database usage patterns
Performance testing in databases primarily aims to assess the speed and responsiveness of the database system under various conditions such as heavy loads, concurrent users, or large datasets. Performance testing helps identify bottlenecks and optimize database performance.
In authentication testing, the process of verifying the identity of a user or system is known as ____________.
- Authentication
- Authorization
- Validation
- Verification
Authentication testing involves validating the identity of a user or system to ensure that only authorized entities gain access. Verification is the process of evaluating if the requirements are met, while validation ensures that the system meets the user's needs. Authentication specifically deals with confirming the identity of users or systems accessing a resource. Authorization, on the other hand, pertains to granting access rights based on authenticated identities.
The practice of sending fraudulent emails pretending to be from reputable companies to induce individuals to reveal personal information is known as _______.
- Hacking
- Malware
- Phishing
- Spoofing
Sending fraudulent emails pretending to be from reputable companies to trick individuals into revealing personal information is known as Phishing. It's a common method for cybercriminals to obtain sensitive data.