|
Related Questions |
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
|
|
How to copy sql table.
|
View Answer
|
|
Difference between Store Procedure and Trigger
|
View Answer
|
|
Cursor Syntax brief history
|
View Answer
|
|
Explain normalization with examples.
|
View Answer
|
|
How to find out the database name from SQL*PLUS command prompt?
|
View Answer
|
|
How can we backup the sql files & what is SAP?
|
View Answer
|
|
Whats the back end processes when we type "Select * from Table"?
|
- SQL Interview Questions & Answers">
View Answer
|
|
What is the difference between SQL and SQL Server?
|
View Answer
|
|
What is table space
|
View Answer
|
|
What is diffrence between Co-related sub query and nested sub query??
|
View Answer
|
|
There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'.
While inserting the data into the table M was misspelled as F and F as M.
What is the update statement to replace F with M and M with F?
|
View Answer
|
|
When we give SELECT * FROM EMP; How does oracle respond:
|
View Answer
|
|
What is reference cursor ?
|
View Answer
|