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. |