Free 102-500 Exam Braindumps

- (Exam Topic 1)
Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?

1. A. SELECT order_type,COUNT(*) FROM orders WHERE order_type=order_type;
2. B. SELECT order_type,COUNT(*) FROM orders GROUP BY order_type;
3. C. COUNT(SELECT order_type FROM orders);
4. D. SELECT COUNT(*) FROM orders ORDER BY order_type;
5. E. SELECT AUTO_COUNT FROM orders COUNT order_type;

Correct Answer: B

- (Exam Topic 5)
Which command, depending on its options, can display the open network connections, the routing tables, as well as network interface statistics. (Specify ONLY the command without any path or parameters.)
Solution:
netstat, /bin/netstat, ss, /usr/bin/ss

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
Which of the following commands can be used to display the local routing table? (Choose TWO correct answers.)

1. A. ifconfig
2. B. dig
3. C. netstat
4. D. route
5. E. trackroute

Correct Answer: CD