OraFAQ Forum: Training & Certification » Updatable views + Key preserved table (merged)

Home » Other » Training & Certification » Updatable views + Key preserved table (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Updatable views + Key preserved table (merged) [message #315601]

Tue, 22 April 2008 02:24

priyamalhotra
Messages: 43
Registered: July 2006
Location: none

Member

Hi,

Kindly provide which one would be correct for the following:

Some explanation would be helpful.

The primary key of the STATE table is STATE_CD. The primary key of the CITY table is STATE_CD and CITY_CD. The STATE_CD column of the CITY table is the foreign key to the STATE table. There are no other constraints on these two tables. Consider the following view definition.

CREATE OR REPLACE VIEW state_city AS
SELECT a.state_cd, a.state_name, b.city_cd, b.city_name
FROM state a, city b
WHERE a.state_cd = b.state_cd;

Which of the following operations are permitted on the base tables of the view? (Choose all that apply.)

A. Insert a record into the CITY table

B. Insert a record into the STATE table

C. Update the STATE_CD column of the CITY table

D. Update the CITY_CD column of the CITY table

E. Update the CITY_NAME column of the CITY table

F. Update the STATE_NAME column of the STATE table

Thanks,
Priya.

Report message to a moderator

[Message index]

		Updatable views + Key preserved table (merged) By: priyamalhotra on Tue, 22 April 2008 02:24
		Re: Updatable views By: pablolee on Tue, 22 April 2008 02:45
		Re: Updatable views By: priyamalhotra on Tue, 22 April 2008 03:04
		Re: Updatable views By: Michel Cadot on Tue, 22 April 2008 03:21
		Re: Updatable views By: pablolee on Tue, 22 April 2008 03:28
		Re: Updatable views By: priyamalhotra on Tue, 22 April 2008 03:33
		Re: Updatable views By: Frank on Tue, 22 April 2008 03:59
		Re: Updatable views By: Michel Cadot on Tue, 22 April 2008 04:18
		newbies on oracle By: wzm04 on Fri, 25 April 2008 02:35
		Re: newbies on oracle By: drewsmith70 on Tue, 29 April 2008 13:55
		Key Preserved Table By: priyamalhotra on Wed, 14 May 2008 01:19
		Re: Key Preserved Table By: Michel Cadot on Wed, 14 May 2008 01:29
		Re: Key Preserved Table By: priyamalhotra on Wed, 14 May 2008 02:13

Previous Topic:	how can i catch prime numbers with While Loop ?
Next Topic:	Beginner database designer/dba

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 23:08:24 CDT 2024