Seat No:
Mahatma Phule Shikshan Sanstha’s
Karmaveer Bhaurao Pati College, Urun-Islampur
B.Sc. (Computer science) (Entire) (Part-II) (Semester-III) (NEP)
PREPARATORY EXAMINATION Oct/Nov 2024
Subject Name-Computer Science Paper I (RDBMS With MySQL)
Sub. Code-91256
Day and Date: Marks:40
Time:
Instructions: 1) All questions are compulsory
2) Figures to the right indicate full marks.
1.________ is not aggregate function used in SQL
i) COUNT ii) SUM
iii) DISTINCT iv) MIN
2. Related fields in a database are grouped to form a ________.
i) Data file ii) Data record
iii) Menu iv) Ban
3. Relational Algebra is ________.
i) Data Definition Language ii) Meta Language
iii) Procedural Query Language iv) Binary Languag
4. Which of the following clause cannot be used in SQL sub queries?
i)GROUP BY ii) ORDER BY
iii)DELETE iv)FROM
5. A ________ command that extracts some of the records from a table
i) select ii) project
iii) join iv) product
6.A type of query that is placed within a WHERE or HAVING clause of another query is called
as__________.
i)Master query ii) Sub query
iii) Super query iv) Multi-query
7. The full form of RDBMS is?
i)Relation Data Base Management Service iii) Relation Data Base Management System
ii)Relation Data Base Managerial Service iv)None of the above
8. The operation that performs a set union of two similarly structured tables, is known as
i)Union operation ii) Join operation
iii)Cartesian Product operation iv) Intersection operation
Q2) Attempt any two of the following : [16]
1.What is data constraints? Explain any four data constraints with example.
2. Explain aggregate function with example.
3. Explain SQL Commands in details
Q3) Attempt any Four of the following: [16]
1.Explain RDBMS terminology: i) Relation ii) Attribute iii) Tuple iv)Domain
2.What is DBA ,Write responsibilities of DBA.
3.What is join? Explain inner join with example.
4.Explain relational algebra.
5.Explain subqueries and Nested Subqueries
6.Explain different clauses in SQL
