PGDCA System Engineering, RDBMS & SQL - SET 2

KERALA STATE RUTRONIX

System Engineering, RDBMS & SQL

(PGDCA)

Question code          : E5
Maximum Marks    : 100
Time                          : 2 hours
(Note: Write the answers for Questions from 1 to 30 in the MCQ answer sheet)

Part - I Choose the most appropriate answer
(10 X 1 Mark = 10 Marks)

1) ........... decision follow a set of organization formulated rules and regulations
a) Structured
b) Semi Partially structured
c) Unstructured
d) data structures

2) Which SQL command is used to define the primary key for a new table called "student" with primary column to be "studid?
a) ALTER TABLE student ADD PRIMARY KEY(studid")
b) ATTACH TO TABLE student PRIMARY KEY studid
c) ALTER TABLE student ASSIGN PRIMARY KEY(studid)
d) ALTER TABLE student ADD PRIMARY KEY(studid)

3) In a relational schema, each tuple is divided into fields called ..............
a) Relations
b) Domains
c) Queries
d) Fields

4) Testing a system in the actual environment using real data is called ...............
a) Alpha
b) Stub
c) Beta
d) Audit

5) RDBMS stands for ...........
a) Relational Database Management System
b) Relational Data Module System
c) Relational Data Management System
d) None of these

6) ............. is a file manipulation command that extracts some of the records from a file
a) JOIN
b) EXTRACT
c) SELECT
d) None of these

7) E-R Modeling technique is ............. approach
a) top-down
b) bottom-up
c) right-left
d) None of these

8) Which of the following is record based logical model?
a) Network model
b) Object-Oriented model
c) Relational model
d) E-R model

9) ........... is the system in which occurrences of all events is perfectly predictable.
a) Probabilistic
b) Deterministic
c) Closed
d) Open

10) An attribute of one table matching the primary key of another table is called ............
a) foreign key
b) link key
c) system key
d) main key

Part - II Fill in the Blanks
(10 X 1 Mark 10 Marks)

11) Entities are described in a database by a set of ..............

12) .................. is the first activity in system development life cycle.

13) DFD stands for ...............

14) The overall design of the database called ..............

15) A ................ is used by the DBMS to create, read update and delete records in the data base.

16) ................. is a formulated document that summarizes findings and recommendations on
the proposed system and for management use.

17) Intersection of rows and columns in a table is called ................

18) The SQL command should be terminated with ...............

19) Duplication of data in a database is called ..............

20) Horizontal bar chart sometimes called a ............ chart

Part - III State whether True or False
(10 X 1 Mark 10 Marks)

21) A back-up is a safeguard against unexpected data loss and application errors.

22) A relational schema stores data in trees.

23) Authorization is the process by which a user's identity is checked.

24) Interdependence is one of the basic characteristics of a system.

25) The complete need of a user is not defined in Information Service Requisite.

26) Sampling is the process of collecting sample documents, forms and records.

27) JOIN command is an aggregate function.

28) All fields in a record must be of the same type.

29) The table is the fundamental unit of information in a hierarchical DBMS.

30) Information Service Requisite does not define the complete need of user.

Part - IV Write SQL Queries for following Statements
(5 x 2 Marks = 10 Marks)

31) Read the table given below and answer the following questions (Table:Employee)
Write SQL Queries to:

                                                                             

IDNum	LastName	FirstName	Address	City
1	Vikraman	Sarath	J-12	Trivandrum
2	Krishnan	Shyam	D-9	Trivandrum
3	Vijayan	Vineeth	P-1	Kollam

a) To list the FirstName in the alphabetical order.
b) To update the City of Trivandrum to Idukki
c) Insert a new row having IDnum 4, LastName 'Prakash', First Name 'Daya', Address 'S-11' and City 'Kollam'.
d) Select only the persons living the Trivandrum city.
e) Delete all rows in the persons table

Part - V Answer the following (Any Three)
(3 X 10 Marks 30 Marks)

32) What is aggregate function? What are the five built-in aggregate functions in SQL?

33) Explain cost benefit evaluation methods.

34) Mention two types of SQL joins.

35) What is system planning? What are the common aids to system planning?

36) Explain E-R modeling symbols.

Part - VI Explain the following (Any Two)
(2 X 15 Marks 30 Marks)

37) Define Normalization. Explain its types

38) Explain SDLC

39) Briefly explain about data documentation tools

40) Explain the three models available for Database Management.