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

Scheme, There is a path between two vertices if there is a series of edges ...

There is a path between two vertices if there is a series of edges that you can use to travel between them. For example, between vertices 1 and 3 above, there is a path made up of

Digital logic design, Find the complement of the following decimal 7

Find the complement of the following decimal 7

Write a detailed note on colour balance, Question 1 Write a long note on s...

Question 1 Write a long note on setting up a typical on-location News Interview Question  2 Write a long note on how to work with presenters Question 3 Write long notes

Desktop computer, Desktop computer: Desktop computer is popularly know...

Desktop computer: Desktop computer is popularly known as personal computer (PC). As the name suggest, it is generally small in size and fitted on the top of a desk which can b

What are search engines, QUESTION 1 What are search engines? QUESTI...

QUESTION 1 What are search engines? QUESTION 2 Write short notes on the inverted file. QUESTION 3 Write short notes on: (i) Derivative indexing (also known a

D, #questionWrite a program to find the area under the curve y = f(x) betwe...

#questionWrite a program to find the area under the curve y = f(x) between x = a and x = b, integrate y = f(x) between the limits of a and b. The area under a curve between two poi

Binary codes, Binary Codes: We have seen earlier that digital computer...

Binary Codes: We have seen earlier that digital computers use signals that have two distinct values and there exists a direct analogy between binary signals and binary digits.

What is an array? explain, Question 1 . What is an array? Explain Qu...

Question 1 . What is an array? Explain Question 2 . What do you mean by optional arguments? Describe Question 3 . Describe in brief about interfaces Question 4

Instruction pipeline, How branching takes place in Instruction pipeline. Ex...

How branching takes place in Instruction pipeline. Explain with suitable examples.

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