102-500 exam

CORRECT TEXT - (Topic 1) What command displays all aliases defined in the current shell? (Specify the command without any path information)View AnswerAnswer: alias, alias -p

How can the existing environment variable FOOBAR be suppressed for the execution of the script./myscript only?A . unset -v FOOBAR;./myscriptB . set -a FOOBAR="";./myscriptC . env -u FOOBAD . /myscriptE . env -i FOOBAF . /myscriptView AnswerAnswer: C

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.)View AnswerAnswer: select

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}"View AnswerAnswer: A

CORRECT TEXT - (Topic 1) What word is missing from the following SQL statement? insert into tablename ________(909, 'text'); (Please specify the missing word using lower-case letters only.)View AnswerAnswer: VALUES, values

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...

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; doneA . result: 3 4 5 6 2 1B . result: 1 2 3 4 5 6C . result: 6 5 4D ....

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...

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 . CASEB . FROMC . WHERED . IFView AnswerAnswer: C

A French user has installed the French language pack, but currencies are still being displayed with a leading '$' sign in his spreadsheets. What must be done to fix this?A . Alter the locale.B . Set the timezone correctly.C . Edit /etc/currency.D . Reinstall the French language pack.View AnswerAnswer: A