DBMS (BCS41) - University Questions

THIRUVALLUVAR UNIVERSITY EXAM QUESTIONS [DBMS – BCS41]

 UNIT – 1

2 – Marks 

1	Data is distinct piece of information. Justify.	APR / MAY 2019
2	What is the use of ER Diagram?	APR / MAY 2019
3	Define Entity.	NOV / DEC 2019
4	What is the use of ER Diagram?	NOV / DEC 2019

5 – Marks 

1	Discuss on the components of ER Diagram.	APR / MAY 2019
2	With a neat diagram describe the overall system structure of DBMS	APR / MAY 2019
3	What are the advantages of DBMS?	NOV/DEC 2019
4	What is the difference between a flat file and a relational database?	NOV / DEC 2019

10 – Marks 

1	Explain the different approaches for data model.	APR / MAY 2019
2	Draw     the     compare       relational       and      hierarchical approaches of data models.	NOV/DEC 2019

=============================================

 UNIT – 2

2 – Marks

1	State   all   the   relational   operations   in   relational database.	APR / MAY 2019
2	Explain   projection    and    rename    operator    with example.	APR / MAY 2019
3	What is Tuple?	NOV / DEC 2019
4	List some operators used in Relational Calculus.	NOV / DEC 2019

5 – Marks

1	Explain structure of relational database.	APR / MAY 2019
2	Write short notes on relational algebra.	APR / MAY 2019
3	Explain the importance of Null Values in Relational Model.	NOV/DEC 2019
4	Write some extended relational algebra operations.	NOV / DEC 2019

10 – Marks

1	Discuss on relational model in detail.	APR / MAY 2019
2	Explain the relational models in detail.	NOV/DEC 2019

 =============================================

UNIT – 3

2 – Marks

1	Why do we need Normalization?	APR / MAY 2019
2	Define Referential Integrity.	APR / MAY 2019
3	What is an integrity constraint?	NOV / DEC 2019
4	Why do we need normalization?	NOV / DEC 2019

5 – Marks

1	State BCNF. How does it differ from 3NF?	APR / MAY 2019
2	Discuss the problems caused by redundancy.	APR / MAY 2019
3	Write short notes on Boyee Codd Normal form.	NOV/DEC 2019
4	Find the highest normal form of a relation R (A, B, C, D, E) with functional dependency set {A à D, B à A, BC à D, AC à BE}	NOV / DEC 2019

10 – Marks

1	Describe any two normalization forms with necessary examples.	APR / MAY 2019
2	Explain 3NF and BCNF with examples.	NOV/DEC 2019

  =============================================

 UNIT – 4

2 – Marks

1	What is nested query?	APR / MAY 2019
2	List the features of SQL.	APR / MAY 2019
3	SQL is procedural language (True / False). Explain	NOV / DEC 2019
4	Give examples for nested queries.	NOV / DEC 2019

5 – Marks

1	Show how to group the output of the query.	APR / MAY 2019
2	Explain DML and DCL commands in SQL.	APR / MAY 2019
3	Explain querrying from multiple tables.	NOV/DEC 2019
4	What are the DCL commands in SQL? Explain.	NOV / DEC 2019

10 – Marks

1	Explain the various date functions used in SQL.	APR / MAY 2019
2	Give the various numeric functions used in SQL.	NOV/DEC 2019

   =============================================

UNIT – 5

2 – Marks

1	What is stored procedure?	APR / MAY 2019
2	What down the types of PL / SQL cursors?	APR / MAY 2019
3	State the purpose of PL/SQL.	NOV / DEC 2019
4	Define Stored Procedure	NOV / DEC 2019

5 – Marks

1	Write a program to display “Hello World” in PL / SQL.	APR / MAY 2019
2	Show how to open and close a cursor.	APR / MAY 2019
3	Explain about PL/SQL function.	NOV/DEC 2019
4	Write the type of cursors used in PL/SQL.	NOV / DEC 2019

10 – Marks

1	Write PL / SQL procedure to read student roll number from user, fetch marks form student table for this student, compute grade and update the grade column of the table. STUDENT (roll number, name, marks1, marks2, marks3, marks4, grade) [Follow regular convention for student grades (A, B, C, D, F)]	APR / MAY 2019
2	Describe PL / SQL block structure with examples.	NOV/DEC 2019