Question

Question 7

Which of the following is the correct fully condensed form of

2002:0000:0000:0000:0206:0000:a80c:052b?

2002::0206::a80c:052b

2002::2006:0:a80c:52b

2002:0:0:0:206:0:a80c:52b

2002::0206:0:a80c:052b

Question 1

Which of the following is a process to verify policy compliance?

Penetration test

Security audit

Security assessment

Threat mitigation

Log Assessment

Question 2

Which of the following is not a type of monitoring device?

Server log

HIPS

IPS

NIPS

Firewall

Question 4

What is the error in the following SQL statement?

SELECT CustomerCity, Count(CustomerKey)

FROM Customer

GROUP BY CustomerCity

WHERE Count(CustomerCity) > 20

The GROUP BY clause is in the wrong place.

You cannot use a WHERE clause when the criteria contains an aggregate function.

You cannot use a WHERE clause and GROUP BY clause together.

There is nothing wrong with the query.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 7:

Answer :2002::2006:0:a80c:52b

********************************

Question 2:

Answer :IPS

Explanation : Intrusion detection systems (IDSs) is network security device system.

********************************

Question 4:

Answer :You cannot use a WHERE clause when the criteria contains an aggregate function.

Explanation :

• In given query need to use having clause instead of where clause.
• Also where clause can not be used with aggregate functions like sum() ,count() etc.

********************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.