Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews Databases Programming Interviews:BtrieveClipperData ModelingData StructuresDatabase AdministrationDatabase Administrator (DBA)Database AnalystDatabase DeveloperDB DevelopmentEDI/Data Integration ExpertFirebirdHierarchicalIBM DB2InformixJava DatabaseMariaDBMicrosoft Access DeveloperMongoDBMS SQL ServerMySQL ProgrammingNetworkNoSQLObject RelationalPostgrePostgreSQLProgressRDBMSRelationalSQLSQL AdministratorSQL and PL/SQLSQL Notification ServicesSQL server 2008SSRSStored ProcedureSybaseTeradata
Copyright © 2018. All Rights Reserved
MS SQL Server Interview Question:
What Are Views in MS SQL Server?
Submitted by: AdministratorA view is a database object that represents the data in one or more tables in the same structure as a separate table. Here are some basic rules about views:
* Tables store real data.
* Views do not store real data.
* Views must have underlying tables to provide data.
* Each view is based on a single SELECT statement to control what data to collect from tables, and how data should be represented.
* View's columns can be mapped directly to columns in underlying tables.
* View's columns can be created expressions based multiple columns in underlying tables.
* Views can be used in same way as tables in queries.
Submitted by: Administrator
* Tables store real data.
* Views do not store real data.
* Views must have underlying tables to provide data.
* Each view is based on a single SELECT statement to control what data to collect from tables, and how data should be represented.
* View's columns can be mapped directly to columns in underlying tables.
* View's columns can be created expressions based multiple columns in underlying tables.
* Views can be used in same way as tables in queries.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.