Without Book Interview Questions and Answers | Online Test | Moct Test
Download Android App in your Android Device from Google Play Store
- Search for "Withoutbook Practice Exam Test" in Mobile/Tablet Play Store
Institute Training Search by Name or Email

Exams Attended

Make Homepage

Bookmark this page

Subscribe Email Address

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:

©2016 WithoutBook