Lpi LPI Certifications 102-500 Questions & Answers

• Question 171:

  Which of the following words is used to restrict the records that are returned from a SELECT SQL query based on a supplied criteria for the values in the records?

  A. CASE

  B. FROM

  C. WHERE

  D. IF

  Correct Answer: C

• Question 172:

  How is a display manager started?

  A. It is started by a user using the command startx.

  B. It is started like any other system service by the init system.

  C. It is started by inetd when a remote hosts connects to the X11 port.

  D. It is started automatically when a X11 user logs in to the system console.

  Correct Answer: B

• Question 173:

  What is the difference between the commands test -e path and test -f path?

  A. They are equivalent options with the same behaviour.

  B. The -f option tests for a regular file. The -e option tests for an empty file.

  C. Both options check the existence of the path. The -f option also confirms that it is a regular file.

  D. The -f option tests for a regular file. The -e option tests for an executable file.

  Correct Answer: C

• Question 174:

  Which command allows you to make a shell variable visible to subshells?

  A. export $VARIABLE

  B. export VARIABLE

  C. set $VARIABLE

  D. set VARIABLE

  E. env VARIABLE

  Correct Answer: B

• Question 175:

  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;

  Correct Answer: B

• Question 176:

  You are looking into a new script you received from your senior administrator. In the very first line you notice a #! followed by a file path. This indicates that:

  A. The file at that location was used to make the script.

  B. This script provides identical functionality as the file at that location.

  C. This script will self-extract into a file at that location.

  D. The program at that location will be used to process the script.

  Correct Answer: D

• Question 177:

  How can the existing environment variable FOOBAR be suppressed for the execution of the script./myscript only?

  A. unset -v FOOBAR;./myscript

  B. set -a FOOBAR="";./myscript

  C. env -u FOOBAR./myscript

  D. env -i FOOBAR./myscript

  Correct Answer: C

• Question 178:

  What output will the following command produce?

  seq 1 5 20

  A. 1 5 10 15

  B. 1 6 11 16

  C. 1 2 3 4

  D. 2 3 4 5

  E. 5 10 15 20

  Correct Answer: B

• Question 179:

  Which of the following are requirements in order to run a shell script like a regular command from anywhere in the filesystem? (Choose THREE correct answers.)

  A. The user issuing the command must be in the group script.

  B. The script file must be found in the $PATH.

  C. The script file must have the executable permission bit set.

  D. The script must begin with a shebang-line (#!) that points to the correct interpreter.

  E. The file system on which the script resides must be mounted with the option scripts.

  Correct Answer: BCD

• Question 180:

  Which of the following is the best way to list all defined shell variables?

  A. env

  B. set

  C. env -a

  D. echo $ENV

  Correct Answer: B