What is the command to delete the default gateway from the system IP routing table? (Choose TWO correct answers.)
Correct Answer: C,E
Question 72
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?
Correct Answer: C
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
Question 73
Which configuration file contains the default options for SSH clients?
Correct Answer: B
Question 74
What is the difference between the commands test -e path and test -f path?
Correct Answer: C
The test command is used to perform checks and comparisons on files and values. The -e option tests if a given path exists, regardless of its type (file, directory, link, etc.). The -f option tests if a given path exists and is a regular file, not a directory or a special file. For example, if we have a directory named dir and a file named file, we can use the test command as follows: test -e dir && echo "dir exists" dir exists test -f dir && echo "dir is a regular file" (no output) test -e file && echo "file exists" file exists test -f file && echo "file is a regular file" file is a regular file References: https://www.howtoforge.com/linux-test-command/ https://www.computerhope.com/unix/bash/test.htm
Question 75
Which command is used to set the hostname of the local system? (Specify ONLY the command without any path or parameters.)
Correct Answer:
hostname Explanation: The hostname command is used to set the hostname of the local system. The hostname command can take a single argument, which is the new hostname to be assigned to the system. For example, to set the hostname to linux, one can run: hostname linux The hostname command can also be used without any arguments to display the current hostname of the system. For example, to show the current hostname, one can run: hostname The hostname command only changes the hostname temporarily, meaning that the original hostname will be restored after a reboot. To change the hostname permanently, one has to edit the configuration files that store the hostname information, such as /etc/hostname, /etc/hosts, /etc/sysconfig/network, etc. The exact files and commands may vary depending on the Linux distribution and the system initialization process. For more details, please refer to the web search results1 or the question answering results2. References:
