|
Question |
Rating |
View Answer |
|
What is a "transaction"? Why are they necessary?
|
|
View Answer |
|
How to find out duplicate records in sql server.
|
|
View Answer |
|
How functional dependency is related to database table design?
|
|
View Answer |
|
Difference between a "where" clause and a "having" clause
|
|
View Answer |
|
What is merging?
|
|
View Answer |
|
Difference between "VARCHAR" and "VARCHAR2" datatypes.
|
|
View Answer |
|
What is the difference between "translate" and "replace"?
|
|
View Answer |
|
What is a VIEW? How to get script for a view?
|
|
View Answer |
|
What is SQL*Loader? Difference between
|
|
View Answer |
|
Explain open SQL vs native SQL? |
|
View Answer |
|
What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.
|
|
View Answer |
|
What's the use of SQL Profiler?
|
|
View Answer |
|
What are "HINTS"? What is "index covering" of a query?
|
|
View Answer |
|
How to create a database link?
|
|
View Answer |
|
What cursor type do you use to retrieve multiple record sets?
|
|
View Answer |
|
What is the difference between Inner join and full outer join in terms of the Number of rows returned?
|
|
View Answer |
|
How will you copy the structure of a table without copying the data?
|
|
View Answer |
|
Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
|
|
View Answer |
|
How to run SQL script from a Unix Shell?
|
|
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 |