|
Question |
Rating |
View Answer |
|
what is the difference between oracle,sql and sql server
|
|
View Answer |
|
on index why u need indexing ? where that is stroed and what u mean by schema object? for what purpose we are using view
|
|
View Answer |
|
I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
|
|
View Answer |
|
Difference between Stored Procedure and Trigger
|
|
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 is the advantage to use trigger in your PL?
|
|
View Answer |
|
What the difference between UNION and UNIONALL?
|
|
View Answer |
|
How to find second maximum value from a table?
|
|
View Answer |
|
How to display duplicate rows in a table?
|
|
View Answer |
|
What is joint?
|
|
View Answer |
|
What is the difference between TRUNCATE and DELETE commands
|
|
View Answer |
|
Which system table contains information on constraints on all the tables created?
|
|
View Answer |
|
Which command displays the SQL command in the SQL buffer, and then executes it |
|
View Answer |
|
What does the following query do
|
|
View Answer |
|
What will be the output of the following query
|
|
View Answer |
|
TRUNCATE TABLE EMP;
DELETE FROM EMP;
Will the outputs of the above two commands differ
|
|
View Answer |
|
What is the difference between Single row sub-Query and Scalar sub-Query
|
|
View Answer |
|
How do I write a cron which will run a SQL query and mail the results to a group?
|
|
View Answer |
|
Is there any query which is used to find the case sensitivity in each records in database through visual basic?
|
|
View Answer |
|
I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.
|
|
View Answer |