FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL SERVER INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
56. Tell me the rules of VIEWS.
 
  • Modifications can affect only one table at a time
  • Modifications must satisfy all constraints of the underlying table
  • If a view doesn»t provide all columns without default values, we can»t insert into the view.
  • Calculated columns, and views that use GROUP BY operations, cannot be modified
Your Name Your Email-ID
Your Answer
 
57. Define Synonyms.
  A Synonyms allows you to create alternative names for objects inside of the database. If an object is renamed, or the schema of an object is changed, a synonym can allow existing applications to continue to use the old names.
Synonyms can also reference objects in different databases, or even different servers, by using three-part or four-part object names. A Synonyms must reference a database object, and not another synonym. Multiple names can be created for a single database object, so long as they all refer directly to the database object.
While Synonyms provide alternative names, permissions are still maintained at the database object level. A user can be granted access to a Synonyms, but unless the required access to the underlying object is available, statements using that synonym will fail.
Your Name Your Email-ID
Your Answer
 
58. Why Use Synonyms?
 
  • Objects are renamed.
  • Objects are moved to a different schema.
  • Objects are moved to a separate database.
  • Objects are moved to a different server.
  • Alternative names for a database object are needed.
Your Name Your Email-ID
Your Answer
 
59. Explain DEFAULT.
  A default definition provides a default value for a column. If an INSERT statement doesn’t define a value for the column, the default value is used. If a column allows NULL values, but doesn’t have a default defined, the default value for that column is NULL.
Your Name Your Email-ID
Your Answer
 
60. Tell me the operations that are not allowed in a stored procedure.
  Creating or altering any of the following objects:
  • Aggregate
  • Default
  • Function
  • Procedure
  • Rule
  • Schema
  • Trigger
  • View
  • The USE statement
  • SET PARSEONLY or SHOWPLAN variants
Your Name Your Email-ID
Your Answer