Multiple choice technology

Which of the below is an option of nzsql command to display only records

  1. -r

  2. -t

  3. -c

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The nzsql -t option displays only the data rows (tuples) without column headers or other formatting elements. This is useful for extracting pure data for scripting or further processing. The -r option is for row output mode, -c is for running a single command.

AI explanation

To answer this question, you need to understand the options available for the nzsql command to display only records. Let's go through each option to understand why it is correct or incorrect:

Option A) -r - This option is incorrect because the -r option in nzsql is used to specify the record delimiter, not to display only records.

Option B) -t - This option is correct because the -t option in nzsql is used to display only records. It suppresses the display of column headers and row count.

Option C) -c - This option is incorrect because the -c option in nzsql is used to specify a command string or script file to execute, not to display only records.

Option D) None of the above - This option is incorrect because option B, -t, is indeed an option of nzsql to display only records.

The correct answer is B) -t. This option is correct because it allows nzsql to display only records by suppressing the display of column headers and row count.