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 | Database server function includes:
1 Query optimization
2. Stored procedure
3. Transaction management
4. Compile queries
5. Backup & recovery
6. Data Management |
| | A) | 2, 3, 4, 5, 6 |
| B) | 1, 2,3,5,6 | | C) | 1, 2,3,4,5 | | D) | 1, 2, 3, 4, 5, 6 | | | | | Q. 2 | Give the reason for the popularity of the
client-server architecture?
a) applications distributed data and applications
b) need for graphical user interface for end
users.
c) removes the computing load for presentation
services fro |
| | A) | a), b), c), d) and e) |
| B) | a), c) and e) | | C) | b), and e) | | D) | a), b), c) and d) | | | | | Q. 3 | 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 | | | | | 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 | 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 | | | |
Click here to get
Fundamentals Of Database Management (BC0041)
New Question
Home > Download > SMU - Question Paper
> BCA > BC0041