ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Whether the updations made to the views reflect the 
original records in the table
 Question Submitted By :: Prernagupta
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Whether the updations made to the views reflect the original records in the table
Answer
# 1		 
No. Updating View will not affect the table records.
 
Is This Answer Correct ?    7 Yes 8 No
Soorai Ganesh
 
  Re: Whether the updations made to the views reflect the original records in the table
Answer
# 2		 
If the view is created with single table. Updating a view 
will affect the origival records in the table
 
Is This Answer Correct ?    6 Yes 1 No
Sabareetha
 
 
 
  Re: Whether the updations made to the views reflect the original records in the table
Answer
# 3		 
yes
 
Is This Answer Correct ?    1 Yes 2 No
Anil
 
  Re: Whether the updations made to the views reflect the original records in the table
Answer
# 4		 
No
 
Is This Answer Correct ?    1 Yes 0 No
Sangita
 
  Re: Whether the updations made to the views reflect the original records in the table
Answer
# 5		 
in the case if same table (all column) are make a view then 
updations  reflect the original record in the table.

but mostly make a view to security purpose the , uniques 
are constaint column are not use,
then not be reflect .
 
Is This Answer Correct ?    3 Yes 0 No
Ravi Sharma
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?  1
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?  1
what is physical sort data and logical sort data in index?  2
what is cluster and nin-cluster index?  4
Why we need a group by clause?  3
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com Oracle18
what is normalization? what is denormalization? Satyam5
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?  2
Differnce between sel server 2000 and 2005  3
How can your resolve deadlocks? IBM3
What is the system function to get the current user's user id? HCL1
Please tell me some knowledge about Clustering and how to add clustering?  1
How do we get current date in SQL Server 2000, Oracle, MS Access?  11
What is the difference between temp table and table variable? Microsoft4
how many type of subquery?  2
What is the difference between Drop and Truncate  10
how to connect sybase to sql server 2005?. ABC1
What is referential integrity? What are the advantages of it? Digital-Domain3
what is IDE,DMV in sql server? Value-Labs1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com