Pass the LPIC Level 1 102-500 Questions and answers with ExamsMirror

The xwininfo command is a utility for displaying information about windows on an X server. One of the information it displays is the depth of the window, which is the number of bits per pixel used to represent the color of the window. The depth of the root window, which is the background window of the X server, is the same as the color depth of the X server. To display the depth of the root window, one can use the command xwininfo -root and look for the line that says “depth of root window”. Alternatively, one can use the command xdpyinfo, which displays information about the X server, and look for the line that says “depths of root window”. References:

xwininfo(1) - Linux man page

xdpyinfo(1) - Linux man page

[LPI Linux Certification/Configure the X Window System, Xorg and …]

The xwininfo command is a utility for displaying information about windows in X. It can show various attributes of a window, such as its location, size, depth, border width, visual class, colormap, map state, and event masks. The -metric option specifies that all dimensions should be displayed in metric units (millimeters) rather than pixels. By issuing the xwininfo -metric command and then clicking on a window, the administrator can determine the geometry of that window, including the decorations, in millimeters. References:

xwininfo(1) — Arch manual pages

[command line -

 The Sticky Keys feature in X is an accessibility option that allows users to press modifier keys (such as Ctrl, Alt, Shift, or the Windows key) one at a time, instead of holding them down simultaneously, to perform keyboard shortcuts. For example, to copy something, a user can press Ctrl, release it, and then press C, instead of pressing Ctrl+C together. This can be helpful for users who have difficulty pressing multiple keys at once, or who prefer not to do so. References:  https://www.howtogeek.com/739764/how-to-turn-off-sticky-keys-on-windows-10/

https://geekflare.com/using-sticky-keys-in-windows/

 The correct format for the DISPLAY environment variable is hostname:displaynumber.screennumber, where hostname is the name of the computer where the X server runs, displaynumber is a sequence number (usually 0) that identifies a display, and screennumber is the number of the screen within that display (usually 0). The screennumber can be omitted if it is 0. For example, localhost:0 or myhost:1.0 are valid values for the DISPLAY variable. The other options are either missing the colon, using the wrong separator, or not specifying the display number. References:

X11 - DISPLAY (environment variable) - Datacadamia

x11 - How can I specify a display? - Stack Overflow

What is the $DISPLAY environment variable? - Ask Ubuntu

 The name of the simple graphical login manager that comes with a vanilla X11 installation is xdm. XDM is the traditional graphical login manager for the X Window System, independent of any window manager or environment the user might choose. When it is run at system startup, it displays a graphical login prompt rather than the text-based login prompt at the console1. XDM is part of the xorg-x11-apps package, which provides the basic applications for the X Window System2. XDM is also one of the topics covered by the LPI Linux Professional - Exam 102 Objectives - Topic 111: Graphical Desktops3. References:

xorg-x11-apps - Linux Man Pages (1) - SysTutorials

LPI Linux Professional - Exam 102 Objectives - Topic 111: Graphical Desktops

GitHub - iwamatsu/slim: SLiM (Simple Login Manager) is a graphical login manager for X11

slim-fork download | SourceForge.net

Using the XDM Graphical Login Manager | FreeBSD 6 Unleashed - Flylib

Xorg - ArchWiki

How to remotely log in with full graphical desktop over X11 - Unix & Linux Stack Exchange

The xhost program is used to add and delete host names or user names to the list allowed to make connections to the X server1. In the case of hosts, this provides a rudimentary form of privacy control and security. It is only sufficient for a workstation (single user) environment, although it does limit the worst abuses1. However, if xhost is used to grant access to everyone, even if they aren’t on the list (i.e., access control is turned off), then any user on the network can connect to your X server and monitor your keystrokes, capture your screen, or run malicious programs2. This is why xhost is considered dangerous to use and should be avoided in favor of more secure methods, such as xauth or ssh23. References:

xhost linux command man page - commandlinux.com

Linux Xhost Command Help and Examples - Computer Hope

xhost(1) — Arch manual pages

The command that allows you to make a shell variable visible to subshells is export VARIABLE. This command turns the variable into a global or environment variable, which means it can be accessed by any child process or subshell that inherits the environment of the parent shell. The syntax of the export command does not require a dollar sign ($) before the variable name, unlike when referencing the value of the variable. The other commands are either invalid or do not affect the visibility of the variable to subshells. The set command can be used to assign values to variables, but it does not export them. The env command can be used to run a command in a modified environment, but it does not change the environment of the current shell. References:

[LPI Linux Essentials - Topic 105: Shells, Scripting and Data Management]

[LPI Linux Professional - Exam 102 Objectives - Topic 105: Shells and Shell Scripting]

What is a Subshell? - Linux Bash Shell Scripting Tutorial Wiki - nixCraft

What is Subshell in Linux? [Explained]

 The $? variable in bash is a special parameter that holds the exit status of the last command executed in the current shell. The exit status is a numerical value that indicates whether the command was successful (zero) or failed (non-zero). The echo command simply prints its arguments to the standard output. Therefore, when the command echo $? outputs 1, it means that the previous command failed with an exit status of 1. References:

[LPI Linux Essentials - Topic 103: Command Line Basics]

[Bash Special Parameters]

[Exit status - Wikipedia]

The missing word is select, which is the keyword used to query data from a table in SQL. The select statement has the following syntax:

select column_list from table_name where condition;

The column_list can be one or more columns separated by commas, or an asterisk () to indicate all columns. The table_name is the name of the table that contains the data. The where clause is optional and specifies a condition to filter the rows. The count() function is an aggregate function that returns the number of rows in the table or in a group. Therefore, the complete statement is:

select count(*) from tablename;

This statement will return the number of rows in the table named tablename. References: SQL COUNT() Function - W3Schools, SQL COUNT: The Ultimate Guide To SQL COUNT Function - SQL Tutorial, The SQL Count Function Explained With 7 Examples.

The correct SQL query to count the number of occurrences for each value of the field order_type in the table orders is:

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

This query uses the SELECT statement to retrieve the values of the order_type field and the COUNT(*) function to count the number of rows for each order_type. The GROUP BY clause groups the rows by the order_type field, so that the count is calculated for each distinct value of order_type. The result of this query is a table with two columns: order_type and count, where each row shows the number of orders for a specific order_type.

The other options are incorrect for the following reasons:

A: This query uses a WHERE clause that is always true, since order_type=order_type for every row. Therefore, this query returns the same result as SELECT order_type,COUNT(*) FROM orders;, which is a table with one row that shows the total number of orders, regardless of the order_type.

C: This query is syntactically invalid, since the COUNT function cannot take a subquery as an argument. The correct way to use a subquery with COUNT is COUNT((SELECT order_type FROM orders));, which returns the total number of orders, regardless of the order_type.

D: This query uses the ORDER BY clause to sort the rows by the order_type field, but it does not group them by order_type. Therefore, this query returns the same result as SELECT COUNT(*) FROM orders;, which is a table with one row that shows the total number of orders, regardless of the order_type.

E: This query is syntactically invalid, since there is no such function as AUTO_COUNT in SQL, and the COUNT function cannot take a field name as an argument. The correct way to use COUNT with a field name is COUNT(order_type);, which returns the number of non-null values in the order_type field.

References:

[SQL COUNT Function]

[SQL GROUP BY Statement]

[SQL SELECT Statement]