What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?

What is difference between CHAR and VARCHAR2 ? What
is the maximum SIZE allowed for each type ?
by

1 Answer

Answer :

CHAR pads blank spaces to the maximum length. VARCHAR2 does not
pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.
by

Related questions

What is the Maximum allowed length of Record group Column?

Description : What is the Maximum allowed length of Record group Column?

Last Answer : Record group column names cannot exceed 30 characters.

What are the data types allowed in a table ?

Description : What are the data types allowed in a table ?

Last Answer : CHAR,VARCHAR2,NUMBER,DATE,RAW,LONG and LONG RAW.

How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Description : Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

Last Answer : False

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Description : What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?

Last Answer : 1,000,00

What is the maximum size of a form ?

Description : What is the maximum size of a form ?

Last Answer : 255 character width and 255 characters Length.

Arrange the following primitive data types in an ascending order of their size: (i) char (ii) byte (iii) double (iv) int

Description : Arrange the following primitive data types in an ascending order of their size: (i) char (ii) byte (iii) double (iv) int

Last Answer : Ans. The sizes of the given data types are as follows char = 2 bytes byte = 1 byte double = 8 bytes int = 4 bytes Arranging them in ascending order gives byte < char < int < double

If an integer occupies 4 bytes and a character occupies 1 byte of memory, each element of the following structure would occupy how many bytes ? struct name { int age; char name[30]; }; A) 30 B) 32 C) 34 D) 36

Description : If an integer occupies 4 bytes and a character occupies 1 byte of memory, each element of the following structure would occupy how many bytes ? struct name { int age; char name[30]; }; A) 30 B) 32 C) 34 D) 36

Last Answer : C) 34

What is the difference between haor and char ?

Last Answer : : A haor is a large body of water. Where water accumulates.

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Description : Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

Last Answer : ARCHIVELOG mode is a mode that you can put the database in for creating a backup of all transactions that have occurred in the database so that you can recover to any point in time. ... having to write transactions to an archive log and thus increases the performance of the database slightly.

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Description : Explain the difference between a hot backup and a cold backup and the benefits associated with each.

Last Answer : A hot backup is basically taking a backup of the database while it is still up and running and it must be in archive log mode. A cold backup is taking a backup of the database while it is ... and thus there will be a slight performance gain as the database is not cutting archive logs to disk.

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

Match List-I (Type of Unemployment) with List-II (Characteristics) and select the correct answer using the codes given below: L ist-I L ist -I I (Type of (Char acter ist ics) Unem ployment ) A. Seasonal I. Occurs during boom or recession in the economy B. Frictional II. An absence of demand for a certain type of workers C. Disguised III. Occurs when moving from one job to another D. Structural IV. Actual contribution by the additional labour is nil E. Cyclical V. Job opportunities during certain months in the year

Description : Match List-I (Type of Unemployment) with List-II (Characteristics) and select the correct answer using the codes given below: L ist-I L ist -I I (Type of (Char acter ist ics) Unem ... contribution by the additional labour is nil E. Cyclical V. Job opportunities during certain months in the year

Last Answer : (1) A-V, B-III, C-IV, D-II, E-I

What view would you use to look at the size of a data file?

Description : What view would you use to look at the size of a data file?

Last Answer : DBA_DATA_FILES

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Description : Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size?

Last Answer : Yes

How to define data block size?

Description : How to define data block size?

Last Answer : A data block size is specified for each Oracle database when the database is created. A database users and allocated free database space in Oracle data blocks. Block size is specified in init.ora file and cannot be changed latter.

What database block size should I use? (for DBA)

Description : What database block size should I use? (for DBA)

Last Answer : Oracle recommends that your database block size match, or be multiples of your operating system block size. One can use smaller block sizes, but the performance cost is significant. Your choice should ... 8K. This is because volume manager products use 8K blocks (and this is not configurable).

How to define Data Block size ?

Description : How to define Data Block size ?

Last Answer : A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and can’t be changed latter.

If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Description : If the maximum record retrieved property of the query is set to 10 then a summary value will be calculated?

Last Answer : Only for 10 records.

How many maximum number of radio buttons can you assign to a radio group?

Description : How many maximum number of radio buttons can you assign to a radio group?

Last Answer : Unlimited no of radio buttons can be assigned to a radio group

List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Description : List the Optional Flexible Architecture (OFA) of Oracle database? or How can we organize the tablespaces in Oracle database to have maximum performance ?

Last Answer : SYSTEM - Data dictionary tables. DATA - Standard operational tables. DATA2- Static tables used for standard operations INDEXES - Indexes for Standard operational tables. INDEXES1 - Indexes of ... - Temporary purpose tablespace TEMP_USER - Temporary tablespace for users. USERS - User tablespace.

What is the maximum no of chars the parameter can store?

Description : What is the maximum no of chars the parameter can store?

Last Answer : The maximum no of chars the parameter can store is only valid for char parameters, which can be upto 64K. No parameters default to 23Bytes and Date parameter default to 7Bytes.

How many maximum Redo Logfiles one can have in a Database?

Description : How many maximum Redo Logfiles one can have in a Database?

Last Answer : Maximum number of logfiles is limited by value of MAXLOGFILES parameter in the CREATE DATABASE statement. Control file can be resized to allow more entries; ultimately an operating system limit. ... for the CREATE DATABASE statement, then the database uses an operating system default value.

How many Maximum Datafiles can there be in Oracle Database?

Description : How many Maximum Datafiles can there be in Oracle Database?

Last Answer : Regardless of the setting of this paramter, maximum per database: 65533 (May be less on some operating systems) Maximum number of datafiles per tablespace: OS dependent = usually 1022 Limited also ... instance Bigfile tablespaces can contain only one file, but that file can have up to 4G blocks.

What is difference between % ROWTYPE and TYPE RECORD ?

Description : What is difference between % ROWTYPE and TYPE RECORD ?

Last Answer : % ROWTYPE is to be used whenever query returns a entire row of a table or view. TYPE rec RECORD is to be used whenever query returns columns of different table or views and variables. E.g. ... emp ename %type ); e_rec emp% ROWTYPE cursor c1 is select empno,deptno from emp; e_rec c1 %ROWTYPE.

Who manufactures non-activated carbon char?

Description : Who manufactures non-activated carbon char?

Last Answer : my husband advises: try hickman-williams & co, oak brook, IL, or superior graphite company, chicago, IL, or asbury graphite company, asbury, NJ. these companies produce and market specialty carbon products; or they may know someone who does

Who built Char Minar? -General Knowledge

Description : Who built Char Minar? -General Knowledge

Last Answer : The answer is 'Quli Qutb Shah'

Who built Char Minar? -General Knowledge

Description : Who built Char Minar? -General Knowledge

Last Answer : answer:

Where is Nirmal Char located ?

Last Answer : On the Bangladesh-India border in Rajshahi district ( 3,000 feet long and 200 feet wide).

What is Dublar Char famous for ?

Last Answer : : Famous for fishing , dry production and coastal greenery.

Where is Patni Char located ?

Last Answer : Patni Char is located in the Sundarbans.

Where is Uri Char located ?

Last Answer : Located on Hatia Island in Noakhali.

Where is Haor and Char Development Institute located ?

Last Answer : Haor and Char Development Institute is located at Mithamin , Kishoreganj.

Which is the largest char in Bangladesh ?

Last Answer : The largest char in Bangladesh is Dublar Char

Where is Char Kukri Mukri located ?

Last Answer : Char Kukri Mukri to the south, Bay of Bengal to the north, Shahbazpur system and Char Manika to the east, Dhalchar to the west, Char Montaz.

Where is Muhuri Char located ?

Last Answer : Muhuri Char is located in Feni district.

In which district are Char Manik and Char Jabbar located ?

Last Answer : Char Manik and Char Jabbar are located in Bhola district.

Where is Dublar Char located ?

Last Answer : Dublar Char is located - Noakhali.

Char The hen Spider No In the district Located ?

Last Answer : Char The hen Spider Forget it In the district Located

Photoperiodism was first char acterised in

Description : Photoperiodism was first char acterised in

Last Answer : Photoperiodism was first char acterised in A. Tabacco B. Potato C. Tomato D. Cotton

In researching the structure of DNA Erwin Char gaff found the amount of adenine always equaled the amount of which other base?

Description : In researching the structure of DNA Erwin Char gaff found the amount of adenine always equaled the amount of which other base?

Last Answer : Thymine. Discovered in the late 1940s, this is known as "The Chargaff's Rules": DNA has equal numbers of adenine and thymine residues (A = T) and an equal number of guanine and cytosine (G = ... one of the most important features for Watson and Crick to solve the structure of DNA molecule in 1953.

Char Broil Parts?

Description : Char Broil Parts?

Last Answer : form_title= Char Broil Parts form_header= Enjoy summer barbecues with a char broil parts. What parts do you need to replace?*= _ [50] Are the parts covered under warranty?*= () Yes () No Do you need a new warranty?*= () Yes () No What grill brand and model do you own?*= _ [50]

Char Broil Grill?

Description : Char Broil Grill?

Last Answer : form_title= Char Broil Grill form_header= Grill like a champion with a char broil grill. What is your budget for a grill?*= _ [50] What color would you like the grill?*= _ [50] Do you want to buy grill accessories?*= () Yes () No Do you need an extended warranty? *= () Yes () No

Who sells char-broil BBQ grills?

Description : Who sells char-broil BBQ grills?

Last Answer : The Char-Broil brand has its own website, Charbroil.com, and Amazon.com, NewEgg.com, HomeDepot.com, and Frys.com all offer char-broil barbeque grills.

The measure of the acidic or basic char- acter of a liquid or solution is the?

Description : The measure of the acidic or basic char- acter of a liquid or solution is the?

Last Answer : pH value.

Char value of Kerosene is the amount of charred oil deposition on the wick obtained after burning it in a standard wick lamp at a standard rate for 24 hours. Char value of a good quality kerosene should be less than __________ mg/kg of kerosene. (A) 1 (B) 20 (C) 100 (D) 500

Description : Char value of Kerosene is the amount of charred oil deposition on the wick obtained after burning it in a standard wick lamp at a standard rate for 24 hours. Char value of a good quality kerosene should be less than __________ mg/kg of kerosene. (A) 1 (B) 20 (C) 100 (D) 500

Last Answer : (B) 20

getchar :: IO char in this given function what is indicated by IO char: a. when getchar is invoked it returns a character b. when getchar is executed it returns a character c. botha & b d. none of these

Description : getchar :: IO char in this given function what is indicated by IO char: a. when getchar is invoked it returns a character b. when getchar is executed it returns a character c. botha & b d. none of these

Last Answer : a. when getchar is invoked it returns a character

If we define putchar function in putchar :. char -> IO () syntax than character input as an argument andreturns a. Useful value b. Get output c. Getno output d. None of these

Description : If we define putchar function in putchar :. char -> IO () syntax than character input as an argument andreturns a. Useful value b. Get output c. Getno output d. None of these

Last Answer : c. Getno output

What are the types of casting shown by the following examples: (i) char c = (char)120; (ii) int x = ‘t’;

Description : What are the types of casting shown by the following examples: (i) char c = (char)120; (ii) int x = ‘t’;

Last Answer : Ans. (i) Explicit casting (ii) Implicit casting

Classify the following as primitive or non-primitive data types: (i) char (ii) arrays (iii) int (iv) classes

Description : Classify the following as primitive or non-primitive data types: (i) char (ii) arrays (iii) int (iv) classes

Last Answer : Ans. (i) char – Primitive (ii) arrays – Non primitive (iii) int – Primitive (iv) Classes – Non primitive