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

Necessary nurses records, Necessary Nurses Records The software shoul...

Necessary Nurses Records The software should generate all registers/reports in detail summary for various permutations and combinations of options. A powerful SQL (Structure

Flowcharts, flowchart that display yhe students average scores for 3 quizze...

flowchart that display yhe students average scores for 3 quizzes.Assume that there are 3 sections having 5 student each.Valid number is 1-100 for the quizzes.Enter an invalid numbe

System software, Name and explain the classifications of computers

Name and explain the classifications of computers

Display the item in red colour on a web page, QUESTION (a) Give the app...

QUESTION (a) Give the appropriate syntax to implement a Client-Side Image Map, specifying all possible attributes where required (b) List the benefits of using Cascading Sty

Outdoor patient department features - a doctor module, A Doctor Module ...

A Doctor Module Doctor has a list of the patients waiting for consultation. The doctor's module should include all the following details: Fields for common complaint

Define levels of abstraction in a dbms, Define Levels of Abstraction in a D...

Define Levels of Abstraction in a DBMS, explain briefly, Conceptual Schema, Physical Schema, External Schema

Flow decomposition technique to list the cycles, QUESTION (a) Consider ...

QUESTION (a) Consider the graph below, use the Flow Decomposition technique to list the cycles and paths produced.                                                (b) Pr

Definition of procedure, A procedure is a compilation of instructions to wh...

A procedure is a compilation of instructions to which we can express the flow of our program, and once the execution of these instructions is over power is given back to the next l

Write a note on file permissions on linux, Question 1 Write a note on a...

Question 1 Write a note on advantages and disadvantages of Linux 2 Write a note on "File Permissions" on linux 3 Explain the usage of following Linux commands Cd kill

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