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

File sharing architecture, File Sharing Architecture:   The developmen...

File Sharing Architecture:   The development of microprocessor, PC and LAN transformed dumb terminals into -smart? clients. This brought a complete change in the computing env

Hotel database, Create a database,show all ojectives and give a fruitful in...

Create a database,show all ojectives and give a fruitful introduction and also state how it will be implemented

Telecommunications network, Telecommunications network: "A telecommuni...

Telecommunications network: "A telecommunications network, at its simplest, may be regarded as comprising a transmission network, an arrangement of transmission paths and swit

Example of autonomous rational agents, Example of autonomous rational agent...

Example of autonomous rational agents-Artificial intelligence The procedure of waste water treatment After the level of pollutants in waste water is find out,  following 5

Flowchart, 1. The volume of a pyramid is taken from the formula: V = 1/3 x ...

1. The volume of a pyramid is taken from the formula: V = 1/3 x AREA OF BASE x ALTITUDE Given the dimensions of a pyramid, calculate the cost of materials for making that pyrami

Methods of working with files, There are two methods to work with files, th...

There are two methods to work with files, the first one is through file control blocks or "FCB" and the second one is through communication channels, also identified as "handles".

Cryptography, Consider the one-time pad encryption scheme to encrypt a 1-bi...

Consider the one-time pad encryption scheme to encrypt a 1-bit message m, and assume m is chosen with uniform distribution from message space M={0,1}. Let E1 be the event "message

Read world population data file. store the values in multipl, Read World Po...

Read World Population Data File. Store the values in multiple vectors. Sort them by most populated region and output the results ext file is here : please">http://www.csupomona.

Use Decision Tree Technique to Optimize Institution’s Studen, Use Decision ...

Use Decision Tree Technique to Optimize Institution’s Student Admission Process– A Case Study

Computer graphics, A scaling constant indicates an expansion of length

A scaling constant indicates an expansion of length

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