4 Jul 2014

Smu mba database management system sample paper set one










Question: This is one of the type of database users.  VVimp Response:
Should have chosen
Database designer
Software engineer
Hardware engineer
System admin
Question: Tools are the ___________ optional software packages optional packages which are not available with the DBMS.Response:
Second party
First party
Should have chosen
Third party
Fourth party
Question: These are Design Driven. VVImp.Response:
Database Managemnt Systems
Mangaement Information Systems
Centralized systems
Should have chosen
File systems
Question: These are the system administration personnel that are responsible for the actual running and maintenance of the hardware and software environment for the DB system. VImp.Response:
Tool developers
Should have chosen
Operators and Maintenance personnel
Database administrators
Designers
Question: This can store pictures, video clip & sound messagesResponse:
File systems
Should have chosen
Multimedia datatbases
Graphics
Centralized database system
Question: __________ is one of the many primary resources that are used by many people in an organization.Response:
Files
Attachments
Should have chosen
Databases
Software
Question: __________ is responsible for creating, modifying & maintaing the databases.Response:
Database designer
System analysts
Tool developers
Should have chosen
Database administrators
Question: Traditional File system keeps ____________ information in many locationsResponse:
Consistent
Errored
Should have chosen
Redundant
Non redundant
Question: __________ DBMS must allow the data to be shared by multiple users simultaneously.Response:
Should have chosen
Multiuser
Single user
dual user
End user

MI0034Unit-01-1Mark
Question: A Database designer should ___________ the database.Response:
Extract
Correct
Design
Modify
Create
Question: A database is a _________ collection of data having some implicit meaning.Response: Imp.
Physical
Should have chosen
Logical
Structured
integrated
Question: A __________ is complex set of software programs that controls the organization, storage & retrieval of data in a database.Response:
Repository
Should have chosen
DBMS
Software
Program
Question: Data is a __________which can be recorded and has specific meaning.Response:
Information
Meaning
Should have chosen
Raw fact
Raw item
Question: Database is stored in a _________Response:
Distributed space
Should have chosen
Central location
Admin location
Secondary storage
Question: He usually has the complete authority to access and monitor the database.Response:
Database designer
Should have chosen
Database administrator
End user
System Analyser
Question: The DBMS is considered as ___________ software systemResponse: Imp
Multipurpose
Single purpose
Should have chosen
General-purpose
Dual purpose
Question: People, who access the database, query and update the database and generate the various reports areResponse:
System analysts
Application programmers
Tool Developers
Correct
End users
Question: The DBMS has a data dictionary, referred to as ____________, which stores data about everything it holdsResponse:
Should have chosen
System catalog
Data Catalog
Work book
Analytical writing

No comments:

Post a Comment