SQL Interview Questions

« Technical Interview & Viva Questions : KyaPoocha.com home page
« Next Entries


Pages (999999): [1] 2 3 » ... Last »

When you COMMIT, is the cursor closed ?

View the Answer

Can you have more than one cursor open at any one time in a program ?

View the Answer

Is DECLARE CURSOR executable ?

View the Answer

What happens when you say OPEN CURSOR ?

View the Answer

What is a join ?

View the Answer

What is an index key ?

View the Answer

When do you use a LIKE statement ?

View the Answer

What is ‘LIKE’ used for in WHERE clause? What are the wildcard characters ?

View the Answer

Is BETWEEN inclusive of the range values specified ?

View the Answer

In the WHERE clause what is BETWEEN and IN ?

View the Answer

What is the restriction on using UNION in embedded SQL ?

View the Answer

How do you retrieve the first 5 characters of FIRSTNAME column of EMP table ?

View the Answer

My SQL statement SELECT AVG(SALARY) FROM EMP-TABLE yields inaccurate results. Why ?

View the Answer

Can you use MAX on a CHAR column ?

View the Answer

How do you find the maximum value in a column ?

View the Answer

Pages (999999): [1] 2 3 » ... Last »