SQL INTERVIEW QUESTION & ANSWERS
| 61. |
What two types of authorization identifiers does SQL support? |
| |
User identifiers and role names |
| 62. |
What is the difference between a user identifier and a role name? |
| |
A user identifier is an individual security account that can represent an individual, an application, or a system service.
A role name is a defined set of privileges that can be assigned to a user or to
another role.
|
| 63. |
What are the three types of stored tables supported by SQL? |
| |
- Base tables
- Derived tables
- Viewed tables (views)
|
| 64. |
What is another name for an SQL–invoked procedure? |
| |
Stored procedure |
| 65. |
What is a CAST value expression? |
| |
A CAST value expression is a type of expression that allows you to change a value's data type when retrieving that value from your database. |
