Solapur University Question Paper
P.G.D.C.A. (Sem. – II) Examination, 2014
DBMS AND RDBMS USING ORACLE (New) (Paper – VII)
Day and Date : Wednesday, 7-5-2014 Max. Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q.No. 2, 3 and 4.
3) Attempt any one questions from Q.No. 5 to Q. 6.
4) Figures to the right indicate full marks.
1. A) Choose the single correct alternative : 8
i) ___________ is Data control language command
a) ALTER b) Create
c) GRANT d) EDIT
ii) Building Block of database is called
a) Function b) Report
c) Form d) Data
iii) SQL, Spreadsheet, Report Generator, Code Generator are the example of
a) 3 GL b) 4 GL
c) 5 GL d) None of the above
iv) Access is _____________ DBMS.
a) Relational b) Hierarchical
c) Network d) None of the above
v) SQL stands for
a) Structured Query Language b) Software Query Language
c) Server Query Language d) None of these
vi) Primary key has importance of ____________
a) Uniqueness b) Deletion
c) First preference d) None of these
SLR-R – 12 -2-
vii) DDL stands for
a) Data Defination Language
b) Data Drop Language
c) Data Display Language
d) Data Design Language
viii) A row of a relation is called a
a) Domain
b) Tuple
c) Extension
d) None of the above
B) Answer one sentence : 8
i) What is mean by data ?
ii) What is mean by oracle ?
iii) Define table.
iv) What is mean by query ?
v) Define cursor.
vi) Write down Arithmetic operator
vii) Long form of DBA.
viii) What is mean by sort ?
2. a) Write down difference between DBMS and RDBMS. 6
b) Explain the features of SQL. 6
c) Short notes on subqueries. 4
3. a) Write down difference between Data and information. 6
b) Write down six SQL commands with example. 6
c) Explain benefit of DBMS. 4
4. a) Explain the components of SQL. 6
b) Difference between If ELSE statement and FOR loop, with example. 6
c) Short notes on Triggers. 4
-3- SLR-R – 12
5. a) Consider the following employee database employee (employee_name, street,
city works(employee_name, company_name, salary) 8
Company (company_name, city)
Manages (Employee_name, manager_name)
Write SQL queries for the following
Note :Primary key are underlined
a) Find the names of all employee who work for first bank corporation.
b) Find all employees who earn more than the average salary of all employees of
their company.
c) Delete all tuples in the works relation for employees of small bank corporation.
b) Explain CODD’s rules for RDBMS. 8
6. a) What is mean by Normalization ? Explain types of Normal form ? 8
b) What is mean by cursor ? Explain the types of cursors. 8
7. Write short note (any 4) : 16
a) GRANT, REVOKE
b) Role and Responsibility of DBA
c) SQL commands
d) Difference between SQL and PL/SQL
e) Operators.
_____________________
P.G.D.C.A. (Sem. – II) Examination, 2014
DBMS AND RDBMS USING ORACLE (New) (Paper – VII)
Day and Date : Wednesday, 7-5-2014 Max. Marks : 80
Time : 3.00 p.m. to 6.00 p.m.
Instructions : 1) Q. 1 and Q. 7 are compulsory.
2) Attempt any two questions from Q.No. 2, 3 and 4.
3) Attempt any one questions from Q.No. 5 to Q. 6.
4) Figures to the right indicate full marks.
1. A) Choose the single correct alternative : 8
i) ___________ is Data control language command
a) ALTER b) Create
c) GRANT d) EDIT
ii) Building Block of database is called
a) Function b) Report
c) Form d) Data
iii) SQL, Spreadsheet, Report Generator, Code Generator are the example of
a) 3 GL b) 4 GL
c) 5 GL d) None of the above
iv) Access is _____________ DBMS.
a) Relational b) Hierarchical
c) Network d) None of the above
v) SQL stands for
a) Structured Query Language b) Software Query Language
c) Server Query Language d) None of these
vi) Primary key has importance of ____________
a) Uniqueness b) Deletion
c) First preference d) None of these
SLR-R – 12 -2-
vii) DDL stands for
a) Data Defination Language
b) Data Drop Language
c) Data Display Language
d) Data Design Language
viii) A row of a relation is called a
a) Domain
b) Tuple
c) Extension
d) None of the above
B) Answer one sentence : 8
i) What is mean by data ?
ii) What is mean by oracle ?
iii) Define table.
iv) What is mean by query ?
v) Define cursor.
vi) Write down Arithmetic operator
vii) Long form of DBA.
viii) What is mean by sort ?
2. a) Write down difference between DBMS and RDBMS. 6
b) Explain the features of SQL. 6
c) Short notes on subqueries. 4
3. a) Write down difference between Data and information. 6
b) Write down six SQL commands with example. 6
c) Explain benefit of DBMS. 4
4. a) Explain the components of SQL. 6
b) Difference between If ELSE statement and FOR loop, with example. 6
c) Short notes on Triggers. 4
-3- SLR-R – 12
5. a) Consider the following employee database employee (employee_name, street,
city works(employee_name, company_name, salary) 8
Company (company_name, city)
Manages (Employee_name, manager_name)
Write SQL queries for the following
Note :Primary key are underlined
a) Find the names of all employee who work for first bank corporation.
b) Find all employees who earn more than the average salary of all employees of
their company.
c) Delete all tuples in the works relation for employees of small bank corporation.
b) Explain CODD’s rules for RDBMS. 8
6. a) What is mean by Normalization ? Explain types of Normal form ? 8
b) What is mean by cursor ? Explain the types of cursors. 8
7. Write short note (any 4) : 16
a) GRANT, REVOKE
b) Role and Responsibility of DBA
c) SQL commands
d) Difference between SQL and PL/SQL
e) Operators.
_____________________
0 comments:
Pen down your valuable important comments below