Question 1

In a 1-M updatable query,update operations are supported on the parent table even if the query does not contain the primary key of the parent table.

Accepted Answer

A) True 
 B)False

Question 2

The innermost line in a report is called the ______________.

Accepted Answer

The answer of The innermost line in a report is...

Question 3

Figuer:
CUSTOMER (primary key = CID)
CNAME is NOT NULL $$\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)
CID is a foreign key referencing CUSTOMER
CID is NOT NULL
MAKE is NOT NULL
MAKE is a foreign key referencing RENTCOST $$\begin{array} { | l | l | l | l | l | l | } 
\hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } \
\hline 10 & \text { FORD } & 10 - \text { Oct-00 } & \text { SD } & \text { SD } & 1 \
\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 \
\hline 30 & \text { FORD } & 01 - J u l - 00 & \text { SD } & \text { SD } & 5 \
\hline 30 & \text { GM } & 01 - \text {-Dec-00 } & \text { SD } & \text { SD } & 6 \
\hline 40 & \text { FORD } & 01 - \text { Aug-00 } & \text { LA } & \text { LA } & 7 \
\hline 50 & \text { GM } & 01 - \text { Sep-00 } & \text { LA } & \text { SD } & 8 \
\hline 60 & \text { NISSAN } & 02 \text {-Jan-01 } & \text { SD } & \text { LA } & 9 \
\hline
\end{array}$$ RENTCOST
MAKE is the primary key $$\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}$$ (Access) View1:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CUSTOMER.CID, CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View2:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View3:
SELECT RTN, RENTALS.MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion, COST
FROM (CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID.
INNER JOIN RENTCOST
ON RENTALS.MAKE = RENTCOST.MAKE
-(Access)INSERT INTO View2 (RTN,MAKE,PICKUP,RENTALS.CID.
VALUES (10,'GM','SD',10)
Which of the following is not true?

Accepted Answer

A)  This command inserts 1 row into RENTALS 
B)  This command inserts 1 row into CUSTOMER 
C)  After execution of this command, SELECT MAKE FROM View2 will show 5 rows where MAKE has 'GM' for value 
D)  The CUSTOMER table is not updated 
A)  This command inserts 1 row into RENTALS 
B)  This command inserts 1 row into CUSTOMER 
C)  After execution of this command, SELECT MAKE FROM View2 will show 5 rows where MAKE has 'GM' for value 
D)  The CUSTOMER table is not updated

Question 4

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
-SELECT CUST_SD.CNAME,RENTALS.DATE_OUT FROM CUST_SD,RENTALS
WHERE CUST_SD.CID = RENTALS.CID
AND CUST_SD.Cregion = RENTALS.RETURN
The number of rows displayed by this SELECT statement is:

Accepted Answer

A)  3 
B)  4 
C)  5 or more 
D)  0 
A)  3 
B)  4 
C)  5 or more 
D)  0

Question 5

For each Cregion,you want to show each customer (CNAME),and for each customer,each rental ordered by Make,showing PICKUP,RETURN and DATE-OUT.Which of the following would be a group in a hierarchical report?

Accepted Answer

A)  MAKE 
B)  PICKUP 
C)  RETURN 
D)  RENTALS 
A)  MAKE 
B)  PICKUP 
C)  RETURN 
D)  RENTALS

Question 6

A view that can be used in SELECT,UPDATE,INSERT,and DELETE statements is a(n)_________________.

Accepted Answer

The answer of A view that can be used in...

Question 7

In a data warehouse environment,views are materialized on demand,i.e.when the view query is submitted.

Accepted Answer

A) True 
 B)False

Question 8

Typically in a hierarchical form,data in the main form may be non-updatable.

Accepted Answer

A) True 
 B)False

Question 9

When defining a view using SQL:

Accepted Answer

A)  The SQL does not have to contain a select statement that defines the virtual or derived table 
B)  The select statement in the SQL must contain a reference to only one table 
C)  The column names of the virtual or derived table can be renamed in the SQL. 
D)  The column names of the virtual or derived table will always match the column names in the select statement 
A)  The SQL does not have to contain a select statement that defines the virtual or derived table 
B)  The select statement in the SQL must contain a reference to only one table 
C)  The column names of the virtual or derived table can be renamed in the SQL. 
D)  The column names of the virtual or derived table will always match the column names in the select statement

Question 10

The same rules of updatability apply to 1-M queries with more than two tables,but you must apply the rules to each join in the query.

Accepted Answer

A) True 
 B)False

Question 11

A view that can be used only in SELECT statements is a(n)______________________.

Accepted Answer

The answer of A view that can be used only...

Question 12

_____________ is a formatted display of a query using indentation to show grouping and sorting.

Accepted Answer

A)  Hierarchical Report 
B)  Hierarchical Form 
C)  Updateable View 
D)  Virtual Table 
A)  Hierarchical Report 
B)  Hierarchical Form 
C)  Updateable View 
D)  Virtual Table

Question 13

Typically in a hierarchical form,which of the following statements is not true?

Accepted Answer

A)  At a given time, the main form may show several records 
B)  At a given time, the main form may show one record 
C)  At a given time, the subform may show several records 
D)  At a given time, the subform may show one record 
A)  At a given time, the main form may show several records 
B)  At a given time, the main form may show one record 
C)  At a given time, the subform may show several records 
D)  At a given time, the subform may show one record

Question 14

Depending on its definition,a view can be read-only or updateable.All views are at least __________.

Accepted Answer

The answer of Depending on its definition,a view can be...

Question 15

To be updatable,a single-table view cannot contain the keywords ____________ or ____________ in the view definition.

Accepted Answer

The answer of To be updatable,a single-table view cannot contain...

Question 16

To process queries that reference a view,the DBMS can use either a _________ or __________ strategy.

Accepted Answer

A)  direct, indirect 
B)  materialization, modification 
C)  materialization, indirect 
D)  realistic, virtual 
A)  direct, indirect 
B)  materialization, modification 
C)  materialization, indirect 
D)  realistic, virtual

Question 17

To process queries that reference a view,____________________ is not usually the best strategy because it requires the DBMS to execute two queries.

Accepted Answer

The answer of To process queries that reference a view,____________________...

Question 18

A hierarchical report is also known as a(n)_________________.

Accepted Answer

control br

Question 19

A formatted window for data entry and display which is comprised of a fixed part and a variable part is called a(n)___________________.

Accepted Answer

The answer of A formatted window for data entry and...

Question 20

Figuer:
CUSTOMER (primary key = CID)
CNAME is NOT NULL $$\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)
CID is a foreign key referencing CUSTOMER
CID is NOT NULL
MAKE is NOT NULL
MAKE is a foreign key referencing RENTCOST $$\begin{array} { | l | l | l | l | l | l | } 
\hline \text { CID } & \text { MAKE } & \text { DATE\_OUT } & \text { PICKUP } & \text { RETURN } & \text { RTN } \
\hline 10 & \text { FORD } & 10 - \text { Oct-00 } & \text { SD } & \text { SD } & 1 \
\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 \
\hline 30 & \text { FORD } & 01 - J u l - 00 & \text { SD } & \text { SD } & 5 \
\hline 30 & \text { GM } & 01 - \text {-Dec-00 } & \text { SD } & \text { SD } & 6 \
\hline 40 & \text { FORD } & 01 - \text { Aug-00 } & \text { LA } & \text { LA } & 7 \
\hline 50 & \text { GM } & 01 - \text { Sep-00 } & \text { LA } & \text { SD } & 8 \
\hline 60 & \text { NISSAN } & 02 \text {-Jan-01 } & \text { SD } & \text { LA } & 9 \
\hline
\end{array}$$ RENTCOST
MAKE is the primary key $$\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}$$ (Access) View1:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CUSTOMER.CID, CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View2:
SELECT RTN, MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion
FROM CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID
(Access) View3:
SELECT RTN, RENTALS.MAKE, PICKUP, RENTALS.CID,
CNAME, AGE, Cregion, COST
FROM (CUSTOMER INNER JOIN RENTALS
ON CUSTOMER.CID = RENTALS.CID.
INNER JOIN RENTCOST
ON RENTALS.MAKE = RENTCOST.MAKE
-(Access)Which of the following statements is true?

Accepted Answer

A)  Data in RENTALS may be updated, using an UPDATE command on View3 
B)  Data in CUSTOMER may be updated, using an UPDATE command on View3 
C)  Data in RENTCOST may be updated, using an UPDATE command on View3 
D)  All of the above 
A)  Data in RENTALS may be updated, using an UPDATE command on View3 
B)  Data in CUSTOMER may be updated, using an UPDATE command on View3 
C)  Data in RENTCOST may be updated, using an UPDATE command on View3 
D)  All of the above

In a 1-M updatable query,update operations are supported on the parent table even if the query does not contain the primary key of the parent table.

The innermost line in a report is called the ______________.

For each Cregion,you want to show each customer (CNAME),and for each customer,each rental ordered by Make,showing PICKUP,RETURN and DATE-OUT.Which of the following would be a group in a hierarchical report?

A view that can be used in SELECT,UPDATE,INSERT,and DELETE statements is a(n)_________________.

In a data warehouse environment,views are materialized on demand,i.e.when the view query is submitted.

Typically in a hierarchical form,data in the main form may be non-updatable.

When defining a view using SQL:

The same rules of updatability apply to 1-M queries with more than two tables,but you must apply the rules to each join in the query.

A view that can be used only in SELECT statements is a(n)______________________.

_____________ is a formatted display of a query using indentation to show grouping and sorting.

Typically in a hierarchical form,which of the following statements is not true?

Depending on its definition,a view can be read-only or updateable.All views are at least __________.

To be updatable,a single-table view cannot contain the keywords or in the view definition.

To process queries that reference a view,the DBMS can use either a _ or __ strategy.

To process queries that reference a view,____________________ is not usually the best strategy because it requires the DBMS to execute two queries.

A hierarchical report is also known as a(n)_________________.

A formatted window for data entry and display which is comprised of a fixed part and a variable part is called a(n)___________________.

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

In a 1-M updatable query,update operations are supported on the parent table even if the query does not contain the primary key of the parent table.

The innermost line in a report is called the ______________.

For each Cregion,you want to show each customer (CNAME),and for each customer,each rental ordered by Make,showing PICKUP,RETURN and DATE-OUT.Which of the following would be a group in a hierarchical report?

A view that can be used in SELECT,UPDATE,INSERT,and DELETE statements is a(n)_________________.

In a data warehouse environment,views are materialized on demand,i.e.when the view query is submitted.

Typically in a hierarchical form,data in the main form may be non-updatable.

When defining a view using SQL:

The same rules of updatability apply to 1-M queries with more than two tables,but you must apply the rules to each join in the query.

A view that can be used only in SELECT statements is a(n)______________________.

_____________ is a formatted display of a query using indentation to show grouping and sorting.

Typically in a hierarchical form,which of the following statements is not true?

Depending on its definition,a view can be read-only or updateable.All views are at least __________.

To be updatable,a single-table view cannot contain the keywords ____________ or ____________ in the view definition.

To process queries that reference a view,the DBMS can use either a _________ or __________ strategy.

To process queries that reference a view,____________________ is not usually the best strategy because it requires the DBMS to execute two queries.

A hierarchical report is also known as a(n)_________________.

A formatted window for data entry and display which is comprised of a fixed part and a variable part is called a(n)___________________.

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

To be updatable,a single-table view cannot contain the keywords or in the view definition.

To process queries that reference a view,the DBMS can use either a _ or __ strategy.