Answered: A create view statement creates a new…

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter7: Database Administration

Section: Chapter Questions

Problem 3SCG: Create a view named CONDO_FEES. It consists of two columns: the first is the square footage, and the...

See similar textbooks

Related questions

Concept explainers

Question

1. A create view statement creates a new table with its on data using the view select query. True False 2. An alter table statement: a. will delete table values when a column is removed b. can be used to set a default value c. allows the creation of a new column in a table d. all of these are true 3. A view is updateable if the defining query has: a. a FROM clause that specifies more than one table b. has a GROUP BY or HAVING clause c. a FROM clause that specifies a single table d. a where clause with a sub query that references a table from the FROM clause 4. If a table's primary key contains multiple columns, it must be defined in the create table statement using a table constraint. True or false 5. If two tables A and B need to have mutual foreign key references, each foreign key constraint can be defined in the create table statements for A and B. True or False 6. If an alter statement drops a table column, the DBMS will stop the drop in the table column has data values. True or false 7. By default, the DBMS will prevent drop table statement execution if the table to be dropped is referred to by another table's foreign key. True or false 8. A create view statement a. can create a primary key b. can contain an insert into query c. can refer to multiple tables d. can create a foreign key 9. A column constraint: a. can only be a check constraint b. refers to only a single column c. cannot be used to define a foreign key constraint d. refers to any number of columns 10. Privileges to other users to a table can be control by the a. grant statement b. revoke statement c. both 1 and 2 d. neither 1 nor 2

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.