Sunday 18 March 2012

DBMS MCQ 06


1.      Analysis of an existing system starts when a customer request either for computerizing his ________:
a.      Non-computerized operations
b.      Computerized operations
c.       Relational operation
d.      Database operation
2.      Which is done by developers is centered on input and output expected by the customer:

a.       Requires interaction
b.      Analysis of starting
c.       Analysis of existing
d.      None of these

3.      What dose a system design include:

a.       I/O devices
b.      CPU
c.       Storage unit
d.      All of these

4.      Which are used by developers to extrapolate complexities of real world into a computer based model:

a.      Data analysis techniques
b.      Data analysis model
c.       Data structure
d.       Data analysis

5.      A conceptual data model defines the structure of the data and method or processes that use:

a.       File
b.      Data
c.       Operation
d.      Testing

6.      CDA stands for:
a.      Confirmatory data analysis
7.      EDA stands for:
a.      Exploratory data analysis
8.      WWW stands for:
a.      World wide web
9.      Which is the forerunner of data analysis having close link with data visualization and data dissemination:

a.       Data analysis model
b.      Data structure
c.        Data analysis
d.      Data integration

10.  In preliminary and final designs the design of physical database focuses the way data is physically_____:

a.       Delete
b.      Start
c.       Stored
d.      Read

11.  Primary steps for converting a logical data model to preliminary physical data model are:
a.       Converting entities into file
b.      Converting relationship for accessing paths using keys
c.       Adding
d.      De-normalization
e.       Tuning
f.        Converting
g.       Reduction of chain length
h.      All of these
i.         None of these
12.  JPEG stands for:
a.      Joint photographic experts group
13.  MPEG stands for:
a.      Moving pictures experts group
14.  DVI stands for:
a.      Digital video interactive
15.  Which refers to the process of installing programs/software in a system of information system:

a.       Requires interaction
b.      Analysis of starting
c.       Implementation
d.      Testing

16.  Which refers to the process of executing new and revised programs to check whether the process and running properly:

a.       Maintenance  
b.      Analysis of starting
c.       Implementation
d.      Testing

17.  Which refers to the proper upkeep of data, hardware, software and in general of the entire system:

a.       Tuning
b.      Analysis of starting
c.       Implementation
d.      Maintenance 

18.  Which refers to the use of various techniques for the adjustments and change made to help the system work efficiently:

a.      Tuning
b.      Analysis of starting
c.       Implementation
d.      All of these

19.  Files that require immediate access, must be stored on_____:

a.       Slow devices
b.      Faster devices
c.       Medium devices
d.      All of these

20.  The batch accesses may be stored on slow devices such as________:

a.       Optical disk
b.      Tape
c.       Both
d.      None

21.   How many types of changeover methods:

a.       1
b.      2
c.       3
d.      4

22.  Which the types of changeover methods:

a.       Direct
b.      Parallel
c.       Pilot
d.      Staged or phased
e.      All of these

23.  How many types of maintenance:

a.       1
b.      2
c.       3
d.      4

24.  Which are the not a type of maintenance:

a.       Corrective
b.      Adaptive
c.       Perfective
d.      None of these

25.  Which is conducted for assessing the quality of the system produced by developer for customer:

a.       Maintenance 
b.      Analysis of starting
c.       Implementation
d.      Testing

No comments :

Post a Comment