BSc CS Sem 1 BSc CS Semester 1 (2020 2021) 2021 DBMS Question Paper - Mumbai University | munotes

Sample Question Bank
The for a binary relationship specifies the maximum Cardinality Cardinality
of instances an entity can participate in. Database Ratio Attribute Entity Ratio
In the database architecture, external level is . Physical
Storing the same data multiple times leads to several
is known as . Waste Redundancy |Query File Redundancy
5 is a top_down approach. Specialization |Database Aggregation Jn Specialization
How is the discriminator of a weak entity set specified? Using a solid line |dashed line line Labelling it dashed line
An some property which describes the entity
The structure of a table can be modified by using
claues is used with aggregate functions to retrieve data
10 |categorywise. Having Group by Order by Where Group by
clause arranges records selected in certain order
A functional dependency is a relationship between or
consists of atomic values, no repeating group
Which of the following is used to denote the selection operation in
clause is act as a filter for unwanted data
function calculates the number of days between two DATE
return all rows from the left table and matching
rows from the right table or null if no matching rows found in the
return all rows from the right table and matching rows
from the left table or null if no matching rows found in the left
subquery cannot be executed by itself as a separate
function returns the absolute value of a number
25 |Subquery is . query query a query half query query