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 | Given a relation Faculty with different
attributes as Faculty (FNumber, Name, Address,
Grade, Scale, Qualification, Skill Code).
Imagine, you have already applied INF and 2NF
rules and now you are to go for 3NF rule. Which
of the follo |
| | A) | Faculty (FNumber, Name, Address, Grade)
Grade(Grade, Scale)
Qualification(FNumber, Qualification, Skill code) |
| B) | Faculty (FNumber, Name, Address, Grade,
Scale Qualification)
Name(Name, Address)
Scale(Greade, Scale, Qualification, Skill code) | | C) | Faculty (FNumber, Name, Address, Grade,
Scale Qualification, Skill code)
Qualification(FNumber, Name, Grade, Scale
Qualification, Skill code) | | D) | Faculty (FNumber, Name, Address)
Qualification(FNumber, Qualification, Grade,
Skill code) | | | | | Q. 2 | In transaction model, ______ implements
start, commit, abort besides read & write,
provides resilience to failures |
| | A) | Buffer Manager |
| B) | Recovery Manager | | C) | Scheduler | | D) | Transaction Manager | | | | | Q. 3 | What are the characteristics of DBMS
1. System should be designed to co-relate
different data to meet now requirements.
2. An independent central repository, which
gives information & meaning of available data is
required.
3. To in |
| | A) | 1, 3, 4, 5 |
| B) | 2, 3, 4, 5 | | C) | 1,2,3,4 | | D) | 1, 2, 3, 4, 5 | | | | | Q. 4 | Specify the good database design to avoid
anomalies
a) Unrelated data should be kept in different
tables
b) The design should try to represent
constraints explicitly to the extent possible and
table structure should itself reflect |
| | A) | a), b), c) and d) |
| B) | a), and c) | | C) | b) and only | | D) | a) and only | | | | | Q. 5 | Select the correct statement with reference
to sub queries
1. The BETWEEN operator cannot be used with
a sub query
2. Sub queries can be used in INSERT,UPDATE
and DELETE statement
3. The nested query must return a single row
wh |
| | A) | 2, 3, 4, 5 |
| B) | 1, 2, 3, 4, 5 | | C) | 1, 3, 4, 5 | | D) | 1, 2, 3, 4 | | | |
Click here to get
Fundamentals Of Database Management (BC0041)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0041