Lpi 102-500 LPI Level 1 Online Training
Lpi 102-500 Online Training
The questions for 102-500 were last updated at Nov 22,2024.
- Exam Code: 102-500
- Exam Name: LPI Level 1
- Certification Provider: Lpi
- Latest update: Nov 22,2024
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
Which of the following commands puts the output of the command date into the shell variable mydate?
- A . mydate="$(date)"
- B . mydate="exec date"
- C . mydate="$((date))"
- D . mydate="date"
- E . mydate="${date}"
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.
What keyword is missing from this code sample of a shell script?
____ i in *.txt; do
echo $i
done
- A . for
- B . loop
- C . until
- D . while
Which of the following SQL statements will select the fields name and address from the contacts table?
- A . SELECT (name, address) FROM contacts;
- B . SELECT (name address) FROM contacts;
- C . SELECT name, address FROM contacts;
- D . SELECT name address FROM contacts;
CORRECT TEXT – (Topic 1)
What command displays all aliases defined in the current shell? (Specify the command without any path information)
What output will the following command sequence produce?
echo ‘1 2 3 4 5 6’ | while read a b c; do
echo result: $c $b $a;
done
- A . result: 3 4 5 6 2 1
- B . result: 1 2 3 4 5 6
- C . result: 6 5 4
- D . result: 6 5 4 3 2 1
- E . result: 3 2 1
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 TEXT – (Topic 1)
What word is missing from the following SQL statement?
__________ count(*) from tablename;
(Please specify the missing word using lower-case letters only.)
What benefit does an alias in bash provide?
- A . It provides faster lookups for commands in the system directory.
- B . It creates a local copy of a file from another directory.
- C . It hides what command you are running from others.
- D . It allows a string to be substituted for the first word of a simple command.
Latest 102-500 Dumps Valid Version with 194 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
