Which of the following words is used to restrict the records that are returned from a SELECT query based on a supplied criteria for the values in the records?
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;Reference:
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
Which command allows you to make a shell variable visible to subshells?
The command that allows you to make a shell variable visible to subshells isexport 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. Thesetcommand can be used to assign values to variables, but it does not export them. Theenvcommand can be used to run a command in a modified environment, but it does not change the environment of the current shell.Reference:
[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]
What is the conventional purpose of Linux UIDs that are lower than 100?
Linux UIDs (user identifiers) are numbers that are used to identify users and groups on a Linux system. Each user and group has a unique UID and GID (group identifier) respectively. The UID 0 is always reserved for the root or superuser account, which has full privileges to access and modify the system. The UIDs lower than 100 (or 1000 on some modern systems) are typically reserved for system accounts, which are used by various services and daemons that run on the system. These accounts are not meant for human users, but for specific purposes such as managing files, processes, network, security, etc. For example, some common system accounts are bin, daemon, mail, sshd, etc. The UIDs higher than 100 (or 1000) are usually allocated for regular user accounts, which have limited privileges and can be created and deleted by the system administrator.The system accounts are defined in the /etc/passwd file, which contains the username, UID, GID, home directory, shell, and other information for each account12345.Reference:1: Linux User Management - Tecmint2: What are the well-known UIDs?- Stack Overflow3: user ID less than 1000 on CentOS 7 - Unix & Linux Stack Exchange4: Recommended GID for users group in Linux (100 or 1000)?- Unix & Linux Stack Exchange5: What is the conventional purpose of Linux UIDs that are lower than 100? - VCE Guide
Which port is the default server port for the HTTPS protocol? (Specify the port number using digits.)
The port number 443 is the default server port for the HTTPS protocol, which is a secure version of HTTP that uses SSL/TLS certificates to encrypt the data transmission between web servers and browsers.The port number 443 is recognized by the Internet Engineering Task Force (IETF) as the standard port for HTTPS connections1.The port number 443 is part of the topic 109.1: Fundamentals of internet protocols, which is one of the objectives of the LPI Linux Administrator - 102 exam23.Reference:1:HTTPS Port: What It Is, How to Use It, and More (2023) - Hostinger2:LPI Linux Administrator - 102 (LPIC-1)3:Exam 102 Objectives
To prevent a specific user from scheduling tasks with at, what should the administrator do?
The /etc/at.deny file is a file that contains a list of users who are not allowed to use the at command to schedule jobs. If the file exists, any user who is not in the /etc/at.allow file and is in the /etc/at.deny file will be denied access to the at command. To prevent a specific user from scheduling tasks with at, the administrator can simply add the user's name to the /etc/at.deny file. For example, to prevent the user bob from using the at command, the administrator can use the following command:
echo ''bob'' | sudo tee -a /etc/at.deny
The other options are not correct. The /etc/at.allow file is a file that contains a list of users who are allowed to use the at command. Adding a user to this file will not prevent them from scheduling tasks with at. The /etc/atd.conf file is a configuration file for the at daemon, which does not have a [deny] section. Adding a user to this file will not affect their access to the at command. The nojobs group is not a predefined group in Linux, and adding a user to this group will not prevent them from scheduling tasks with at. The atd command does not have a --deny option, and running this command will not prevent a user from scheduling tasks with at.Reference:
at Command in Linux with Examples - GeeksforGeeks
How to Use the Linux at Command {9 Examples} - phoenixNAP
at(1) - Linux man page
Ronald Lee
2 months agoGeorge Lewis
2 months agoJason Morris
3 months agoDonald Jackson
3 months agoDennis King
4 months agoThomas Evans
4 months agoDonna Martin
5 months agoBetty Edwards
6 months agoDeborah Flores
6 months agoAmanda Morgan
6 months agoEmma Bailey
7 months agoMichael Nelson
6 months agoJohn Collins
6 months agoMark Williams
6 months agoRichard Rodriguez
6 months agoGeorge Brown
7 months agoRaina
7 months agoKaran
8 months agoVi
8 months agoLenita
8 months agoJesus
8 months agoGretchen
9 months agoOra
9 months agoDaniel
9 months agoCasie
9 months agoBernardo
10 months agoTruman
10 months agoLizette
10 months agoCary
10 months agoAdelina
11 months agoBrandee
11 months agoJustine
11 months agoAudria
11 months agoKeva
12 months agoDominga
12 months agoOnita
1 year agoChantay
1 year agoMargart
1 year agoJuan
1 year agoHerman
1 year agoHubert
1 year agoMabel
1 year agoKami
1 year agoElinore
1 year agoMattie
1 year agoMarleen
1 year agoVilma
1 year agoAltha
1 year agoJusta
1 year agoKerry
2 years agoLevi
2 years agoLonny
2 years agoMargurite
2 years agoSkye
2 years agoBurma
2 years agoFreeman
2 years agoRebecka
2 years agoErinn
2 years agoJennie
2 years agoRonald
2 years agoCharlena
2 years agoErick
2 years agoCheryl
2 years agoKizzy
2 years agoValentine
2 years agoMalcom
2 years agoDelsie
2 years agoNada
2 years agoJanna
2 years agoDenae
2 years agoMagdalene
2 years agoArthur
2 years agoDeja
2 years agoLorean
2 years agoAmos
2 years agoJonelle
2 years agoWilda
2 years agoAmos
2 years agoTemeka
2 years agoSabra
2 years agoTamekia
2 years agoAnika
2 years agoNatalie
2 years ago