RutronixExams

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...

KERALA STATE RUTRONIX System Engineering, RDBMS & SQL (PGDCA) Question Code          : E5 Time                           : 2 hours Maximum Marks      : 100 (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) To eliminate duplicate rows ............. is used. a) Duplicate b) Eliminate c) Distinct d) Inverse 2) In an E-R diagram attributes are represented by .............. a) Rectangle b) Square c) Ellipse d) Triangle 3) The number of tuples in a relation is called its .............. a) Columns b) Degree c) Keys d) Cardinality 4) What field type is best to store serial numbers? a) Text b) AutoNumber c) Number d) Varchar 5...