Thursday, 22 November 2012

APRIL/MAY-2012(C-05)


C05-CM-503
632
BOARD DIPLOMA EXAMINATION, (C-05)
APRIL/MAY-2012
DCME V SEMESTER EXAMINATION
RELATIONAL DATABASE MANAGEMENT SYSTEMS
Time : 3 Hours]                                                               [Total Marks: 100
PART-A    10*4=40
Instructions: (1) Answer all questions and each question caries four marks. (2) Answers should be brief and straight to t the point and shall not exceed five simple sentences.
1.    Define entity and relationshsip.
2.    Define DDL and DML
3.    What are the differences between char and varchar2 datatypes?
4.    What are conversion functions?
5.    What is the process of creating a table?
6.    Difference between view and table.
7.    List any four built in functions of PL/SQL.
8.    List any four predefined PL/SQL exceptions
9.    What are the benefits of overloading?
10. Explain briefly about stored sub program..


PART-B                                              5*12=60
Instructions: (1) Answer any five questions and each question caries twelve marks. (2) The Answers should be comprehensive and criteria for valuation is the Content but not the length of the answer.

11. Explain various mapping cardinalities.
12. (a) explain how will you convert E-R diagram into table (b) classify the database users into various types.
13. Explain any 12 functions of SQL.
14. (a) explain about DML statements. (b) explain the process of creating (i) synonym (ii) index.
15. Explain the following commands commit, rollback and save point
16. Explain the architecture of PL/SQL.
17. Explain recursion with the help of an example.
18. (a) explain overloading in PL/SQL with an example. (b) what is a package? Write its advantages.
Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS
&� 5 ; / �>� �� n style='font-size:7.0pt;mso-bidi-font-size:11.0pt;font-family:"'Times New Roman'","serif"; mso-fareast-font-family:"Times New Roman";mso-bidi-font-family:Arial; color:black'> Write the syntax for package body. Explain with example.
18.  (a) what is an outer-join? Give an example. (b) how do you manage the space usage of database tables?
Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS
1ptP � e h �>� �� 8.0pt'>                   EXCEPTION
                             WHEN A THEN
                                      RAISE B;
                             WHEN B THEN
                   END;
Explain the propagation of exception in the abouve block of code.
16.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL ?
17.  (a) how to create a stored subprogram? Explain with example. (b) explain how to call stored subprogram using Oracle objects.
18. (a) explain different categories of SQL data types. (b) List any two integrity constraints. State the reasons for enforcing each of these constraints.

Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS

OTHER SUBJECT PREVIOUS QUESTION PAPERS

Posted by at No comments:

APRIL /MAY-2012(C-09)


C-09-CM-105/C09-IT-105
3232
BOARD DIPLOMA EXAMINATION, (C-09)
APRIL /MAY-2012
DCM-III YEAR EXAMINATION
RDBMS

TIME: 3 Hours]                                                                     [Total Marks :80]
PART   - A
INSTRUCTION:  (1) ANSWER ALL QUESTION AND EACH QUESTION
                                           CARRIES FOUR MARKS
                    (2)  ANSWER SHOULD BE BRIEF AND   STRAIGHT      TO  THE POINT AND SHALL NOT EXEED FIVE SIMPLE SENTENCES

1.     Define primary key. Give example.
2.     What is the difference between a 2NF and a 3NF relation?
3.     Construct an E-R diagram for the statement “Driver drives a car”.
4.     List different types of literals.
5.     Give the syntax for UPDATE command.
6.     What is an integrity constraint?
7.     Explain about dropping a table, with example.
8.     How to declare global variables?
9.     How many types of exceptions are there?
10.  What are the benefits of overloading?


Instructions :    (1) Answer any five questions and each question carries ten marks.
                  (2) The answers should be comprehensive and the criteria for valuation   is the content but not the length of the answer.

11.  describe the overall database system structure with block diagram.
12.  Explain various data models.
13.  Explain the process of accessing objects in remote database.
14.  Explain the creation of view from multiple tables with examples.
15.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL?
16.         List and explain the four steps involved in managing explicit cursors with example.
17.  Write the syntax for package body. Explain with example.
18.  (a) what is an outer-join? Give an example. (b) how do you manage the space usage of database tables?
Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS
1ptP � e h �>� �� 8.0pt'>                   EXCEPTION
                             WHEN A THEN
                                      RAISE B;
                             WHEN B THEN
                   END;
Explain the propagation of exception in the abouve block of code.
16.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL ?
17.  (a) how to create a stored subprogram? Explain with example. (b) explain how to call stored subprogram using Oracle objects.
18. (a) explain different categories of SQL data types. (b) List any two integrity constraints. State the reasons for enforcing each of these constraints.

Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS

OTHER SUBJECT PREVIOUS QUESTION PAPERS

Posted by at No comments:

OCTOER/NOVEMBER 2011(C-09)


C-09-CM-306
3232
BOARD   DIPLOMA   EXAMINATION,   (C-09)
OCTOER/NOVEMBER 2011
D.C.M.E   -   III SEMISTER EXAMINATION
RDBMS
TIME: 3 Hours]                                                                     [Total Marks :80]
PART   - A                                          10*4=80
Instruction:  (1) answer all question and each question
                                           carries THREE marks
                    (2)  answer should be brief and   straight      to  the point and shall not exceed five simple sentences

1.      What is meant by data model?
2.      What is differences between a 2NF and a 3 NF RELATION
3.      Define the terms entity and entity set.
4.      Give the syntax for insert command
5.      What is a sub=query? Give an example.
6.      Define schema
7.      Explain about dropping a table, with example.
8.      What is a subprogram
9.      Write the syntax to drop a trigger
10.  What are the benefits of overloading
 PART- B                                    5*10=50
Instructions: (1) Answer any five questions and each question carries ten marks. (2) The answers should be comprehensive and the criteria for valuation is the content but not the length of the answer.
  
11. (a) explain data indepence. (b) explain the responsibilities of database  manager.
12. Explain generalization, specialization, aggregation with example.
13. Explain the proces of accessing object in remote database.
14. Explain the creation of view from multiple tables with example.
15. (a) define an exception. Give example. (b) consider the following block of PL/SQL code.
DECLARE
                   A         EXCEPTION :
                   B          EXCEPTION :
                                BEGIN    
                   RAISE A;
                   EXCEPTION
                             WHEN A THEN
                                      RAISE B;
                             WHEN B THEN
                   END;
Explain the propagation of exception in the abouve block of code.
16.  (a) draw the block diagram of PL/SQL engine. (b) what are the differences between SQL and PL/SQL ?
17.  (a) how to create a stored subprogram? Explain with example. (b) explain how to call stored subprogram using Oracle objects.
18. (a) explain different categories of SQL data types. (b) List any two integrity constraints. State the reasons for enforcing each of these constraints.

Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS

OTHER SUBJECT PREVIOUS QUESTION PAPERS

Posted by at No comments:

APRIL/MAY 2011 (C-05)


632
BOARD   DIPLOMA   EXAMINATION,   (C-05)
APRIL/MAY 2011
D.C.M.E   -   V SEMESTER EXAMINATION
RELATIONAL DATABASE MANAGEMENT SYSTEMS
TIME: 3 Hours]                                                                     [Total Marks :100]
PART   - A                                          10*4=40
Instruction:  (1) answer all question and each question
                                           carries four marks
                    (2)  answer should be brief and   straight      to  the point and shall not exceed five simple sentences

1.     Write the symbols used in E-R diagram.
2.     Write four responsibilities of database administrator.
3.     What are the parts of objects?
4.     List the Oracle products which support SQL.
5.     List any four constraints.
6.     What is hash cluster?
7.     What is an exception?
8.     What is a stored program?
9.     List the advantages of package.
10. What are the benefits of overloading?


PART- B                                                5*12=60
Instructions: (1) Answer any five questions and each question carries ten marks. (2) The answers should be comprehensive and the criteria for valuation is the content but not the length of the answer.
  
11. What is a database model? Explain the various database models.
12. (a) Explain the function of database administrator.                                                                    (b) Explain the mapping constraints.
13. (a)Explain the various data types of SQL.                                                                                    (b) Explain the group functions in SQL.                  
14. Explain the procedure of creating altering and dropping tables.                                   
15. (a) Explain about space management of data base table.                                                          (b) Explain about indexes.
16. Explain about various data types of PL/SQL in detail.
17. Explain about implicit and explicit cursors.
18. Explain about procedure overloading in PL/SQL with an example.

Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS

OTHER SUBJECT PREVIOUS QUESTION PAPERS
Posted by at No comments:

OCTOBER/NOVEMBER-2010(C-09)



632
BOARD   DIPLOMA   EXAMINATION,   (C-09)

OCTOBER/NOVEMBER-2010
DCM-V SEMESTER EXAMINATIONS

PART-A          10*3=30

1.     Explain data independence.
2.     What is an ER diagram? What are the symbols used in ER diagrams?
3.     Explain any four character functions of SQL with example.
4.     What is a pseudo column? Explain with an example.
5.     What is a view? Write the syntax for creating a view.
6.     Write the rules for naming a table.
7.     Explain PL/SQL local and Global variables.
8.     What is procedure? Write the syntax for creating a procedure.
9.     What is stored subprogram?
10. List the specification of a package.

Part-B                                                                   5*12=60

11. Explain the overall database system structure.
12.  (a) Explain mapping constraints. (b)What is means by normalization? Explain 1NF with an example.
13. (a)Explain the various data format models in SQL. (b) Explain set operators of SQL.
14. What is an index? Write the syntax for crating and dropping an index.
15. Explain the procedure for creating, altering and dropping a sequence in PL/SQL.
16. (a)Explain propagation and re-raising of exceptions.                                                  (b) Explain the different data types of PL/SQL.
17.  (a) Explain recursion with an example. (b) write a PL/SQL program to compute the first ten terms of Fibonacci series and store it in a table.
18. (a)What is a package? Explain the advantages of packages.                         6   (b) explain procedure overloading.                                                                  6
Home

POLYTECHNIC RDBMS PREVIOUS QUESTION PAPERS
OTHER SUBJECT PREVIOUS QUESTION PAPERS

Posted by at No comments:

Friday, 7 September 2012

normalisation


Posted by at No comments:

How the Search Engine Works in the Networking


Posted by at No comments:
Subscribe to: Posts (Atom)