All Final Exams True False MCQ

(1)

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage11 of of3232 Contents

Contents

CS490 Fall 2006 Final

CS490 Fall 2006 Final ...22..

Part I, True

Part I, True//False QuestionsFalse Questions::

...

22

Part II, Multiple Choice Q

Part II, Multiple Choice Questionsuestions::

...

22

CS490 Spring 2006 Final

CS490 Spring 2006 Final ...44

Part I, True

...

....

55

Part II, Multiple Choice Questions

Part II, Multiple Choice Questions::

...

55

CS490 Fall 2007 Final ...77..

Part I, True

Part I, True//False QuestionsFalse Questions ::

...

77

...

88

Q

QUIZUIZ --FFALLALL20062006//20072007 ...1010

Part I

Part I : :TrueTrue//False QuestionsFalse Questions..

...

..

1010

Part II Multiple Choice

Part II Multiple Choice..

...

1010

Part I, True

...

..

1111

...

1212

CS490 Summer 2007 Final

CS490 Summer 2007 Final ...1414

Part I, True

...

..

1414

...

1414

CS490 Fall 2008 Final ...1818

Part I, True

...

..

1818

...

1919

Part I, True

...

..

2121

...

2222

CS490 Fall 2009 Final ...2424

Part I, True

...

..

2424

...

2525

Part I, True

...

..

2727

...

2828

(2)

Trusted by over 1 million members

Try Scribd FREE for 30 days to access over 125 million titles without ads or interruptions! Start Free Trial

Cancel Anytime.

(3)

Cancel Anytime.

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage22 of of3232 CS490 Fall 2006 Final

CS490 Fall 2006 Final Part I, True

1

1 . .PropertiesProperties of an object are stored as rows in a table of an object are stored as rows in a table . .FalseFalse 2

2 . .It isIt isnot possiblenot possible to access data stored in a to access data stored in a databasedatabase using a program written in using a program written inVisual BasicVisual Basic or orCOBOLCOBOL.. FalseFalse

3

3 . .De Morgan's LawDe Morgan's Law is used is used to simplify complexto simplify complexconstraintsconstraints.. True True

4

4 . .DBMSDBMS stores data efficiently with little stores data efficiently with little wasted spacewasted space.. True True

5

5 . .If a table is inIf a table is in1NF1NF and does not have a composite key, then it is in and does not have a composite key, then it is in 2NF2NF.. True True

6

6 . .AAprimary goalprimary goal of a database system is to of a database system is toshare datashare data with multiple users with multiple users.. True True

7

7 . .MultipleMultipleconstraintsconstraints can be included in a can be included in a single querysingle query ..TrueTrue

8

8 . .Specifying an asteriskSpecifying an asterisk )*()*(for for the association multiplicity on a class diagram indicates that the itthe association multiplicity on a class diagram indicates that the it em is requiredem is required.. False

False 9

9 . .Specifying aSpecifying azerozero ))00((for thefor thelower boundlower bound for t for the association multiplicity on a class diagram indicates that the itemhe association multiplicity on a class diagram indicates that the item is required

is requiredFalseFalse 10

10 . .SQLSQLdoes notdoes not allow you to use the same table in a subquery as is being used in the outer query allow you to use the same table in a subquery as is being used in the outer query((ii..ee.., the query that, the query that includes the subquery

includes the subquery.).) FalseFalse 11

11 . .If a table is in 3NF, it If a table is in 3NF, it is also in 2N`Fis also in 2N`F.. True True

12

12 . .TheTheprimaryprimary key does key doesnotnot necessarily have to be necessarily have to beuniqueunique for a given table for a given table.. FalseFalse 13

13 . .AAsubquerysubquery uses the same syntax as a regular query uses the same syntax as a regular query.. True True

14

14 . .ProceduralProcedural code is often placed within forms and reports code is often placed within forms and reports..TrueTrue

15

15 . .AAViewView is a is asaved query..saved query True True

16

16 . .If you use aIf you use aGROUP BYGROUP BY command, you cannot see the command, you cannot see thenonnon--aggregatedaggregated data in the same query data in the same query.. True True

17

17 . .Including theIncluding theDISTINCTDISTINCT operator in a query will always result it operator in a query will always result itless than or equalless than or equal to the number of records to the number of records retuned when the

retuned when theDISTINCTDISTINCT operator is not used operator is not used..TrueTrue

18

18 . .A bad choice for a A bad choice for a primary key for the university's student database is the primary key for the university's student database is the student phone number student phone number .. TrueTrue

19

19 . .The employeeThe employee --manager association is an example of manager association is an example of a reflexive relationshipa reflexive relationship TrueTrue

20

20 . .Specifying a oneSpecifying a one((11 ) )for the lower bound forthfor the lower bound forth association multiplicity on a class diagram indicates that the item isassociation multiplicity on a class diagram indicates that the item is required

required.. True True

Part II, Multiple Choice Questions Part II, Multiple Choice Questions:: 21

21 . .When creating a query, what is the purpose of assigning a table Alias?When creating a query, what is the purpose of assigning a table Alias?

A

A ) )To prevent correlated sub queriesTo prevent correlated sub queries B

B ) )The real name is not knownThe real name is not known C

C ) )To distinguish between two instances of the To distinguish between two instances of the same tablesame table D

D ) )To maintain anonymTo maintain anonymityity

22

22 . .The database design that uses a The database design that uses a hierarchical data structure, but incorporates multiple data entry hierarchical data structure, but incorporates multiple data entry points ispoints is called a ______

called a ______ ..

A

A ) )Object oriented databaseObject oriented database B

B ) )Hierarchical databaseHierarchical database C

C ) )Relational databaseRelational database

(4)

Cancel Anytime.

(5)

Cancel Anytime.

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage33 of of3232 24

24 . .The fields in one table that 1i11k to the The fields in one table that 1i11k to the primary key in another table are called primary key in another table are called ____________ ..

A

A ) )metadata metadata BB ) )composite key composite key CC ) )dependent dependent key key DD ) )foreign keyforeign key

25

25 . .The purpose of an NThe purpose of an N--Ary association is ______Ary association is ______ ..

A

A ) )To deal with relationships that involves more than two tablesTo deal with relationships that involves more than two tables B

B ) )to capture a parentto capture a parent--child relationshipchild relationship C

C ) )to represent an inheritance relationshipto represent an inheritance relationship D

D ) )to deal with one to many relationshipsto deal with one to many relationships

26

26 . .What is the purpose of the SQL operator IN?What is the purpose of the SQL operator IN?

A

A ) )Specifies that the sort order should Specifies that the sort order should be increasingbe increasing

B

B ) )Used to test if one value appears in a Used to test if one value appears in a set of valuesset of values C

C ) )Indicates which table each field can be foundIndicates which table each field can be found D

D ) )Used in the GROUP BY statement to Used in the GROUP BY statement to indicate subindicate sub--groupsgroups

27

27 . .A table on the many side of a A table on the many side of a one to many or many to many relationship must______one to many or many to many relationship must______ ..

A

A ) )Be in Third Normal Form (3NF)Be in Third Normal Form (3NF)

B

B ) )have a composite keyhave a composite key C

C ) ) be in domain be in domain--key normal formkey normal form((DKNFDKNF))

D

D ) ) be in Boyce be in Boyce--Codd Normal FormCodd Normal Form((BCNFBCNF)) 28

28 . .Which of the following is an example where an Online Transaction Processing system would not be used?Which of the following is an example where an Online Transaction Processing system would not be used?

A

A ) )Clerk recording your purchases at tClerk recording your purchases at the grocery checkouthe grocery checkout B

B ) )Checking the current order statusChecking the current order status C

C ) )The inventory warehouse pulling parts to till The inventory warehouse pulling parts to till an orderan order D

D ) )None of the aboveNone of the above . .All of the All of the above applications would use Online Transaction Processingabove applications would use Online Transaction Processing..

29

29 . .The process that stores copies of a table and stores it iThe process that stores copies of a table and stores it in several different locations at the same time n several different locations at the same time is calledis called ______ ?

______ ?

A

A ) )Partitioning Partitioning BB ) )Segmentation Segmentation CC ) )Data Data mirroring mirroring DD ) )ReplicationReplication

30

30 . .The definition of primary and foreign key relationships are set using SQL ______The definition of primary and foreign key relationships are set using SQL ______ ..

A

A ) )Keys Keys BB ) )Assignments Assignments CC))Rules Rules DD ) )ConstraintsConstraints

31

31 . .Advantages of a DBMS include all but which of the following?Advantages of a DBMS include all but which of the following?

A

A ) )Ease of Ease of application application developmdevelopment ent BB ) )Data IndependenceData Independence C

C ) )Uniform security, Uniform security, privacy privacy and and integrity integrity DD ) )DecentralizedDecentralized administration of the data administration of the data

32

32 . .What is the impact of not including a What is the impact of not including a JOIN command when using multiple tables in a query?JOIN command when using multiple tables in a query?

A

A ) )The primary keys in each table are joined togetherThe primary keys in each table are joined together B

B ) )The query will not workThe query will not work --an error is generatedan error is generated C

C ) )The foreign keys in each table are linked tThe foreign keys in each table are linked t o the primary keys in o the primary keys in the other tablesthe other tables D

D ) )All records in each table are All records in each table are associated with all records in the other tablesassociated with all records in the other tables

33

33 . .How does an outer join differ from an inner join?How does an outer join differ from an inner join?

A

A ) )Inner joins involve only one Inner joins involve only one table while an outer join table while an outer join involves multiple tablesinvolves multiple tables..

B

B ) )Inner joins are processed with the irmer most Inner joins are processed with the irmer most commcommand first, while tand first, while the outer join processes the outer mosthe outer join processes the outer most command first

command first.. C

C ) )Inner joins only connects records that have matching values in each table, where as an outer join iInner joins only connects records that have matching values in each table, where as an outer join includesncludes

records without a match in the other table

records without a match in the other table D

D ) )Inner joins connect tables within the database while outer joins Inner joins connect tables within the database while outer joins forms a connect to a tforms a connect to a table outside the databaseable outside the database



(6)

Cancel Anytime.

(7)

Cancel Anytime.

CS490

35 . .What is the purpose of the serialization process?What is the purpose of the serialization process?

A

A ) )Forces the operations within a transaction to be Forces the operations within a transaction to be run in a run in a specific, predefspecific, predefined sequenceined sequence B

B ) )In a twoIn a two-- phase com phase commit schememit scheme, it ensures tha, it ensures that everyone hat everyone has obtained locks s obtained locks on resources on resources before combefore committing to themitting to the change

change..

C

C ) )Allocates access time to the Allocates access time to the database to make sure it is database to make sure it is fairfair D

D ))Forces transactions to run separately so Forces transactions to run separately so that result consistency is maintainedthat result consistency is maintained

36

36 . .If indexes speed data retrieval, then why don't we index all fields in If indexes speed data retrieval, then why don't we index all fields in a database?a database?

A

A ) )It would take a lot of disk spaceIt would take a lot of disk space B

B ) )The overhead of maintaining the index may outweigh the benefits derivedThe overhead of maintaining the index may outweigh the benefits derived.. C

C ) )This is actually commonly done in industryThis is actually commonly done in industry..

D

D ) )Indexing some fields would violate data integrity constraintsIndexing some fields would violate data integrity constraints

37

37 . .With regards to system maintenance, what is With regards to system maintenance, what is the purpose of defining database roles?the purpose of defining database roles?

A

A ) )Decision Support Systems will have Decision Support Systems will have different operational characterisdifferent operational characteristics than Expert tics than Expert SystemsSystems B

B ) )Simplifies the assignment of access privileges by creating logical groups with consistent access needsSimplifies the assignment of access privileges by creating logical groups with consistent access needs C

C ) )Categorizes the Categorizes the purpose and administrative requirempurpose and administrative requirements of ents of the databasethe database D

D ) )Defining database roles helps in Defining database roles helps in the system development processthe system development process

38

38 . .What is metadata?What is metadata?

A

A ) )The specifics about the DBMSThe specifics about the DBMS((ii..ee.., publisher, version number, copyright information, etc, publisher, version number, copyright information, etc).).

B

B ) )Operational metrics dealing with the Operational metrics dealing with the databasedatabase((ii..ee.., number of users, average response time, number of records, number of users, average response time, number of records accessed, etc

accessed, etc).).

C

C ) )Database information that is Database information that is made available on the intenetmade available on the intenet..

D

D ) )Descriptive information about the data stored in Descriptive information about the data stored in the databasethe database

39

39 . .The type of form that displays data from two tables that have a oneThe type of form that displays data from two tables that have a one --toto--many relationship is called a ______many relationship is called a ______ ..

A

A ) )Referential form Referential form BB ) )relational relational form form CC )subform )subform DD ) )crosstab formcrosstab form

40

40 . .The most popular distributed database configuration, where usersThe most popular distributed database configuration, where users ((typically using desktop computerstypically using desktop computers ) ) request and receive data from a powerful computer is c

request and receive data from a powerful computer is called _______alled _______ ..

A

A ) )File File server server system system BB ) )Terminal Terminal system system CC )Client )Client / /server systemserver system DD ) )Local area networkLocal area network

As a reference, the following are the

As a reference, the following are the standard definitions of 1NF, 2NF, 3NF, and BCNF:standard definitions of 1NF, 2NF, 3NF, and BCNF:



A relation is in first normal form (A relation is in first normal form (1NF1NF) if ) if and only if all and only if all attributes are atomic.(Atomattributes are atomic.(Atomic attributes are single valued,ic attributes are single valued,

and cannot be

and cannot be composite, multi-valued or nested relations.)composite, multi-valued or nested relations.)



A relation is in A relation is in second normasecond normal form (l form (2NF2NF) if it is ) if it is in 1NF and each non-key attribute is fully functionally dependenin 1NF and each non-key attribute is fully functionally dependentt

on the primary key.



A relation is in third normal form (A relation is in third normal form (3NF3NF) if and only if ) if and only if it is in it is in 2NF and no non-key attributes are transitively2NF and no non-key attributes are transitively

dependent on the primary key.



A relation is in A relation is in Boyce-CoBoyce-Codd Normal Form (dd Normal Form (BCNFBCNF) if and only if ) if and only if it is in 3NF and every determinant is a candidateit is in 3NF and every determinant is a candidate

key (or K is a superkey).

47. The ultimate goal in

47. The ultimate goal in designing a database is to get all designing a database is to get all the tables into what the tables into what normal form?normal form? A)

A) First First Normal Normal Form Form B) B) Boyce Boyce Codd Codd Normal Normal FormForm C)

C) Dependency Dependency Free Free Normal Normal Form Form D)D)Domain Key Normal FormDomain Key Normal Form 48. Assume you want to

48. Assume you want to create a contact list, and include all your create a contact list, and include all your contact's phone numberscontact's phone numbers, which fall , which fall into differentinto different categories (i.e., home/work, primary/secondary

categories (i.e., home/work, primary/secondary/emergenc/emergency, mobile y, mobile /pager/voice/fa/pager/voice/fax). Not x). Not all contacts have all contacts have allall categories.

categories.The following Contact table is The following Contact table is in what normal form?in what normal form?

Contact

Contact ( (IDID, Name, Hphone1, Hphone2, Hfax1, Hfax2, MobilePhone, Pager, Wphone1, Wphone2, Wfax1, Wfax2,, Name, Hphone1, Hphone2, Hfax1, Hfax2, MobilePhone, Pager, Wphone1, Wphone2, Wfax1, Wfax2, EmergencyPhone)

(8)

Cancel Anytime.

(9)

Cancel Anytime.

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage55 of of3232

CS490 Spring 2006 Final

Part I, True

1

1 . .If a table doesIf a table does notnot have a have acompositecomposite key, then it is in key, then it is in2NF2NF ..TrueTrue

2

2 . .It is always possible to It is always possible to properly design a database and avoid usingproperly design a database and avoid usingcompositecomposite keys keys ..FalseFalse

3

3 . .The SQL keywordThe SQL keywordDISTINCTDISTINCT is used to indicate that an is used to indicate that anattributeattribute must have unique values in must have unique values in the original tablethe original table used in the query

used in the query.. False False rrow ow

4

4 . .AAsubtablesubtable is a just portion of is a just portion of aalargerlarger table table.. False False

5

5 . .From a Human Factors DesignFrom a Human Factors Design perspectiveperspective, it is good , it is good practice for forms to providepractice for forms to provideFeedback Feedback through visual, text, through visual, text, sound or a

sound or a combination of mediacombination of media.. True True

6

6 . .InInprocedural languagesprocedural languages the developer specifies what is to be done and the the developer specifies what is to be done and thesystem figuressystem figures out how to do it out how to do it.. False False

Database Managm

Database Managment Systement Systemss

7

7 . .It is possible to It is possible to change a method or proper1y inherited from a higher level change a method or proper1y inherited from a higher level classclass.. True True

8

8 . .AAtabulartabular form would be appropriate for a form would be appropriate for a banking application where you only want to banking application where you only want to display a single user'sdisplay a single user's record at one time

record at one time ..FalseFalse

9

9 . .AllAll data datatriggerstriggers only activate after a value in a row is changed only activate after a value in a row is changed.. False Falsesome some

10

10 . .All queries can be designed to avoidAll queries can be designed to avoid subqueriessubqueries.. False False

11

11 . .TheTherelational databaserelational database model is t model is the predominant method of storing data todayhe predominant method of storing data today..TrueTrue

12

12 . .TheTheSQL UPDATESQL UPDATE operation changes the table operation changes the tablestructurestructure while leaving the data i while leaving the data intactntact.. False False

13

13 . .In a university database, the normal multiplicity for a In a university database, the normal multiplicity for a relationship between courserelationship between courses and students would bes and students would beoneone to to many

many.. False False many many

14

14 . .The employeeThe employee --manager assocmanager association is an iation is an example of anexample of an inheritanceinheritance relationship relationship.. False Falsereflexivereflexiverelationshiprelationship

15

15 . .WHEREWHERE is is used to place a constraint on used to place a constraint on aggregaaggregated propertiested properties.. False FalseHaving Having

16

16 . .A View is a A View is a saved query and can be used in saved query and can be used in other queriesother queries.. True True

17

17 . .A singleA single--row form would be row form would be appropriate for a banking application where you only want appropriate for a banking application where you only want to display a single user'sto display a single user's record at one time

record at one time.. True True

18

18 . .The employeeThe employee --manager association is an example of manager association is an example of a reflexive relationshipa reflexive relationship.. True True

19

19 . .SQL is not a SQL is not a procedural languagprocedural languagee.. True True

20

20 . .A reflexive join means that a table is joined to itself A reflexive join means that a table is joined to itself .. True True Part II, Multiple Choice Questions

Part II, Multiple Choice Questions:: 21

21 . .Which of Which of the following types of isolation lthe following types of isolation levels provides the MOST protection against concurrencyevels provides the MOST protection against concurrency problems?

problems?

A

A ) )SERIALIZABLESERIALIZABLE BB ) )REPEATABLE READREPEATABLE READ C

C ) )READ COMMITTED READ COMMITTED DD ) )READ UNCOMMITTEDREAD UNCOMMITTED

22

22 . .Procedural code can often be placed in which of the follProcedural code can often be placed in which of the following?owing?

A

A ) )Only in Only in forms forms and and reports reports BB ) )Only in the Only in the query systemquery system C

C ) )Only in Only in external external programprograms s DD ) )All of the aboveAll of the above

23

23 . .Which of Which of the following isthe following is notnot one of the primary tasks of a one of the primary tasks of a query language?query language?

A

A ) )Define the structure of the databaseDefine the structure of the database B

B ) )Locate and retrieve data contained in Locate and retrieve data contained in the databasethe database C

C ) )Change and manage the information stored iChange and manage the information stored i n the n the databasedatabase D

(10)

Cancel Anytime.

(11)

Cancel Anytime.

CS490

26 . .When creating a query, what is the purpose of including a column Alias?When creating a query, what is the purpose of including a column Alias?

A

A ) )To To control control the the sort sort order order BB ) )To give the query designer control over the column nameTo give the query designer control over the column name C

C ) )To To maintain maintain anonymanonymity ity DD ) )The real name is not knownThe real name is not known

27

27 . .The tool which assists in generating input screens is referred to asThe tool which assists in generating input screens is referred to as ..

A

A ) )Input screen Input screen tool tool BB ) )data data dictionary dictionary CC ) )report report generator generator DD ) )forms generatorforms generator

28

A

A ) )Specifies that Specifies that the the sort sort order order should should be be increasing increasing BB ) )Used in the GROUP BY statement to Used in the GROUP BY statement to indicate subindicate sub--groupsgroups C

C ) )Used to test if one value appears in a Used to test if one value appears in a set of valuesset of values DD ) )Indicates which table each field can be foundIndicates which table each field can be found Assume that you are dealing with a

Assume that you are dealing with a database deadatabase dealing with a ling with a university curriculum and have created the table Scheduleuniversity curriculum and have created the table Schedule

to capture which instructor is teaching each course under the following business rules

to capture which instructor is teaching each course under the following business rules::

Schedule

Schedule((CourseNo, Discipline, Instructor CourseNo, Discipline, Instructor ))

Business rules

Business rules::

1

1 ) )CourseNo uniquely defines each course offeringCourseNo uniquely defines each course offering

2

2 ) )Faculty have a single Faculty have a single discipline areadiscipline area((ii..ee.., Finance, Marketing, or , Finance, Marketing, or Information SystemInformation Systemss)), and only teach classes, and only teach classes

in that area

3

3 ) )There are many faculty in each disciplineThere are many faculty in each discipline

4

4 ) )Students can have more than one faculty for Students can have more than one faculty for classes in a certain disciplineclasses in a certain discipline((you can have different instructors foryou can have different instructors for

Accounting l and Accounting 2

Accounting l and Accounting 2.).)

29

29 . .Assume you want to add student registration information to Assume you want to add student registration information to the database, capturing which student isthe database, capturing which student is enrolled in which course

enrolled in which course . .What is the best way to incorporate this data?What is the best way to incorporate this data?

A

A ) )Add another table with only Add another table with only two colurrms, CourseNo, StudentlD, which is then two colurrms, CourseNo, StudentlD, which is then associated with the Scheduleassociated with the Schedule

table

table B

B ) )Add another table with Student infonnation including all Add another table with Student infonnation including all courses they are takingcourses they are taking((ii..ee..,Student,Student((ID, Name, address,ID, Name, address,

((other personal information fieldsother personal information fields)), Coursel, Course2,, Coursel, Course2,...,CourseN,CourseN))

C

C ) )Add another table which list the Add another table which list the CourseNo, followed by a column for each studentCourseNo, followed by a column for each student((ii..ee..,CourseNo, Studentl,,CourseNo, Studentl, Student2, , StudentN

Student2, , StudentN))

D

D ) )Add a column in the schedule table for each studentAdd a column in the schedule table for each student((ii..ee.., CourseNo, Discipline,Instructor, Studentl, Student2, ,, CourseNo, Discipline,Instructor, Studentl, Student2, , StudentN

StudentN)) 30

30 . .Assume that you have a Customer table and an Order table, where Referential Integrity constraints requireAssume that you have a Customer table and an Order table, where Referential Integrity constraints require that a customer record be entered before an order

that a customer record be entered before an order can be enteredcan be entered . .Also Cascade on delete is enforcedAlso Cascade on delete is enforced . .If youIf you delete a Customer record, ______

delete a Customer record, ______ ..

A

A ) )The Customer id in the order table will be set The Customer id in the order table will be set to null for those records which previously referred to the now deletedto null for those records which previously referred to the now deleted customer

customer ..

B

B ) )The system will prevent you from deleting the The system will prevent you from deleting the customecustomer until r until the orders placed by that customer are deleted first bythe orders placed by that customer are deleted first by the user

the user ..

C

C ) )Orders by that customer will be deletedOrders by that customer will be deleted.. D

D ) ) Nothing will happen to Nothing will happen to the order tablethe order table((it will be unchangedit will be unchanged.).) 31

31 . .Assume you are creating a Assume you are creating a database to handle the data database to handle the data associated with assembling PCs from componentsassociated with assembling PCs from components ((The PC itself is not considered a cThe PC itself is not considered a componentomponent .) .)What is the most appropriate special association to model theWhat is the most appropriate special association to model the PCS' makeup

PCS' makeup ((for example, motherboard,case, power supply, hard disk drive, CD for example, motherboard,case, power supply, hard disk drive, CD reader, monitor,reader, monitor, ...etcetc ). ).??

A

A ) )Reflexive association Reflexive association BB ) )composition associationcomposition association C

C ) )generalization generalization association association DD ) )nn--ary associationary association

32

32 . .The type of form that displays data from two tables that have The type of form that displays data from two tables that have a onea one--toto--many relationship is called a ______ many relationship is called a ______ ..

A

(12)

Cancel Anytime.

(13)

Cancel Anytime.

CS490

35 . .After conceptually designing your database, the information contained in a After conceptually designing your database, the information contained in a single class would normally besingle class would normally be stored in a ______

stored in a ______ ..

A

A ) )Field Field BB ) ) property property CC ) )tabletable DD ) )databasedatabase

36

36 . .The purpose of am NThe purpose of am N--ary Association isary Association is

A

A ) )to to deal deal with with one one to to many many relationships relationships BB ) )to represent an inheritance relationshipto represent an inheritance relationship C

C ) )to capture a parentto capture a parent--child child relationship relationship DD ) )to deal with relationships that involve more than two tablesto deal with relationships that involve more than two tables

37

37 . .A hidden dependency exists if A hidden dependency exists if ______ ______ ..

A

A ) )the the defining defining and and dependent dependent columns columns are are in in the the same same table table BB ) )there is no composite key definedthere is no composite key defined C

C ) )the dependency is not explicitlythe dependency is not explicitly captured in a tablecaptured in a table DD ) )there is no foreign key definedthere is no foreign key defined

38

38 . .In a database context, what is In a database context, what is a transaction?a transaction?

A

A ) )Any process which either accesses or changes the contents of one or more records in a databaseAny process which either accesses or changes the contents of one or more records in a database B

B ) )Any interaction with the Any interaction with the databasedatabase((insertion, deletion, update, creation of new tables, etcinsertion, deletion, update, creation of new tables, etc).).

C

C ) )A set of changes that must all be made togetherA set of changes that must all be made together D

D ) )Any database action that involves the exchange of information between two users of Any database action that involves the exchange of information between two users of the databasethe database

39

39 . .Human factors design research has found all Human factors design research has found all of the following important factors to of the following important factors to consider when buildingconsider when building forms and reports EXCEPT which of

forms and reports EXCEPT which of the following?the following?

A

A ) )Confirmation of Confirmation of deletions deletions and and changes changes to to existing existing data data BB ) )Integrated feedback in response to Integrated feedback in response to user actionsuser actions C

C ) )Support of multiple operating systemsSupport of multiple operating systems DD ) )Ability to Ability to customize form to user's preferencecustomize form to user's preference

40

40 . .Direct manipulation of objects is a Direct manipulation of objects is a consequence of what advancement in computer systemsconsequence of what advancement in computer systems ..

A

A ) )Increase emphasis of graphical user iIncrease emphasis of graphical user interfacesnterfaces BB ) )The world wide webThe world wide web C

C ) )Faster and Faster and more more poweriiil poweriiil processors processors DD ) )Increased connectivity through networksIncreased connectivity through networks

CS490 Fall 2007 Final

Part I, True

1

1 . .AllAllqueriesqueries can be designed to avoid can be designed to avoidsubqueriessubqueries ..FalseFalse 2

2 . .If you use aIf you use aGROUPGROUP BY command, you cannot see the BY command, you cannot see the non--aggregatednon aggregated data in t data in the same queryhe same query..TrueTrue

3

3 . .To use the SQLTo use the SQLHAVINGHAVING keyword you must also use the keyword you must also use theGROUP BYGROUP BY keyword keyword.. True True

4

4 . .TheThe relational databaserelational database model is the model is thepredominantpredominant method of storing data todaymethod of storing data today.. True True

5

5 . .It is possible to use aIt is possible to use a WHEREWHERE if the query contains a if the query contains aGROUPGROUP BYBY.. True True

6

6 . .Network databaseNetwork database systemssystems tend to be more flexible in their ability to tend to be more flexible in their ability to access data thanaccess data thanHierarchicalHierarchical database database



 

(14)

Cancel Anytime.

(15)

Cancel Anytime.

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage88 of of3232

18

18 . .The solution to the The solution to the problems creaproblems created with ated with acorrelated subquerycorrelated subquery is to is to referencereference previously previously--saved data rather usesaved data rather use aa subquerysubquery.. True True

19

19 . .It isIt isalwaysalways possible to properly design a possible to properly design a database and avoid using composite keysdatabase and avoid using composite keys.. False False 20

20 . .It is aIt is agood ideagood idea to to wait until data is wait until data is entered into the database before normalizing the tablesentered into the database before normalizing the tables False False..

21

21 . .AAgood choicegood choice for a for a primary key for the university's student database is the student primary key for the university's student database is the student phone number phone number .. False False 22

22 . .If a table does not have aIf a table does not have a compositecomposite key, then it is in key, then it is in2NF2NF.. False False 23

23 . .Specifying aSpecifying azerozero((00 ) )for thefor thelower boundlower bound for the for the association multiplicity on a class diagram indicates that theassociation multiplicity on a class diagram indicates that the item is required

item is required.. False False 24

24 . .Database systemDatabase systems are traditionally designed ts are traditionally designed to support theo support theindividual userindividual user((inin contrast to multiplecontrast to multiple, simultaneous, simultaneous users

users.).) False False 25

25 . .TheTheprimaryprimary keykey must be must beuniqueunique for a given for a given tabletable.. True True Part II, Multiple Choice Questions

Part II, Multiple Choice Questions:: 26

26 . .To implement a join where records in two tables are To implement a join where records in two tables are linked based on one value falling within a range oflinked based on one value falling within a range of values rather than exactly matches between the two tables, you would use a

values rather than exactly matches between the two tables, you would use a ((nn ) ) ________________ ________________ . .

A

A ) )Outer Join Outer Join BB ) )EquiEqui--Join Join CC ) )Reflexive Reflexive Join Join DD ) )InequalityInequality Join Join

27

27 . .The primary difference between the Relational Data The primary difference between the Relational Data BaseBase ((RDBRDB ) )and Object Oriented Data Baseand Object Oriented Data Base ((OODBOODB ) ) models is

models is ____________________________________ ____ . .

A

A ) )OODB supports multiple objects in the same database while RDB only supports OODB supports multiple objects in the same database while RDB only supports a single table per a single table per databasedatabase B

B ) )RDB supports indexes, while OODB does not support indexesRDB supports indexes, while OODB does not support indexes C

C ) )OODB incorporates methods in with the definition of the data structure, while RDB does notOODB incorporates methods in with the definition of the data structure, while RDB does not D

D ) )RDB allows the definition of RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships between the different tables, while OODB does not allow thethe relationships to be

relationships to be defined between objectsdefined between objects

28

28 . .The modern database report The modern database report writer __________________ writer __________________ . . A

A ) )provides the tools for database designer to display information in the desired formatprovides the tools for database designer to display information in the desired format B

B ) ) provides the tools provides the tools for the databafor the database administrator se administrator to monitor and repto monitor and report on databaort on database use and ase use and activityctivity C

C ) ) provide limited c provide limited control over how inontrol over how information is displaformation is displayed and repyed and reportedorted..

D

D ) )is a career path that focuses on creating, managis a career path that focuses on creating, managing and supporting ting and supporting t he reports generated from databasehe reports generated from databasess

29

29 . .Not all queries can be constructed in a single Not all queries can be constructed in a single SELECT statementSELECT statement . .They have to be built up They have to be built up using the resultsusing the results of one query as building blocks for the larger

of one query as building blocks for the larger queryquery . .What is the term used for these What is the term used for these smaller queries that aresmaller queries that are integrated together to build the final query?

integrated together to build the final query?

A

A ) )Query By Query By Example Example BB ) )SubSub--Schema Schema CC ) )SchemaSchema DD ) )SubquerySubquery

30

30 . .How does an outer join differ from an inner join?How does an outer join differ from an inner join?

A

A ) )Inner joins involve only one Inner joins involve only one table while an outer join table while an outer join involves multiple tablesinvolves multiple tables.. B

B ) )Inner joins only connects records that have matching values in each table, where as an outer join Inner joins only connects records that have matching values in each table, where as an outer join includesincludes



(16)

Cancel Anytime.

(17)

Cancel Anytime.

CS490

CS490_–_– All Final Exams T All Final Exams T//FF --MCQ SolutionsMCQ Solutions PagePage99 of of3232 C

C ) )ensure that foreign keys can be entered only if ensure that foreign keys can be entered only if the corresponding value exists in the originating tablethe corresponding value exists in the originating table D

D ) )ensure that values entered for ensure that values entered for a certain propertya certain property((ii..ee.., table column, table column ) )are appropriateare appropriate

34

34 . .What is the benefit of using a query language rather than a What is the benefit of using a query language rather than a natural language to get information out of anatural language to get information out of a database?

database?

A

A ) )Query languages are more flexible than Query languages are more flexible than natural languagenatural language B

B ) )There is no benefit of query languages over natural languagThere is no benefit of query languages over natural languages for getting es for getting information out of a databaseinformation out of a database..

C

C ) )Query languages allow the user to pose unstructured, open ended queriesQuery languages allow the user to pose unstructured, open ended queries

D

D ) )Query languages are more precise so there is Query languages are more precise so there is less room for misinterpretationless room for misinterpretation

35

35 . .Which SQL command would you use to match field values to a template valueWhich SQL command would you use to match field values to a template value ((ii..ee.., finding all customers, finding all customers with a last name starting with “G”

with a last name starting with “G”))??

A

A ) )MASK MASK BB ) )STARTS WITHSTARTS WITH CC ) )LIKELIKE DD ) )HAVINGHAVING

36

36 . .The ability to modify the data structure and not have to change the The ability to modify the data structure and not have to change the programs using that data is calledprograms using that data is called _____________________

_____________________ . .

A

A ) )data integrity data integrity BB ) )data data dictionary dictionary CC ) )referentiareferential l integrityintegrity DD ) )data independencedata independence

37

37 . .The role of the query system is to The role of the query system is to ________________________________ ____ . .

A

A ) )support data integritysupport data integrity BB ) )retrieve and manipulate dataretrieve and manipulate data C

C ) ) present the da present the data in a user frta in a user friendly format iendly format DD ) ) provide data security provide data security

38

A

A ) )Specifies that the sort order should Specifies that the sort order should be increasingbe increasing B

B ) )Used in the GROUP BY statement to Used in the GROUP BY statement to indicate subindicate sub--groupsgroups

C

C ) )Used to test if one value appears in a Used to test if one value appears in a set of valuesset of values D

D ) )Indicates which table each field can be foundIndicates which table each field can be found

39

39 . .The command that indicates that a The command that indicates that a transaction has successfully completed and that changes must now transaction has successfully completed and that changes must now bebe made permanent is

made permanent is : : _________ _________ . . A

A ) )COMMITCOMMIT BB ) )END END TRANSACTION TRANSACTION CC ) )EXECUTE EXECUTE DD ) )UPDATEUPDATE

40

40 . .What is the special association that indicates that one object can be broken down into multiple specialWhat is the special association that indicates that one object can be broken down into multiple special cases?

cases? A

A ) )generalization associationgeneralization association BB ) )nn--ary associationary association C

C ) )reflexive association reflexive association DD ) )composition composition associationassociation

41

41 . .When creating a query, what is the purpose of including a column Alias?When creating a query, what is the purpose of including a column Alias?

A

A ) )To To control control the the sort sort order order BB ) )To maintain anonymityTo maintain anonymity C

(18)

Cancel Anytime.

(19)

Cancel Anytime.

CS490

46 . .Assume you want to create a contact list, and include all your contact's phone numbers, which fall intoAssume you want to create a contact list, and include all your contact's phone numbers, which fall into different categories

different categories ((ii..ee.., home, home//work, primarywork, primary//secondarysecondary//emergency, mobileemergency, mobile//pagerpager//voicevoice//faxfax .) .)Not all contactsNot all contacts have all categories

have all categories..The following Contact table is in what normal form? ContactThe following Contact table is in what normal form? Contact ((ID, Name, Hphone1,ID, Name, Hphone1, Hphone2, Hfax1, Hfax2,

Hphone2, Hfax1, Hfax2, MobilePhone, MobilePhoneCompany, Pager, Wphone1, Wphone2, Wfax1, Wfax2,MobilePhone, MobilePhoneCompany, Pager, Wphone1, Wphone2, Wfax1, Wfax2, EmergencyPhone

EmergencyPhone))

A

A ) )First Normal First Normal only only BB ) )First, Second & third Normal FormFirst, Second & third Normal Form C

C ) )Second Normal Form onlySecond Normal Form only DD ) )First & Second Normal FormFirst & Second Normal Form

47

47 . .Assume that you have a Customer table and an Order table, where Referential Integrity constraints requireAssume that you have a Customer table and an Order table, where Referential Integrity constraints require that a customer record be entered before an order

that a customer record be entered before an order can be enteredcan be entered . .Also Cascade on delete is enforcedAlso Cascade on delete is enforced . .If youIf you delete a

delete a Customer record, ______________ Customer record, ______________ ..

A

A ) )the system will prevent you from deleting tthe system will prevent you from deleting the customer until the orders placed by that he customer until the orders placed by that customecustomer are deleted first r are deleted first byby the user

the user ..

B

B ) )nothing will happen to the order tablenothing will happen to the order table((it will be unchangedit will be unchanged)) C

C ) )orders by that customer will be deletedorders by that customer will be deleted D

D ) )the Customerid in the order table will be set to null the Customerid in the order table will be set to null for those records which previously refefor those records which previously referred to the now deletedrred to the now deleted customer

customer

48

48 . .if you wanted to include a signature block at the very if you wanted to include a signature block at the very end of a report, this would be plaend of a report, this would be placed in theced in the

A

A ) )Appendix object Appendix object BB ) )footer footer CC ) )Page Page footer footer DD ) )Report footerReport footer

49

49 . .What is the special association that combines different items from multiple classes to build a new object?What is the special association that combines different items from multiple classes to build a new object?

A

A ) )Reflexive association Reflexive association BB ) )nn--ary associationary association

C

C ) )composition associationcomposition association DD ) )generalizageneralization tion associationassociation

50

50 . .When creating a query, what is the purpose of assigning a table Alias?When creating a query, what is the purpose of assigning a table Alias?

A

A ) )To To maintain maintain anonymanonymity ity BB ) )To prevent correlated sub queriesTo prevent correlated sub queries

C

C ) )To distinguish between two instances of the To distinguish between two instances of the same tablesame table DD ) )The real name is not knownThe real name is not known

Q

QUIZUIZ --FFALLALL20062006//20072007

Part I

:

True

/

False Questions

.

1

1..The process of determining the proper tables for a The process of determining the proper tables for a database is called Organizadatabase is called Organizationtion..FalseFalse

2

2..A primary key can point to A primary key can point to more than one objectmore than one object..TrueTrue 3

3..Surrogate key is useful when there is Surrogate key is useful when there is some uncertainty with the business keysome uncertainty with the business key.. True True 4

(20)

Cancel Anytime.

(21)

Cancel Anytime.

CS490

10 ..Joining tables usingJoining tables usinginner joininner join statement causes statement causes A

A ((All rows from both joined table to appearAll rows from both joined table to appear B

B ((Matched rows based on the columns in the Matched rows based on the columns in the Join statementJoin statement C

C ((Matched rows based on the columns in the Join statement plus all the rows from the table on tMatched rows based on the columns in the Join statement plus all the rows from the table on t he righthe right D

D ((Matched rows based on the columns in the Join statement plus all the rows from the Matched rows based on the columns in the Join statement plus all the rows from the table on the lefttable on the left

11

11 ..Assume you want to create a contact list, and Assume you want to create a contact list, and include all your contact’s phone numbers, which fall into include all your contact’s phone numbers, which fall into differentdifferent categories

categories((ii..ee.., home, home//work, primarywork, primary//secondarysecondary//emergency, mobileemergency, mobile// pager pager //voicevoice//faxfax .) .) Not all contacts Not all contacts have allhave all categories

categories . .The following Contact table is in The following Contact table is in what normal form?what normal form?

Contact

Contact(( IDID, Name, Hphone1, Hphone2, Hfax1, Hfax2, MobilePhone, Pager, Wphone1, Wphone2, Wfax1, Wfax2,, Name, Hphone1, Hphone2, Hfax1, Hfax2, MobilePhone, Pager, Wphone1, Wphone2, Wfax1, Wfax2, EmergencyPhone

EmergencyPhone))

A

A ((First Normal First Normal only only BB((Second Normal Form onlySecond Normal Form only C

C ((First & Second Normal FormFirst & Second Normal Form DD((First, Second First, Second & third N& third Normal Formormal Form

12

12 ..DeMorgan’s Law compound statements are _________________ DeMorgan’s Law compound statements are _________________ A

A ((Connected using Connected using AND AND instead instead of of OR OR BB(( Negated by Negated by reversing eareversing each item and ch item and swapping conneswapping connectorsctors C

C((Uses Uses Where Where and and Having Having DD((None of the aboveNone of the above

CS490 Spring 2007 Final CS490 Spring 2007 Final

Part I, True

/

False Questions

:

1

1 . .AAcolumnarcolumnar Form presents the data in Form presents the data in a form similar to a a form similar to a spreadsheespreadsheett..FalseFalsedatasheet datasheet

2

2 . .The UNION command combines rows of data from two tablesThe UNION command combines rows of data from two tables..he basic version of the he basic version of the commcommand will and will notnot automatically eliminate duplicate rows of data

automatically eliminate duplicate rows of data.. False False 3

3 . .InIncompositioncomposition, a part can have a maximum of one whole, a part can have a maximum of one whole..TrueTrue

4

4 . .AllAllviewsviews can be used exactly like t can be used exactly like tables in any retrieval or update queryables in any retrieval or update query.. False False 5

5 . .Page headersPage headers can be defined for both reports and forms can be defined for both reports and forms.. False False 6

6 . .AAtable aliastable alias is a way to change table names for presentation purposes in reports only but is not essential to answer is a way to change table names for presentation purposes in reports only but is not essential to answer any type of query

any type of query ..

7

7 . .When two or more columns need to be matched, simply expand theWhen two or more columns need to be matched, simply expand theON statementON statement by listing all column by listing all column connections and connecting the statements with an

connections and connecting the statements with an ANDAND.. True True

8

8 . .AbstractAbstract data types and data types and subsub--tablestables are relational features that are related to are relational features that are related to thetheobjectobject--orientedoriented approach approach.. True True

9

9 . .IndexesIndexes improve the performance for both improve the performance for bothretrievalretrieval and andupdateupdate queries queries.. False False 10

10 . .AArelationrelation that has a that has a compositecomposite primaryprimary key cannot be in 2NF key cannot be in 2NF.. False False 11

(22)

Cancel Anytime.