SQL INTERVIEW QUESTION & ANSWERS
36. |
What is the purpose of the DISTINCT option? |
|
The DISTINCT option will suppress the display of duplicates. |
37. |
What does the precompiler do with the program file? |
|
The precompiler strips the SQL statements out of the host language code and replaces them with calls to the SQL statements. |
38. |
What is a query specification? |
|
A query specification is an SQL expression that begins with the SELECT keyword and includes a number of elements that form that expression. |
39. |
What are the three primary types of relationships supported by a relational database? |
|
There are three primary types of relationships are :
- One–to–one
- one–to–many
- many–to–many
|
40. |
Define Entity type, Entity set? |
|
An entity type defines a collection of entities that have same attribute
Entity Set. Entity set is the collection of a particular entity type that are grouped into
an Entity Set. |