Multiple choice technology

Which statements are true regarding the data types in Oracle Database 10g/11g?

  1. Only one LONG column can be used per table.

  2. A TIMESTAMP data type column stores only time values with fractional seconds

  3. The BLOB data type column is used to store binary data in an operating system file.

  4. The minimum column width that can be specified for a VARCHAR2 data type column is one.

  5. The value for a CHAR data type column is blank-padded to the maximum defined column width.

  6. All the above
Reveal answer Fill a bubble to check yourself
A,D,E Correct answer
Explanation

Oracle allows only one LONG column per table due to legacy design limitations (option A). VARCHAR2 minimum width is 1 character (option D) - you cannot create a VARCHAR2(0) column. CHAR values are blank-padded to the full defined width (option E) - this is a key difference from VARCHAR2. Option B is false: TIMESTAMP stores both date and time. Option C is false: BLOB stores binary data within the database, not in OS files (that would be BFILE).

AI explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Only one LONG column can be used per table - This option is incorrect. In Oracle Database 10g/11g, multiple LONG columns can be used per table.

Option B) A TIMESTAMP data type column stores only time values with fractional seconds - This option is incorrect. A TIMESTAMP data type column stores both date and time values, including fractional seconds.

Option C) The BLOB data type column is used to store binary data in an operating system file - This option is incorrect. The BLOB data type column is used to store large binary objects directly in the database.

Option D) The minimum column width that can be specified for a VARCHAR2 data type column is one - This option is correct. The minimum column width that can be specified for a VARCHAR2 data type column in Oracle Database 10g/11g is one.

Option E) The value for a CHAR data type column is blank-padded to the maximum defined column width - This option is correct. The value for a CHAR data type column in Oracle Database 10g/11g is always blank-padded to the maximum defined column width.

Based on the explanations above, the correct answer is A, D, E.

Keep practicing — related questions