|
Question |
Rating |
View Answer |
|
if a table consists of a column names, which is having 12 names, in these 8 are unique and 2 are repeated twice. write query for getting the unique values means 8 names. |
|
View Answer |
|
Explain open SQL vs native SQL? |
|
View Answer |
|
Difference - Primary Key and Aggregate Key
|
|
View Answer |
|
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
|
|
View Answer |
|
What is merging?
|
|
View Answer |
|
What is the difference between Inner join and full outer join in terms of the Number of rows returned?
|
|
View Answer |
|
Name of the class of sql
|
|
View Answer |
|
What cursor type do you use to retrieve multiple record sets?
|
|
View Answer |
|
Difference between a "where" clause and a "having" clause
|
|
View Answer |
|
What is the difference between "procedure" and "function"?
|
|
View Answer |
|
How will you copy the structure of a table without copying the data?
|
|
View Answer |
|
Give some examples of Analytical functions.
|
|
View Answer |
|
What is the difference between "translate" and "replace"?
|
|
View Answer |
|
What is DYNAMIC SQL method 4?
|
|
View Answer |
|
How to remove duplicate records from a table?
|
|
View Answer |
|
What is the use of Analyzing the tables?
|
|
View Answer |
|
How to run SQL script from a Unix Shell?
|
|
View Answer |
|
What is a "transaction"? Why are they necessary?
|
|
View Answer |
|
Explain Normalization and Denormalization with examples.
|
|
View Answer |
|
When do you get constraint violation? What are the types of constraints?
|
|
View Answer |