Home > Download > SMU - Question Paper
> BCA > BC0041
Fundamentals Of Database Management
This is the collection of
Sikkim Manipal University (SMU) question and answers for Fundamentals Of Database Management. It will help
to prepare your examination. All question paper are
classified as per semester, subject code and question type of Part A, Part B and Part C with
multiple
choice options
as same as actual examination. SMU question papers includes
year 2025, 2024, 2023 Sem I, II, III, IV, V, VI examinations
of all subjects.
SMU question test set of old,
last and previous year are updated
regularly and it is absolutely free to use. Question paper includes Visual basic 6, VB.Net, C#, ASP.Net,
Web, Oracle, Database, SQL, Software Engineering, C, C++, OOPS, MBA, MCA, BSC IT I have requested
you kindly send me the question paper of Fundamentals Of Database Management, SMU - Bachelor of Computer Application.
Course Name
BCA (Bachelor of Computer Application)
Subject Code BC0041 (Fundamentals Of Database Management)
Get Questions
PART - A
PART - B
PART - C
Subject : Fundamentals Of Database Management
BC0041 : PART - C
| Q. 1 | Limitations of sequential file are |
| | A) | Used for small files |
| B) | Used for intermediate results of operations | | C) | Used when the file has high hit ratio but
infrequent updates | | D) | All of the above | | | | | Q. 2 | Match the following inference rules for FDs
with their description.
Set A
1. Reflexivity proverty
2. Augmentation property
3. Transitivity property
4. Decomposition property
Set B
a. If x y & y -+ z then x -> z is implied < |
| | A) | 1-d, 2-c, 3-b, 4-a |
| B) | 1-c, 2-d, 3-a, 4-b | | C) | 1-c, 2-d, 3-b, 4-a | | D) | 1-d, 2-c, 3-a, 4-b | | | | | Q. 3 | _______ is defined between two record
types representing one-to-many / one-to-one
relationship |
| | A) | Link |
| B) | Join | | C) | Dependency | | D) | Trees | | | | | Q. 4 | Which of the following are DBMS utilities
i. Loading
ii. Storage
iii. Backup
iv. Performance monitoring |
| | A) | i, ii, and iii |
| B) | iii, iv, v | | C) | I, iii, iv, v | | D) | All of the above | | | | | Q. 5 | Match the following
Set A:
i. 2NF
ii. 3NF
iii. 4NF
iv. BCNF
Set B:
i. Remove more than one independent multivalued
dependency from relation by splitting
relation
ii. Remove dependency of non-key attribute on
par |
| | A) | i-b, ii-d, iii-a, iv-c |
| B) | i-b, ii-c, iii-a, iv-d | | C) | i-d, ii-b, iii-a, iv-c | | D) | i-d, ii-b, iii-c, iv-a | | | |
Click here to get
Fundamentals Of Database Management (BC0041)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0041