102-500 exam

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

CORRECT TEXT - (Topic 3) Which environment variable should be set in order to change the time zone for the commands run from within the environment variable's scope? (Specify the variable name only.)View AnswerAnswer: TZ

Which of the following configuration files should be modified to set default shell variables for all users?A . /etc/bashrcB . /etc/profileC . ~/.bash_profileD . /etc/.bashrcView AnswerAnswer: B

Which of the following lines is an example of a correct setting for the DISPLAY environment variable?A . hostname:displaynameB . hostname:displaynumberC . hostname/displaynameD . hostname/displaynumberE . hostnameView AnswerAnswer: B

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;View AnswerAnswer: C