Q1. - (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? 

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; 

View Answer

Q2. CORRECT TEXT - (Topic 5) 

How many IP-addresses can be used for unique hosts inside the IPv4 subnet 192.168.2.128/28? (Specify the number only without any additional information.) 

View Answer

Q3. - (Topic 5) 

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. 

View Answer

Q4. - (Topic 4) 

What is true about the ntpdate command? 

A. It is the primary management command for the NTP time server. 

B. It updates the local system's date (i.e. day, month and year) but not the time (i.e. hours, minutes,seconds). 

C. It queries one or more NTP time servers and adjusts the system time accordingly. 

D. It sends the local system time to one or many remote NTP time servers for redistribution. 

E. It can be used by any user to set the user clock independently of the system clock. 

View Answer

Q5. CORRECT TEXT - (Topic 3) 

In which file, if present, must all users be listed that are allowed to use the cron scheduling system? (Specify the full name of the file, including path.) 

View Answer

Q6. - (Topic 1) 

When the command echo $ outputs 1, which of the following statements is true? 

A. It is the process ID of the echo command. 

B. It is the process ID of the current shell. 

C. It is the exit value of the command executed immediately before echo. 

D. It is the exit value of the echo command. 

View Answer

Q7. - (Topic 4) 

Which of the following parameters are used for journalctl to limit the time frame of the output? (Choose TWO correct answers.) 

A. --from= 

B. --since= 

C. --until= 

D. --upto= 

E. --date= 

View Answer

Q8. CORRECT TEXT - (Topic 1) 

What word is missing from the following SQL statement? 

insert into tablename ________(909, 'text'); 

(Please specify the missing word using lower-case letters only.) 

View Answer

Q9. - (Topic 2) 

What is the purpose of a screen reader? 

A. It reads text displayed on the screen to blind or visually impaired people. 

B. It reads the parameters of the attached monitors and creates an appropriate X11 configuration. 

C. It displays lines and markers to help people use speed reading techniques. 

D. It manages and displays files that contain e-books. 

View Answer

Q10. - (Topic 2) 

Which of the following commands shows the current color depth of the X Server? 

A. xcd 

B. xcdepth 

C. xwininfo 

D. xcolordepth 

E. cat /etc/X11 

View Answer