|
INTERVIEW QUESTIONS
DATABASE
SQL
DETAILS
Question: What are Character Functions?
Answer: Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM.
|
|
|
Category |
SQL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8070 users |
Added on |
9/14/2014 |
Views |
65889 |
Rate it! |
|
|
Question:
What are Character Functions?
Answer:
Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM. 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 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
|
|
What is outer join?Explain with examples.
|
View Answer
|
|
What is DML,DDL?
|
View Answer
|
|
How we get second highest salary in database. Please show me this coding.
|
View Answer
|
|
How to analyze the performance of a query using Explain Plan? Can any one explain me this in detail... if you can provide me with a link where I can get full information on it I would appreciate it...?
|
View Answer
|
|
Explain the concept of joins and list out the different type of joins?
|
View Answer
|
|
What is the difference between varchar & varchar2?
|
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
|