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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
About Indexed Views? with example?
plz reply...
 Question Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: About Indexed Views? with example? plz reply...
Answer
# 1
Index created on view is called as indexed view or 
materialised view.
To create index on a view we should create a view 
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by 
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view
 
Is This Answer Correct ?    2 Yes 1 No
Sruthi
 
  Re: About Indexed Views? with example? plz reply...
Answer
# 2
Creating index on views is not possible in Sybase.
 
Is This Answer Correct ?    1 Yes 0 No
Manoj Joshi
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
how many joins we can write if at all we have n no of tables Tanla-Solutions4
What is the difference Between Sql-server 2000 & 2005 Value-Labs2
how to select a field with firstletter as capital and remaining are small letters  8
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
What is transcation?Plz give One example?  2
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output  5
Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table? Accenture3
what is hash table Teledata2
What is the difference between a stored procedure and a user defined function in sql server? Millennium2
What is a job?  3
If there is failure during updation of certain rows, what will be the state?  1
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?  2
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder IBM1
what is the difference between group and having give an example with query and sample output  2
how to get the rowid/rownumbes of a table in sqlserver IBM5
write the query for taking database restore in sql?  2
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
what are three different authentications to connect linked servers? CitiGroup1
how to know description of a table in sqlserver 2000  7
I have student marks in a student table. I need second highest mark .Then what will the query for this? Wipro23
 
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