MODEL QUESTION PAPER 1
UNIT 1
(a) Explain the various types of constraints available in RDBMS.
(b) Define Key. What are the Types of Keys? Explain them in detail with Example.
(c)(i) Briefly Explain the Components of DBMS.
(ii) How to Backup Databases in MYSQL.
(d)(i) Differentiate SQL and MySQL.
(ii) Briefly Explain Table Structure.
UNIT 2
2. (a) Explain in detail about Data Manipulation Commands.
(b) Explain (i)CREATE (ii)ALTER Commands with an Example.
(c)(i) Explain Pattern Matching.
(ii) Explain Aggregate Functions in MYSQL.
(d) Explain Single Row Numeric and String Functions with an Example.
UNIT 3
3.(a) Explain WHILE, REPEAT, ITERATE with an Example
(b) Explain WHERE and HAVING clauses.
(c) Explain GROUP BY and ORDER BY clauses with Syntax and Example.
(d)How do you Create, Update and Delete Views?
UNIT 4
4.(a) Explain Creating, Altering and Dropping Sequences with an Example.
(b) What is Join? Explain Natural and Self-join with Example.
(c) Explain about Unions and its types with Example.
(d) Create a Table Name 'student' with Sequences.
UNIT 5
5. (a) Explain in detail about Creating, Calling and Dropping Stored Procedures with an Example.
(b) Explain Cursors in detail.
(c)(i) Explain different parts of Triggers.
(ii)Create a program for cursor.
(d) Explain Creation of Stored Function with an Example.
MODEL QUESTION PAPER 2
1.
(a) Explain CODD's rules in detail.
(b) How to install MYSQL on windows with neat sketches.
(c) Explain CREATE, USE, DESC and SHOW commands in database with syntax and example.
(d) Explain the steps of MYSQL installation.
2.
(a) Explain different form of Retrieval Commands in MYSQL.
(b) Explain MYSQL Data Types in detail.
(c) Explain in detail about MYSQL Operators.
(d) Create a Database named ‘college’ and Create a Table for ‘student’ and ‘employee’ with the field as you like.
3
(a) Explain CASE,LOOP,LEAVE with an Example.
(b)(i) Explain Sub-Queries with Example.
(ii) Explain IF() and IFNULL() with an Example.
(c)(i) Explain Correlated Sub-Queries with Example.
(ii) Explain IF() and IFNULL() with an Example.
(d) Explain Creating, Updating and Deleting Views with Syntax and Example.
4.
(a) What is Indexing? What are the different types of Indexing? Explain them with an Example.
(b) What is a Join? Explain Inner and Outer Join with Example.
(c) Explain about Transaction Commands with Example.
(d)(i) Explain Create,Rename and Deleting Users.
(ii) Explain GRANT and REVOKE Commands with an Example.
5.
(a) With an Example, Explain Creating, Calling and Deleting Stored Function.
(b) Explain how Triggers are Created and Deleted with Syntax and Example.
(c) Create a stored procedure to get employee details from employee table.
(d)Explain Cursors in detail.