New : »Puzzles Questions
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?|
|64.||What is another name for an SQL–invoked 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.|