What is a view, Basic Computer Science

Assignment Help:

Question

(a) What is a view?

(b) Can we use a view to insert or update a record into a table? Do we have any limitation to perform the above command?

(c) The syntax to create a view is given below-

CREATE VIEW [database_name.][schema_name.]view_name

WITH {ENCRYPTION | SCHEMABINDING}

AS

SELECT_statement

Explain the purpose of the Encryption and Schemabinding keyword in the above syntax

(d) What are joins? Describe the different types of join which is possible in SQL Server 2005

(e) Explain the purpose of an Outer Join and describe the three kinds of the outer join with appropriate example

(f) Explain the purpose of the EXCEPT operator


Related Discussions:- What is a view

Briefly explain the stage and the timeline, Question 1 Briefly explain the...

Question 1 Briefly explain the Stage and the Timeline Question 2 What is Device Central? How it is useful for previewing mobile content? Question 3 Which are the f

Sma* search - artificial intelligence, SMA* Search-Artificial intelligence ...

SMA* Search-Artificial intelligence IDA* search is good from a memory point of view. actually it may  be criticised for not using enough memory - utilizing  more memory may inc

DBMS, what is the meaning of data definition

what is the meaning of data definition

Web Design Project, Hello - What is the turn around time for a 6 page websi...

Hello - What is the turn around time for a 6 page website.

Memory unit of computer, Memory unit of computer: The Memory  unit is ...

Memory unit of computer: The Memory  unit is an important component of a computer where all the data and information are stored in the form  of binary digits (combination of 0

Powerpoint presentation of qualitative analysis approaches, Compare and con...

Compare and contrast two qualitative analysis approaches. You must select two that are a true contast eg  CAQADS (say leximancer ) v discourse analysis or thematic analysis by hand

Explanation of characteristics of computers, Problem 1. Briefly explain...

Problem 1. Briefly explain on the characteristics of computers Explanation of characteristics of computers 2. Write a note on Cache Memory Note on Cache Memor

Frequency and bandwidth, Frequency and Bandwidth: Let us try to unders...

Frequency and Bandwidth: Let us try to understand a little about how information is transmitted. The information may be in the form of sound (human voice, music) or it may be

Database, Q1: ER modelling & logical design. An information system is requi...

Q1: ER modelling & logical design. An information system is required for an online auction site, based on the following speci?cation: Only registered users can use the site. Privat

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd