What is the use of data types? Name four basic data types and state their use.
What will be an ideal response?
The data type specifies the type of value that can be entered into a column.
The four basic data types and their uses are as follows:
CHAR – The CHAR type is used for the fixed length character values. The default/minimum size
is 1 (if not specified) and the maximum size is 2000.
For example, state code, zip code etc.
VARCHAR2 – The VARCHAR2 type is used for the variable length character values. The
default size is 1 and the maximum allowable size is 4000. For example, last name, street address
etc.
NUMBER – The NUMBER type is for any numeric value – integer, fixed-decimal and floating-
decimal point values.
DATE – The DATE type stores date and time values. The default formats for the date and time
are DD-MON-YY and HH:MM:SS A.M. respectively. If time is not entered, it defaults to the
midnight. If date is not entered, it defaults to the first of the current month.
You might also like to view...
Which of the following statements about a JLabel is false?
a. Applications rarely change a label’s contents after creating it. b. A JLabel can display text and an image. c. A JLabel can display text and a button. d. A JLabel is a subclass of JComponent.
The output of this Java program will be:
Consider the class below: ``` public class Test { public static void main(String[] args) { int[] a = {99, 22, 11, 3, 11, 55, 44, 88, 2, -3}; int result = 0; for (int i = 0; i < a.length; i++) { if (a[i] > 30) { result += a[i]; } } System.out.printf("Result is: %d%n", result); } } ``` a. Result is: 280. b. Result is: 286. c. Result is: 154. d. Result is: 332.
A database opened in ________ allows only one user at a time the ability to open and edit the database
Fill in the blank(s) with correct word
A Windows Server 2008 server can be configured in the role of a DHCP server using Microsoft ____ services.
A. System B. boot C. Configuration D. DHCP