SQL INTERVIEW QUESTION & ANSWERS
| 106. |
What are three SQL keywords used to change or set someone’s permissions? |
| |
There are three SQL keywords used to change or set someone permissions are : - GRANT
- DENY
- REVOKE
|
| 107. |
Define the concept of "database schema"? Describe the types of schemas? |
| |
Database schema is nothing but description of the database.- External schema
- Conceptual schema
- Internal schema
|
| 108. |
Can SQL be embedded into Internet programming languages? |
| |
Yes. SQL can be embedded in Internet programming languages, such as Java. |
| 109. |
What is the data provider name to connect to Access database? |
| |
Microsoft.Access |
| 110. |
How do SQL databases and XML documents vary in terms of data structure? |
| |
XML defines sequence and a hierarchical tree structure, while SQL does not. |
