Authentic LPI Certification Exam 102-500 Questions Answers

The /etc/skel directory contains files and directories that are used as a template for creating a new user’s home directory. The useradd command uses the -m (or --create-home) option to create the user home directory as /home/username and copy the files from /etc/skel to it. The files in /etc/skel are typically initialization files such as .bashrc, .profile, and .bash_logout that set the user’s environment variables, aliases, and other preferences. The system administrator can customize the /etc/skel directory to provide a consistent and convenient initial setup for new users. References: 

https://www.howtouselinux.com/post/create-new-user-with-home-directory-in-linux

https://linuxize.com/post/how-to-create-users-in-linux-using-the-useradd-command/

In order to run a shell script like a regular command from anywhere in the filesystem, the following requirements must be met:

The script file must be found in the $PATH. The $PATH is a variable that contains a list of directories where the shell looks for executable files when a command is issued. If the script file is not in one of these directories, the shell will not be able to find it unless the full path is specified.

The script file must have the executable permission bit set. This is a file attribute that determines whether the file can be executed by the user, the group, or others. The executable permission bit can be set using the chmod command, for example: chmod +x script.sh.

The script must begin with a shebang-line (#!) that points to the correct interpreter. This is a special line at the beginning of the script that tells the shell which program to use to run the script, such as #!/bin/bash for bash scripts, or #!/usr/bin/perl for perl scripts. The shebang-line must match the exact path of the interpreter, otherwise the script will not run.

The other options are not requirements for running a shell script like a regular command. There is no such group as script, and the file system mount option scripts does not exist. References:

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

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

The correct keyword for restricting the records that are returned from a SELECT query based on a supplied criteria for the values in the records is WHERE. The WHERE clause is used to filter records based on one or more conditions. The syntax of the WHERE clause is:

SELECT column1, column2, … FROM table_name WHERE condition;

The condition can be a logical expression that evaluates to true, false, or unknown. The condition can also use comparison operators, logical operators, and wildcards to specify the criteria. For example, the following query selects all the records from the employees table where the salary is greater than 50000:

SELECT * FROM employees WHERE salary > 50000;

The other options are incorrect because they have different purposes in SQL:

LIMIT is used to specify the maximum number of records to return from a query. For example, the following query returns only the first 10 records from the employees table:

SELECT * FROM employees LIMIT 10;

FROM is used to specify the table or tables from which to retrieve data. For example, the following query selects all the columns from the employees table:

SELECT * FROM employees;

IF is used to execute a block of code conditionally. For example, the following query updates the salary of an employee based on their performance:

UPDATE employees SET salary = IF(performance = ‘excellent’, salary * 1.1, salary) WHERE employee_id = 123; References: 

https://bing.com/search?q=SQL+statements+restrict+records+based+on+criteria

https://stackoverflow.com/questions/11611931/sql-query-to-select-records-based-on-criteria