ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
hai,

when to use char and varchar2....?


















































 Question Submitted By :: B.neelu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: hai, when to use char and varchar2....?
Answer
# 1
char-  should be use when you know that the number of 
characters in the coloumn field is constant .ex if the 
gender is coloumn with char(1)- so only M and F are the two 
options so char(1) is better to use than varchar2.
varchar2- first of all varchar2 is a oracle standard.
varchar2 is nothing but variable characters.
ex- if you have defined the column with varchar2(50) and 
when u r inserting the record into that column with only 10 
letter/characters then only 10 bits will be used instead of 
50.
but if u declare char(50) full 50 bits is allocated for 
that column. so even if u enter on 20 characters the space 
utilized will be full 50 bits.
 
Is This Answer Correct ?    8 Yes 0 No
Gangaram
 
  Re: hai, when to use char and varchar2....?
Answer
# 2
char and varchar2 both we will use for character purpouse
only.but char take how many bytes we r specified in data
type size it will take that much of size.
eg: x char(10);
x:='nani' the remaining 6 character space will b wasted.
but in varchar2 we can use that 6 bytes for another
character also.
i hope so u under stood very well.
 
Is This Answer Correct ?    2 Yes 0 No
Kranthi
 
 
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
What is a cluster?  1
what is index?  3
which language is used to develop the oracle........?  3
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it. IBM2
What is Public Database Link ?  1
What is Index Cluster ?  1
When does a Transaction end ?  2
What is a heap related to database ? TCS1
what are the things that you consider while creating indexes on partitioning tables?  1
What is the difference between implicit index and explicit index? TCS1
Describe Referential Integrity ?  1
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap? Infosys1
how to insert data into partitioned table partition done by Range partition  1
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me? Philips1
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]  2
Who i will insert 1 lacks record in a Database table TCS2
HOW CAN RETURN MAX DATE ROW A B C D E 1 2 1-Mar-09 5 10 1 2 10-Mar-09 5 10 ONLY USING ORACLE PREDEFINED FUNCTION. NOT USER DEFINED. OUTPUT:-- A B C D E 1 2 10-Mar-09 5 10  1
What is a Data Dictionary ?  4
Explain the relationship among Database, Tablespace and Data file?  1
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table  4
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com