SQL INTERVIEW QUESTION & ANSWERS
96. |
What are some of the reasons differences in SQL exist? |
|
Differences exist in SQL among the vendors because of storage requirements, advantages over competitors, ease of use, and performance considerations. |
97. |
What statement must you include in your CREATE TRIGGER statement if the trigger
definition includes more than one triggered SQL statement? |
|
BEGIN...END statement |
98. |
Describe the three levels of data abstraction? |
|
The are three levels of abstraction :
- Physical level : The lowest level of abstraction describes how data are stored.
- Logical level : The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
- View level : The highest level of abstraction describes only part of entire database.
|
99. |
What type of view does the WITH CHECK OPTION clause apply to? |
|
The WITH CHECK OPTION clause applies to updatable views that include a WHERE clause in the SELECT statement. |
100. |
What is XML? |
|
XML is a general-purpose markup language used to describe documents. |