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