Comptia Linux + 2023 Questions and answer - Part 9

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

A) A. unset -v FOOBAR;./myscript
B) B. set -a FOOBAR='';./myscript
C) C. env -u FOOBAR./myscript
D) D. env -i FOOBAR./myscript



2. What output will the following command produce?seq 1 5 20

A) A. 1
B) B. 1
C) C. 1
D) D. 2
E) E. 5


3. 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) A. CASE
B) B. FROM
C) C. WHERE
D) D. IF



4. Which of the following commands lists all defined variables and functions within Bash?

A) A. env
B) B. set
C) C. env -a
D) D. echo $ENV



5. Which of the following SQL queries counts the number of occurrences for each value of the field order_type in the table orders?

A) A. SELECT order_type,COUNT(*) FROM orders WHERE order_type=order_type;
B) B. SELECT order_type,COUNT(*) FROM orders GROUP BY order_type;
C) C. COUNT(SELECT order_type FROM orders);
D) D. SELECT COUNT(*) FROM orders ORDER BY order_type;
E) E. SELECT AUTO_COUNT FROM orders COUNT order_type;