SQL Interview Questions and Answers
Ques 1. What is SQL?
Ans. SQL-Structured Query Language is a language consisting of commands to store, retrieve, maintain & regulate access to your database.
Is it helpful?
Add Comment
View Comments
Ques 2. SQL*Plus
Ans. SQL*Plus is an application that recognizes & executes SQL commands & specialized SQL*Plus commands that can customize reports, provide help & edit facility & maintain system variables.
Is it helpful?
Add Comment
View Comments
Ques 3. NVL
Ans. NVL : Null value function converts a null value to a non-null value for the purpose of evaluating an expression. Numeric Functions accept numeric I/P & return numeric values. They are MOD, SQRT, ROUND, TRUNC & POWER.
Is it helpful?
Add Comment
View Comments
Ques 4. Date Functions
Ans. Date Functions are ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN & SYSDATE.
Is it helpful?
Add Comment
View Comments
Ques 5. Character Functions
Ans. 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.
Is it helpful?
Add Comment
View Comments
Most helpful rated by users: