FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
126. Can a trigger be altered?
  No, the trigger must be replaced or re–created.
  Posted by Ram. (Jan 26, 2014)
 

It has possible in SQL Server we can alter trigger.
Your Name Your Email-ID
Your Answer
 
127. What is the difference between normalization and denormalization?
 
  • Normalization data means eliminating redundant information from a table and organizing the data so that future changes to the table are easier.
  • Denormalization means allowing redundancy in a table.
  • The main benefit of denormalization is improved performance with simplified data retrieval and manipulation.
Your Name Your Email-ID
Your Answer
 
128. Can a database on a server be accessed from another server?
  Yes, by using a middleware product. This is called accessing a remote database.
Your Name Your Email-ID
Your Answer
 
129. Which clause in a DELETE statement is required?
  DELETE FROM
Your Name Your Email-ID
Your Answer
 
130. How is a remote database accessed through a web application?
  Via a web server.
Your Name Your Email-ID
Your Answer