102-500 exam

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...

Of the ways listed, which is the best method to temporarily suspend a user's ability to interactively login?A . Use passwd -d username to give the user an empty password.B . Use chage to expire the user account.C . Change the user's password.D . Add the command exit to the...

On a system using shadowed passwords, the most correct permissions for /etc/passwd are ___ and the most correct permissions for /etc/shadow are _________.A . -rw-r-----, -r--------B . -rw-r--r--, -r--r--r--C . -rw-r--r--, -r--------D . -rw-r--rw-, -r-----r--E . -rw-------, -r--------View AnswerAnswer: C Explanation: The /etc/passwd file stores local accounts of the system....

Which of the following fields are available in both the global /etc/crontab file as well as in user-specific crontab files? (Select TWO correct answers)A . YearB . MinuteC . UsernameD . CommandView AnswerAnswer: B, D Explanation: The crontab file format consists of six fields: minute, hour, day of month, month,...

What is true regarding the command userdel --force --remove bob? (Choose TWO correct answers.)A . The user bob is removed from the system's user database.B . The user bob's home directory is removed.C . The locate database is updated to drop files owned by bob.D . All files owned by...

Which of the following crontab entries will execute myscript at 30 minutes past every hour on Sundays? A. 0 * * * 30 myscript B. 30 * * * 6 myscript C. 30 0 * * 0 myscript D. 30 0-23 * * 0 myscript E. 0 0-23 * *...

After configuring printing on a Linux server, the administrator sends a test file to one of the printers and it fails to print. What command can be used to display the status of the printer's queue? (Specify ONLY the command without any path or parameters.)View AnswerAnswer: lpq, /usr/bin/lpq, lpstat, /usr/bin/lpstat...

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...

On a system running the KDE Display Manager, when is the /etc/kde4/kdm/Xreset script automatically executed?A . When KDM startsB . When a user's X session exitsC . When KDM crashesD . When X is restartedE . When X crashesView AnswerAnswer: B Explanation: The /etc/kde4/kdm/Xreset script is a script that runs...

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.)View AnswerAnswer: server Explanation: The server option is used to configure a persistent association with a remote server or peer. It takes an argument that...