4 Jul 2014

Smu mba database management system sample paper set five



Question: ___________ involves the development of object model of the application domainResponse:
Object oreinted modeling
object oriented programming
Feedback:Not right answer. Refer section No. 14.2.3
object oriented design
Should have chosen
Object oriented analysis
Question: ____________ is a logic organization of the real world objects (entities), constraints put on them, and the relationships that exits among objects.Response:
object oreinted language
data flow diagram
Correct
data model
Feedback:Right Answer
object orineted design
Question: _______________are those that are formed from the simpler objects by applying methods to them.Response:
instances
relataional objects
integrated database
Feedback:Not right answer. Refer section No. 14.3.2
Should have chosen
Complex objects
Unit-14-2mark
Question: which of the followign are the advantages of inheritance?Response:
faster and easy data flow
Correct
abstraction and reuse mechanism
Feedback:Right Answer
easier maintance and mapping function
consistency and nonredundant
Question: ______________ and _______________ are the applications of ODBMSResponse:
DSS and CAD
Feedback:Not right answer. Refer section No. 14.4
Decision making and analysis
AI and Expert systems
Should have chosen
CAD and evolutionary
Question: the properties of hieracrhcial database are ____________ and ________Response:
more relationships and better versioning
better simulation and more databases
Should have chosen
concurrency and recovery
more relliability and multiple views
Feedback:Not right answer. Refer section No. 14.4.1
Unit-13-4mark
Question: Match the followingResponse:
Match
Correct Answer
User answer
Feedback

Match
Correct Answer
User answer
Feedback
Horizontal Fragmentation
Create subsets of tuples
Improves performance of retrieval for global queries
incorrect
Vertical Fragmentations
Collection of certain attributes of the relation
Create subsets of tuples
incorrect
Data Replication
Improves performance of retrieval for global queries
Collection of certain attributes of the relation
incorrect
Data allocation
Fragment must be assigned to a particular site
Fragment must be assigned to a particular site
correct
Question: Match the followingResponse:
Match
Correct Answer
User answer
Feedback

Match
Correct Answer
User answer
Feedback
Client
Machine running the front end application
Techniques that are used to break up the database
incorrect
Server
Machine that runs the DMS software
Enables remote data access through client server and server-to-server communication
incorrect
Network
Enables remote data access through client server and server-to-server communication
Machine running the front end application
incorrect
fragments
Techniques that are used to break up the database
Machine that runs the DMS software
incorrect
Unit14-1mark
Question: __________is defined by giving a type name and later listing the names of its visible (public) functions.Response:
tuple
attribute
Correct
type
Feedback:Right Answer
row
Question: _____________are abstractions of real world entities and manage themselves.Response:
attributes
schema
Correct
Objects Right Answer
instance
Question: _______________ can be used to explain how the software design may be represented as a set of interacting objects that manage their own state and behaviors.Response:
Should have chosen
object oriented database
data mart
network diagram
Feedback:Not right answer. Refer section No.14.2
data flow diagram

No comments:

Post a Comment