Multiple choice technology databases

Which of the following are used to define a CHAR datatype variable?

  1. INSERT

  2. PROMPT

  3. ACCEPT

  4. DEFINE

Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

In SQL*Plus, DEFINE creates a user-defined char variable, and ACCEPT prompts the user for input and assigns it to a variable, defaulting to CHAR. INSERT is a DML statement, and PROMPT simply prints text to the screen.