My Profile
Active Members
TodayLast 7 Days
more...
Awards & Gifts
Online Exams
Fresher Jobs
Our fresher job section is exclusively for fresh graduates! Find jobs for freshers in major Indian
cities including Bangalore, Chennai, Hyderabad, Pune or Kochi
Resources
Find educational articles, blogs, discussion threads and other resources.
Colleges
Find details about any college in India or search for courses.
Advertisements
|
SQL Interview Questions with Answers - Set 3
Posted Date: 06 Feb 2008 Resource Type: Articles/Knowledge Sharing Category: General
|
Posted By: Bala Member Level: Diamond
Rating:  Points: 3
|
|
|
SQL Interview Questions with Answers - Set 3
1. Which command executes the contents of a specified file?
START or @.
2. What is the value of comm and sal after executing the following query if the initial value of ‘sal’ is 10000
UPDATE EMP SET SAL = SAL + 1000, COMM = SAL*0.1;?
sal = 11000, comm = 1000.
3. Which command displays the SQL command in the SQL buffer, and then executes it?
RUN.
4. What command is used to get back the privileges offered by the GRANT command?
REVOKE.
5. What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );? NO.
Explanation : The query checks whether a given string is a numerical digit.
6. Which date function is used to find the difference between two dates?
MONTHS_BETWEEN
7. What operator performs pattern matching?
LIKE operator.
8. What is the use of the DROP option in the ALTER TABLE command?
It is used to drop constraints specified on the table.
9. What operator tests column for the absence of data?
IS NULL operator.
10. What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all.
|
Responses
|
No responses found. Be the first to respond and make money from revenue sharing program.
|
|
|