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 2024, 2023, 2022 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 | 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. 2 | Match the following types of access
methods with their description
Set A
1. HSAM
2. HISAM
3. HDAM
4. HIDAM
Set B
a. an index based access is permitted for the
root record
b. the random access to root records is
|
| | A) | 1 - a, 2 - d, 3 - c, 4 - b |
| B) | 1 - a, 2 - c, 3 - d, 4 - b | | C) | 1 - d, 2 - b, 3 - c, 4 - a | | D) | 1 - d, 2 - a, 3 - c, 4 - b | | | | | Q. 3 | Give the important performance measures
of a file organization.
a) time to process the data
b) time required to transfer data between
device and memory
c) time spent in waiting for processor and
device ability which is dependent on |
| | A) | a), b), c), d) |
| B) | b), c), d) and e) | | C) | b) and only | | D) | all a), b), c), and e) | | | | | Q. 4 | 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. 5 | _______ is the practical and efficient
method for organizing indexes on external
storage devices. |
| | A) | Multiplicative Method |
| B) | Division Method | | C) | B-Tree | | D) | Chaining Method | | | |
Click here to get
Fundamentals Of Database Management (BC0041)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0041