AMU MCA Database Management Systems Previous Year Questions (PYQs) – Page 1 of 2
A Place for Latest Exam wise Questions, Videos, Previous Year Papers,
Study Stuff for MCA Examinations
Study Stuff for MCA Examinations
Showing 15 questions
E-R modeling technique is a
1
2
3
4
Solution
E-R modelling starts from general view → top-down approach.
Malicious software is known as
1
2
3
4
Solution
Malicious software is commonly called malware.
The physical location of a record determined by a formula that transforms a file key into a record location is
1
2
3
4
Solution
Hash function directly maps key to location.
The employee salary should not be greater than Rs. 20,000.” This constraint is of type:
1
2
3
4
Solution
It restricts a single attribute value.
In a University schema, student and courses contains:
1
2
3
4
Solution
Many students enroll in many courses → many-to-many.
Consider a relation $R(A,B,C,D)$ with set of functional dependencies
$AB \rightarrow CD$ and $D \rightarrow A$.
Let $R_1(A,D)$ and $R_2(B,C,D)$ are two decompositions over $R$.
Which of the following statement is TRUE?
1
2
3
4
Solution
The decomposition is lossless (common attribute $D$ determines $A$),
but not dependency preserving (FD $AB \rightarrow CD$ is lost).
In which file, the records are organized in sequence and an index table is used to speed up access to the records without requiring a search of the entire file?
1
2
3
4
Solution
Indexed Sequential File uses sequential storage + index for fast access.
The Default and Maximum Size of Text Field in MS-Access is:
1
2
3
4
Solution
Adjacency matrix is a method to represent graphs.
Which of the following is not a type of database?
1
2
3
4
Solution
Hierarchical, network, and distributed are database models.
Decentralized is not a standard database type.
The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
1
2
3
4
Solution
In relational databases, a tuple represents a single record (row).
AMU MCA
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
AMU MCA
Online Test Series, Information About Examination,
Syllabus, Notification
and More.
View More
Ask Your Question or Put Your Review.
