Exam Details
| Subject | dbms using oracle | |
| Paper | ||
| Exam / Course | b.sc. – i (ecs) | |
| Department | ||
| Organization | solapur university | |
| Position | ||
| Exam Date | December, 2018 | |
| City, State | maharashtra, solapur |
Question Paper
B.Sc. II (Computer Science) (Semester IV) Examination, 2018
DBMS using oracle (new CBCS) (Paper II)
Day and Date Saturday, 8-12-2018 Total Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions All questions are compulsory.
Figures to right indicate full marks.
1. Choose the correct alternative. 10
The concept of locking can be used to solve problem of
Lost update Uncommitted dependency
Inconsistent data All of the above
is assignment operator in PL/SQL
None of the above
Variable is passed to procedure in modes.
pass by value read, write
in, out and in out None of the above
represents single line comment in PL/SQL.
∗
command is used to display definition of a table.
select desc
revoke update
A query that retrieves the rows from more than one table
or view.
join end
start all of mentioned
Total number of column in relation is called
Cardinality Degree
Sum None of these
is a facility to undo the change made recently which are
uncommitted.
Commit Savepoint
Rollback None of these
The overall description of database is called
instance schema
data table
10) Which of the following group function ignore null value
count()
count(∗)
State the following statements true/false. 4
Grant and Revoke are DCL commands.
Unique key does not allows null values.
View is virtual relation defined on tale.
SQL is name of implicit cursor
2. Answer any seven of the following 14
Write advantages of stored Procedure's.
What is use of type and rowtype
What is shared lock
What is Shadow paging
Define tuple and cardinality.
Write a syntax of for loop with e.g.
Why database recovery is needed
Write syntax and example of group by clause.
State the components of database.
3. Answer any two of the following 10
What is trigger How it works Explain its type.
Write a PL/SQL block to check given number is Armstrong or not.
Explain the database users.
Discuss the properties of transaction. 4
4. Answer any two of the following 14
What is package in PL/SQL Explain package specification and body
with example.
Explain Join technique in Relational Algebra.
Write Dr. E. F. Codd's Rules for Relational data model any seven.
5. Answer any two of the following 14
Explain different types of keys with example.
What is cursor Explain explicit cursor with example.
What is scheduling Explain view serializability with example.
DBMS using oracle (new CBCS) (Paper II)
Day and Date Saturday, 8-12-2018 Total Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions All questions are compulsory.
Figures to right indicate full marks.
1. Choose the correct alternative. 10
The concept of locking can be used to solve problem of
Lost update Uncommitted dependency
Inconsistent data All of the above
is assignment operator in PL/SQL
None of the above
Variable is passed to procedure in modes.
pass by value read, write
in, out and in out None of the above
represents single line comment in PL/SQL.
∗
command is used to display definition of a table.
select desc
revoke update
A query that retrieves the rows from more than one table
or view.
join end
start all of mentioned
Total number of column in relation is called
Cardinality Degree
Sum None of these
is a facility to undo the change made recently which are
uncommitted.
Commit Savepoint
Rollback None of these
The overall description of database is called
instance schema
data table
10) Which of the following group function ignore null value
count()
count(∗)
State the following statements true/false. 4
Grant and Revoke are DCL commands.
Unique key does not allows null values.
View is virtual relation defined on tale.
SQL is name of implicit cursor
2. Answer any seven of the following 14
Write advantages of stored Procedure's.
What is use of type and rowtype
What is shared lock
What is Shadow paging
Define tuple and cardinality.
Write a syntax of for loop with e.g.
Why database recovery is needed
Write syntax and example of group by clause.
State the components of database.
3. Answer any two of the following 10
What is trigger How it works Explain its type.
Write a PL/SQL block to check given number is Armstrong or not.
Explain the database users.
Discuss the properties of transaction. 4
4. Answer any two of the following 14
What is package in PL/SQL Explain package specification and body
with example.
Explain Join technique in Relational Algebra.
Write Dr. E. F. Codd's Rules for Relational data model any seven.
5. Answer any two of the following 14
Explain different types of keys with example.
What is cursor Explain explicit cursor with example.
What is scheduling Explain view serializability with example.
Other Question Papers
Subjects
- advanced java (paper – iii)
- advanced microprocessor
- compiler construction (paper – iv)
- computer graphics
- core java (old cgpa) (paper – iii)
- data communication and networking – i
- data communication and networking – ii (paper – i)
- data communications and networking – i (paper – i)
- data structures (paper – iv)
- data structures algorithms enginering – ii
- database management system – i (paper – ii)
- database management system – ii (paper – ii)
- dbms using oracle
- descriptive statistics – i
- descriptive statistics – ii
- digital electronics – i
- digital electronics and microprocesor – ii
- discrete structure
- embedded system – i
- embedded system – ii (paper – v)
- english (compulsory) (new) (cbcs)
- fundamental of computer
- golden petals
- introduction to programming using c – ii (paper – iii)
- introduction to web designing (paper – ii)
- linear electronics – i
- linear electronics – ii
- linux operating system (new)
- literary quest
- mathematical algebra
- mathematics(numerical methods)
- microprocesor – ii
- object oriented programming using c++
- object oriented programming using java (paper – i)
- on track – english skills for success
- oop using c++ – ii
- operating system
- operating system – ii (paper – i)
- operations research
- organization of pc – ii
- peripherals and interfacing – ii
- pr obabili ty theory – ii
- probability theory – i (paper – ix)
- programming using “c”
- python – i (paper – v)
- software engineering
- software enginering – ii
- theory of computer science
- theory of computer science (paper – iv)
- visual programming – i
- visual programming and aplication software – i (old)
- visual programming and aplication software – ii(paper – vi)
- web technology and e-commerce – i
- web technology and e-commerce – i (paper – v)
- web technology and e-commerce – ii (paper – v)