[scheme 2010] Model Question Paper
PGDCA 103 SOFTWARE ENGINEERING & DATABASE MANAGEMENT SYSTEMS
Part A
(Answer all questions.Each carries 1 mark.)
Choose the correct answer.
1. _______ data independence insulates user from making changes to internal level.
a)physical b)logical c) internal d)external
2. In SQL _________ command is used to confirm transaction.
a) alter table b)commit c)rollback d)udpate
3. A schema is written using ____________ language.
a)DDL b)DML c)QBE d)SQURE
4. Which of the following is not a group function.
a) max b)sum c)round d)avg
5. _______symbol in an ER Diagram to represent relationship sets.
a) rectangle b)circle c)diamond d) arrow
6. The number of tuples in a relation is called ________.
a) degree b)cardinality c) attribute d)domain
7. ____ is table of contingencies for a defining a problem and the action to be taken.
a)DFD b)decision table c)structure chart d) FAT
8. _____feasibility centres around the existing system hardware,software etc.
a)technical b) behavioral c)economical d)all of these
9. ______ structured repository of data about data.
a) view b)table c)data dictionary d)data flow diagram
10. __________ is a technique used for generating new ideas and obtaining general information requirements.
a) prototyping b) questionare c)brain storming d)none of these
Fill in the blanks.
11. The view is a _________ table.
12. The record type at the top of the tree structure is _________.
13. If the records in a file are physically ordered on a non key field ,that field is called _____.
14.UML stands for _______ .
15. _______ implies that goals are achieved through differing courses of action and a variety of paths.
State whether True or False.
16. An open system receives inputs from and delivers outputs to the outside world.
17. Structured English is best for logic verifications.
18. A relation can have more than one candidate key.
19. A dense index saves storage space.
20. An application form is an example for action form.