|
INTERVIEW QUESTIONS
DATABASE
SQL
DETAILS
Question: What are data types in sql?
Answer: Max. columns in a table is 255. Max. Char size is 255, Long is 64K & Number is 38 digits. Cannot Query on a long column. Char, Varchar2 Max. size is 2000 & default is 1 byte. Number(p,s) p is precision range 1 to 38, s is scale -84 to 127. Long Character data of variable length upto 2GB. Date Range from Jan 4712 BC to Dec 4712 AD. Raw Stores Binary data (Graphics Image & Digitized Sound). Max. is 255 bytes. Mslabel Binary format of an OS label. Used primarily with Trusted Oracle.
|
|
|
Category |
SQL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9435 users |
Added on |
9/14/2014 |
Views |
70064 |
Rate it! |
|
|
Question:
What are data types in sql?
Answer:
Max. columns in a table is 255. Max. Char size is 255, Long is 64K & Number is 38 digits. Cannot Query on a long column. Char, Varchar2 Max. size is 2000 & default is 1 byte. Number(p,s) p is precision range 1 to 38, s is scale -84 to 127. Long Character data of variable length upto 2GB. Date Range from Jan 4712 BC to Dec 4712 AD. Raw Stores Binary data (Graphics Image & Digitized Sound). Max. is 255 bytes. Mslabel Binary format of an OS label. Used primarily with Trusted Oracle. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What are indexes?
|
View Answer
|
|
What is correlated subquery?
|
View Answer
|
|
What is join in sql?
|
View Answer
|
|
What is spool command?
|
View Answer
|
|
What is compute command?
|
View Answer
|
|
What are Character Functions?
|
View Answer
|
|
What are Date Functions?
|
View Answer
|
|
What is NULL value function?
|
View Answer
|
|
What is SQLPlus?
|
View Answer
|
|
What is SQL?
|
View Answer
|
|
What is unique key?
|
View Answer
|
|
Does SQL SERVER Supports "Finally" block?
|
View Answer
|
|
Where the procedures,functions and packages are stored?
|
View Answer
|
|
How many types of Triggers are there?
|
View Answer
|
|
What is the difference between cross product & Cartesian product?
|
View Answer
|
|
What is denormalization and difference between normalization and denormalization?
|
View Answer
|
|
What is the difference between where condition and having condition?
|
View Answer
|
|
What is the default format of date in Oracle? How can I change my default date format?
|
View Answer
|
|
How do I list all of my tables? How do I list all the indexed created for a particular table(say EMP)? How do I SELECT FROM DIFFERENT USERS TABLE?
|
View Answer
|
|
What is sql?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All SQL Interview Questions & Answers - Exam Mode /
Learning Mode
|