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 - B
| Q. 1 | To remove index one table _____ query
can be used. |
| | A) | Delete index table index [____n] |
| B) | Remove index table index [____n] | | C) | Drop index table index [____n] | | D) | Alter index table index [____n] | | | | | Q. 2 | Describe the B-tree data structure
a) an order m is associated with a B-tree
b) the root node has at least (m/2) key value
and 2 pointers
c) all root nodes are that same level
d) all nodes other than root have at least (m/2)
key va |
| | A) | a), b), c), d) |
| B) | a), b), c) | | C) | a), c), d) | | D) | c) and d) | | | | | Q. 3 | Database Management should:
1. be possible to store, access & maintain the
large size of data
2. permit data storage in integrated fashion by
fragmenting in different application which
control redundant data
3. have a central repos |
| | A) | 1., 2 |
| B) | 1, 3 | | C) | 2, 3 | | D) | 1, 2, 3 | | | | | Q. 4 | What are the criteria to be considered,
while designing a database from users point of
view?
a) Meaningful grouping of attributes
b) No inapplicable attributes
c) Define constraints so that correctness of data
will be ensured. |
| | A) | a), b), c) and d) |
| B) | a), and c) | | C) | b), and d) | | D) | a), b) and d) | | | | | Q. 5 | What are the salient features of Data
model.
1. It processes a set of concepts for description
of the nature of data interrelationships between
them along with the syntax
2. It should have as minimum concepts which
are close to rea |
| | A) | 1, 3, 4 |
| B) | 1, 2, 3 | | C) | 2, 3, 4 | | D) | 1,2,3,4 | | | |
Click here to get
Fundamentals Of Database Management (BC0041)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0041