|
Question |
Rating |
View Answer |
|
TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ
|
|
View Answer |
|
What is the command used to fetch first 5 characters of the string? |
|
View Answer |
|
Write a Query to find unique names of authors who have written books. (Using Pubs database)? |
|
View Answer |
|
Difference between decode and case. in which case we are using case and in which case we are using decode? with an example.
|
|
View Answer |
|
Which function is used to find the largest integer less than or equal to a specific value? |
|
View Answer |
|
Does SQL SERVER Supports "Finally" block? |
|
View Answer |
|
When using a count(disitnct) is it better to use a self-join or temp table to find redundant data, and provide an example?
|
|
View Answer |
|
What are different types of Collation Sensitivity, in case of SQL? |
|
View Answer |
|
What is the main difference between the IN and EXISTS clause in subqueries??
|
|
View Answer |
|
What will be the output of the following query? SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL; |
|
View Answer |
|
What command is used to get back the privileges offered by the GRANT command? |
|
View Answer |
|
State true or false. !=, <>, ^= all denote the same operation. |
|
View Answer |
|
What are SQL Server 2000 and 2010? |
|
View Answer |
|
How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY? |
|
View Answer |
|
Explain about SQL? |
|
View Answer |
|
What operator performs pattern matching? |
|
View Answer |
|
What is output of following query Select 2 from employee; |
|
View Answer |
|
If Delete Any Table In Back-End Then What Are The Triggers will Fire Automatically (Those Triggers Are Back-End Triggers Only)
|
|
View Answer |
|
Why do I get "Invalid Cursor State" errors when I insert/update/delete data with executeQuery()?
|
|
View Answer |
|
What is an Execution Plan in SQL? When would you use it? |
|
View Answer |