Question 1

(Access)The following view is updatable:

Accepted Answer

A)  CUST_SD 
B)  CUST_40D 
C)  Make_View 
D)  All of the above 
A)  CUST_SD 
B)  CUST_40D 
C)  Make_View 
D)  All of the above

Question 2

Figuer:
CUSTOMER (primary key = CID) $\begin{array}{|l|l|l|l|l|}
\hline \text { CID } & \text { CNAME } & \text { AGE } & \text { RESID\_CITY } & \text { Cregion } \
\hline 10 & \text { BLACK } & 40 & \text { SD } & \text { SD } \
\hline 20 & \text { GREEN } & 25 & \text { SD } & \text { SD } \
\hline 30 & \text { JONES } & 30 & \text { La Mesa } & \text { SD } \
\hline 40 & \text { MARTIN } & 35 & \text { LA } & \text { LA } \
\hline 50 & \text { SIMON } & 22 & \text { Pomona } & \text { LA } \
\hline 60 & \text { VERNON } & 60 & \text { Poway } & \text { SD } \
\hline
\end{array}$ RENTALS (primary key = RTN) \[\begin{array} { | l | l | l | l | l | l | l | l | } 
\hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } & \text { VIN } & \text { DATE-IN } \
\hline 10 & \text { FORD } & \text { 10-Oct-00 } & \text { SD } & \text { SD } & 1 & \text { F1 } & \text { 01-Dec-00 } \
\hline 10 & \text { GM } & 01 - \text { Jan-01 } & \text { SD } & \text { LA } & 2 & & \
\hline 10 & \text { FORD } & 01 - \text { Feb-01 } & \text { LA } & \text { SD } & 3 & & \
\hline 20 & \text { NISSAN } & 07 - J u l - 00 & \text { SD } & & 4 & \text { N1 } & \
\hline 30 & \text { FORD } & 01 - J u l - 00 & \text { SD } & \text { SD } & 5 & \text { F2 } & 30 \text {-Nov-00 } \
\hline 30 & \text { GM } & 01 - \text {-Dec-00 } & \text { SD } & \text { SD } & 6 & \text { G1 } & \
\hline 40 & \text { FORD } & 01 - \text { Aug-00 } & \text { LA } & \text { LA } & 7 & \text { F3 } & \
\hline 50 & \text { GM } & 01 - \text { Sep-00 } & \text { LA } & \text { SD } & 8 & \text { G2 } & \
\hline 60 & \text { NISSAN } & 02 \text {-Jan-01 } & \text { SD } & \text { LA } & 9 & & \
\hline
\end{array}\] In the table RENTALS, RTN provides the rental number (it is the primary key), CID refers to the CID in CUSTOMER, PICKUP is the city where the car was (or will be) picked up and Return is the city where the car was (or will be) returned, VIN is a foreign key that references the table CAR. The rental company has two branches, one in San Diego (SD) and one in Los Angeles (LA). Cars are picked up and returned by the customers at these two locations.
RENTCOST $$\begin{array} { | l | l | } 
\hline \text { MAKE } & \text { COST } \
\hline \text { FORD } & 30 \
\hline \text { GM } & 40 \
\hline \text { NISSAN } & 30 \
\hline \text { TOYOTA } & 20 \
\hline \text { VOLVO } & 50 \
\hline
\end{array}$$ In RENTCOST, COST shows the base cost of renting a given MAKE for one day.
CAR $$\begin{array} { | l | l | l | l | } 
\hline \text { VIN } & \text { MAKE } & \text { RENTED } & \text { AT } \
\hline \text { F1 } & \text { FORD } & \text { NO } & \text { SD } \
\hline \text { F2 } & \text { FORD } & \text { NO } & \text { SD } \
\hline \text { F3 } & \text { FORD } & \text { YES } & \text { IR } \
\hline \text { F4 } & \text { FORD } & \text { NO } & \text { LA } \
\hline \text { G1 } & \text { GM } & \text { YES } & \text { SD } \
\hline \text { G2 } & \text { GM } & \text { YES } & \text { SD } \
\hline \text { N1 } & \text { NISSAN } & \text { YES } & \text { LA } \
\hline \text { N2 } & \text { NISSAN } & \text { NO } & \text { LA } \
\hline \text { T1 } & \text { TOYOTA } & \text { NO } & \text { IR } \
\hline \text { T2 } & \text { TOYOTA } & \text { NO } & \text { IR } \
\hline \text { V1 } & \text { VOLVO } & \text { NO } & \text { LA } \
\hline \text { V2 } & \text { VOLVO } & \text { NO } & \text { LA } \
\hline
\end{array}$$ The table CAR (primary key = VIN) provides information about each car, in particular if it is currently rented, and where its usual storage location is (attribute AT).
CREATE VIEW CUST_SD AS
SELECT * FROM CUSTOMER
WHERE Cregion = 'SD'
CREATE VIEW CUST_40D AS
SELECT CNAME, RENTALS.MAKE, RENTCOST.COST
FROM CUSTOMER, RENTALS, RENTCOST
WHERE CUSTOMER.CID = RENTALS.CID
AND RENTALS.MAKE = RENTCOST.MAKE
AND RENTCOST < 40
CREATE VIEW Make_View (Make, NumRentals, Cregion, Storageat) AS
SELECT RENTALS.MAKE, Count (RTN), Cregion, AT
FROM CUSTOMER, RENTALS, CAR
WHERE CUSTOMER.CID = RENTALS.CID
AND RENTALS.VIN = CAR.VIN
GROUP BY RENTALS.MAKE, Cregion, At
-UPDATE CUSTOMER SET AGE = AGE + 1
This command updates the following number of rows in the view CUST_SD:

Accepted Answer

A)  3 
B)  4 
C)  6 
D)  0 
A)  3 
B)  4 
C)  6 
D)  0

Question 3

One of the rules for 1-M updatable queries states that the ________________ of the parent tables must be either a primary key or some other unique specification.

Accepted Answer

The answer of One of the rules for 1-M updatable...

Question 4

The ________________ clause of the CREATE VIEW statement prevents UPDATE and INSERT statements that violate a view's WHERE clause from executing.

Accepted Answer

The answer of The ________________ clause of the CREATE VIEW...

Question 5

In a hierarchical form,the fixed part is called the parent form and the variable part is called the child form.

Accepted Answer

A) True 
 B)False

Question 6

A method to process a query on a view by executing the query directly on the stored view is known as _____________________.

Accepted Answer

view mater

Question 7

You want to create a form to process the rentals of a given customer.You would like to include the Cost of the Make.Select the most appropriate statement:

Accepted Answer

A)  Cost should be in the main form 
B)  Cost should be in the subform 
C)  Either A or B 
D)  Cost should appear at the jointure of the two forms 
A)  Cost should be in the main form 
B)  Cost should be in the subform 
C)  Either A or B 
D)  Cost should appear at the jointure of the two forms

Question 8

One of the advantages of views is __________________,meaning if an application accesses the database through a view,most changes to the conceptual schema will not affect the application.

Accepted Answer

The answer of One of the advantages of views is...

Question 9

The variable part of a hierarchical form is known as the __________________.

Accepted Answer

The answer of The variable part of a hierarchical form...

Question 10

To define a view,SQL provides the __________________ statement,in which you identify the view name and the underlying SELECT statement.

Accepted Answer

The answer of To define a view,SQL provides the __________________...

Question 11

In the "three schema architecture",views belong to:

Accepted Answer

A)  The internal level 
B)  The conceptual level 
C)  The external level 
D)  The client-server level 
A)  The internal level 
B)  The conceptual level 
C)  The external level 
D)  The client-server level

Question 12

In a hierarchical form involving a 1-M relationship,only columns from the two tables involved in the relationship can be displayed in the form.

Accepted Answer

A) True 
 B)False

Question 13

You can rename some of the columns,all of the columns,or none of the columns in a view using parentheses after the view name.

Accepted Answer

A) True 
 B)False

Question 14

To use a view in a query instead of a base table,you would use the view name in the _____________ and the view columns in other parts of the query statement.

Accepted Answer

The answer of To use a view in a query...

Question 15

A single-table view is not updatable if all of the columns of the base table are not included in the view.

Accepted Answer

A) True 
 B)False

(Access)The following view is updatable:

One of the rules for 1-M updatable queries states that the ________________ of the parent tables must be either a primary key or some other unique specification.

The ________________ clause of the CREATE VIEW statement prevents UPDATE and INSERT statements that violate a view's WHERE clause from executing.

In a hierarchical form,the fixed part is called the parent form and the variable part is called the child form.

A method to process a query on a view by executing the query directly on the stored view is known as _____________________.

You want to create a form to process the rentals of a given customer.You would like to include the Cost of the Make.Select the most appropriate statement:

One of the advantages of views is __________________,meaning if an application accesses the database through a view,most changes to the conceptual schema will not affect the application.

The variable part of a hierarchical form is known as the __________________.

To define a view,SQL provides the __________________ statement,in which you identify the view name and the underlying SELECT statement.

In the "three schema architecture",views belong to:

In a hierarchical form involving a 1-M relationship,only columns from the two tables involved in the relationship can be displayed in the form.

You can rename some of the columns,all of the columns,or none of the columns in a view using parentheses after the view name.

To use a view in a query instead of a base table,you would use the view name in the _____________ and the view columns in other parts of the query statement.

A single-table view is not updatable if all of the columns of the base table are not included in the view.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 10: Application Development With Views

(Access)The following view is updatable:

One of the rules for 1-M updatable queries states that the ________________ of the parent tables must be either a primary key or some other unique specification.

The ________________ clause of the CREATE VIEW statement prevents UPDATE and INSERT statements that violate a view's WHERE clause from executing.

In a hierarchical form,the fixed part is called the parent form and the variable part is called the child form.

A method to process a query on a view by executing the query directly on the stored view is known as _____________________.

You want to create a form to process the rentals of a given customer.You would like to include the Cost of the Make.Select the most appropriate statement:

One of the advantages of views is __________________,meaning if an application accesses the database through a view,most changes to the conceptual schema will not affect the application.

The variable part of a hierarchical form is known as the __________________.

To define a view,SQL provides the __________________ statement,in which you identify the view name and the underlying SELECT statement.

In the "three schema architecture",views belong to:

In a hierarchical form involving a 1-M relationship,only columns from the two tables involved in the relationship can be displayed in the form.

You can rename some of the columns,all of the columns,or none of the columns in a view using parentheses after the view name.

To use a view in a query instead of a base table,you would use the view name in the _____________ and the view columns in other parts of the query statement.

A single-table view is not updatable if all of the columns of the base table are not included in the view.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Developing Data Models for Business Databases

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters