SQL Basics

To access and modify information in the database

Structured Query Language

VARCHAR2 can hold up to 4000 bytes, while VARCHAR can hold only 2000 bytes

<p>1 to 38</p> Signup and view all the answers

<p>To store date and time values</p> Signup and view all the answers

<p>The CHAR data type holds fixed length character data up to a specified width.</p> Signup and view all the answers

<p>The VARCHAR data type holds only 2000 bytes of data and occupies space for NULL characters, while VARCHAR2 does not occupy any space for NULL characters.</p> Signup and view all the answers

<p>A VARCHAR2 value can contain up to 4000 bytes of data.</p> Signup and view all the answers

<p>The precision is 5, which represents the total number of places, and the scale is 2, which represents the number of places to the right of the decimal point.</p> Signup and view all the answers

<p>The RAW data type is used to store binary data of variable length up to a specified size.</p> Signup and view all the answers