Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?

A. SELECT order_type,COUNT(*) FROM orders WHERE order_type=order_type;

B. SELECT order_type,COUNT(*) FROM orders GROUP BY order_type;

C. COUNT(SELECT order_type FROM orders);

D. SELECT COUNT(*) FROM orders ORDER BY order_type;

E. SELECT AUTO_COUNT FROM orders COUNT order_type;

Which of the following commands should be added to /etc/bash_profile in order to change the language of messages for an internationalized program to Portuguese (pt)?

A. export LANGUAGE="pt"

B. export MESSAGE="pt"

C. export UI_MESSAGES="pt"

D. export LC_MESSAGES="pt"

E. export ALL_MESSAGES="pt"

Why should a regular user edit his personal crontab by using the command crontab instead of just editing his crontab file manually?

A. Because user specific crontab entries are stored in a common database and must be extracted before editing.

B. Because crontab starts the cron daemon in case it is not running due to no other crontab entries existing.

C. Because user specific crontab entries are stored in a special directory which is maintained by the cron daemon and not writable for regular users.

D. Because crontab collects information about all users crontabs and recommends similar commands used by other users of the system.

Which option in the /etc/ntp.conf file specifies an external NTP source to be queried for time information? (Specify ONLY the option without any values or parameters.)

A. server

What is the purpose of the nsswitch.conf file?

A. It is used to configure where the C library looks for system information such as host names and user passwords.

B. It is used to configure network protocol port numbers such as for HTTP or SMTP.

C. It is used to configure LDAP authentication services for the local system.

D. It is used to configure which network services will be turned on during the next system boot.

Which of the following IPv4 networks are reserved by IANA for private address assignment and private routing? (Choose THREE correct answers.)

A. 127.0.0.0/8

B. 10.0.0.0/8

C. 169.255.0.0/16

D. 172.16.0.0/12

E. 192.168.0.0/16

What of the following can be done by the command ifconfig? (Choose TWO correct answers.)

A. Set a network interface active or inactive.

B. Specify the kernel module to be used with a network interface.

C. Allow regular users to change the network configuration of a network interface.

D. Change the netmask used on a network interface.

E. Specify which network services are available on a network interface.

Which of the following is a valid IPv6 address?

A. 2001:db8:3241::1

B. 2001::db8:4581::1

C. 2001:db8:0g41::1

D. 2001%db8%9990%%1

E. 2001.db8.819f..1

When issuing the command ifconfig eth0 192.168.1.20/24 up, which of the following happens? (Choose two correct answers.)

A. The address 192.168.1.20 is associated with the interface eth0.

B. A network route to 192.168.1.0 with the netmask 255.255.255.0 pointing directly to eth0 is created.

C. 192.168.1.1 is probed for router functionality and, in case of success, it is added to the list of default routers.

D. The addresses from 192.168.1.20 to 192.168.1.24 are activated on the interface eth0.

E. If eth0 was configured with a previous IP address, it is retained an addition to adding the new address.

Which of the following commands can modify or set the password expiration for a user? (Choose two correct answers.)

A. chage

B. chexpiration

C. shadowconfig

D. passwd

E. userconf