CS 6400 – Exam 1 – Spring 2017 1. Which of the following are considered representational data models !" #ierarchical data model $" %elational data model C" &etwor' data model (" !ll of the a)o*e E" &one of the a)o*e
2.#ow is a s+rrogate +sed in a ($,S !" -o +ni+el/ identif/ something $" -o speed +p access to data in a separate ta)le C" -o generate a c+stom *iew (" -o identif/ a col+mn in a ta)le E" &one of the a)o*e .Which of the following is &- a reason to +se a ($,S !" &eed to share data with m+ltiple +sers $" &eed to s+pport serio+s realtime access re+irements C" &eed persistence of storage and centrali3ed control (" !ll of the a)o*e are reasons to +se a ($,S E" &one of the a)o*e are reasons to +se a ($,S 4. f the data stored in /o+r ($,S has no red+ndanc/5 /o+ are also g+aranteed that /o+ !" ha*e consistenc/ $" ha*e completeness C" ha*e impro*ed performance (" ha*e all of the a)o*e E" ha*e none of the a)o*e . Which of the following statements is tr+e !" End +sers of a data)ase m+st 'now details a)o+t the storage str+ct+res +sed )/ the data)ase s/stem $" !pplication programmers are responsi)le for the ph/sical design of the data)ase C" -he data)ase administrator is responsi)le for a+thori3ing access to the data)ase (" !ll of the a)o*e are tr+e E" &one of the a)o*e are tr+e 6. n a data)ase s/stem5 a &899 *al+e indicates !" -he *al+e exists5 )+t we do not 'now it. $" -he *al+e does not exist C" -he *al+e is not applica)le (" !ll of the a)o*e E" &one of the a)o*e
7. E*er/ time we delete a record from a data)ase5 we change which of the following !" the data)ase schema $" the data)ase state C" the data)ase intension (" !ll of the a)o*e E" &one of the a)o*e :. !ccording to the le*el !&S;S. f we change the concept+al schema in a data)ase witho+t affecting the external schema5 then we refer to this as which of the following !" nformation encaps+lation $" 9ogical data independence C" External *iew +pdata)ilit/ (" mpedance mismatch E" &one of the a)o*e 10. Which of the following is more diffic+lt for a ($,S to pro*ide !" 9ogical data independence $"
11. n an EE% diagram5 entit/ names m+st )e !" &o+ns $" ?er)s C" 8ni+e (" ,onotonic E" &one of the a)o*e
12. -he first commercial EE% data)ase s/stem was sold )/ !" racle $" ,icrosoft C" $, (" S!< E" &one of the a)o*e
1. -he EE% model does &- pro*ide s+pport for !" classification $" aggregation C" generali3ation (" ! @ C E" &one of the a)o*e 14. Which of the following statements is tr+e !" ! wea' entit/ t/pe ne*er has a partial 'e/ $" ! wea' entit/ t/pe does not ha*e a 'e/ made +p entirel/ of attri)+tes of its own C" ! wea' entit/ t/pe alwa/s has a total participation constraint with respect to its identif/ing relationship (" $oth =$" and =C" E" &one of the a)o*e
&
,anages
1
,anagementCompan/
<&ame
,&ame
1. Considering the EE% diagram a)o*e5 if we ha*e 1 instances of the ,anages relationship t/pe5 then which of the following statements are tr+e !" We m+st ha*e 1 instances of the
Car
,
!ppears
&
Show
16. Considering the EE% diagram a)o*e5 if we ha*e instances of the Car relationship t/pe5 and 10 instances of the Show t/pe5 then which of the following statements are tr+e !" -here ma/ )e instances of the !ppears entit/ t/pe $" -here ma/ )e no instances of the !ppears entit/ t/pe C" -here ma/ )e 10 instances of the !ppears entit/ t/pe
(" !ll of the a)o*e E" &one of the a)o*e
SS&
(octor
17. Considering the EE% diagram a)o*e5 is it possi)le for two different (octors to ha*e the same set of *al+es for the phone attri)+te !" Aes $" &o C" 8na)le to sa/ from the diagram (" !ll of the a)o*e E" &one of the a)o*e
1:. Considering the EE% diagram a)o*e5 what t/pe of attri)+te is
%oom
&+m)er
& n
1
$+ilding
9ocation
&ame
1>. Considering the EE% diagram a)o*e5 What are the attri)+tes that +ni+el/ identif/ a room entit/ !" &+m)er $" &+m)er5 &ame C" &+m)er5 &ame5 9ocation (" &+m)er5 n E" &one of the a)o*e 20. Considering the B same duplicate> EE% diagram a)o*e5 which of the following statements is tr+e
!" ! )+ilding m+st ha*e m+ltiple rooms $" ! )+ilding m+st ha*e at least one room C" ! room m+st )e in a single )+ilding (" $oth =!" and =C" E" &one of the a)o*e
irst
9ast
&ame
#o+rs
Emplo/ee
,anager
&
1 ,anaged$/
21. Considering the EE% diagram a)o*e5 if there are 100 instances of Emplo/ee and 10 instances of ,anager5 then how man/ total instances of EE% diagram a)o*e5 if there are 100 instances of Emplo/ee and 10 instances of ,anager5 then how man/ instances of ,anaged$/ m+st exist !" 0 $" 10 C" 100 (" 110 E" &one of the a)o*e
2. n the relational data model =not EE% diagrams" how man/ different t/pes of data str+ct+res exist !" 1 $" 2 C"
(" ,ore than E" &one of the a)o*e 24. Which of the following statements is tr+e !" -he *al+e of a deri*ed attri)+te ma/ )e determined from related entities $" -he 'e/ of an entit/ t/pe can not )e a composite attri)+te C" ! wea' entit/ t/pe cannot ha*e a m+lti*al+ed attri)+te (" !ll of the a)o*e are tr+e E" &one of the a)o*e 2. Consider entit/ t/pes E15 E2 and E 5 where E1 represents a s+)class of E2 5 and E2 represents a s+)class of E in a generali3ation;speciali3ation relationship in the EE% model. Which of the following statements is;are tr+e !" E 1 inherits attri)+tes onl/ from E2 $" E 1 inherits attri)+tes from E2 as well as from E C" E inherits attri)+tes from )oth E1 and E2 (" !ll of the a)o*e are tr+e E" &one of the a)o*e
