Home > Download > SMU - Question Paper
> MCA > MC0067
Database Management System (DBMS and Oracle 9i)
This is the collection of
Sikkim Manipal University (SMU) question and answers for Database Management System (DBMS and Oracle 9i). 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 Database Management System (DBMS and Oracle 9i), SMU - Master of Computer Application.
Course Name
MCA (Master of Computer Application)
Subject Code MC0067 (Database Management System (DBMS and Oracle 9i))
Get Questions
PART - A
PART - B
PART - C
Subject : Database Management System (DBMS and Oracle 9i)
MC0067 : PART - C
| Q. 1 | To locate required block on a track is called
latency time. It is also known as ______ |
| | A) | Seek-time |
| B) | Rotational delay | | C) | Rotational Time | | D) | Transfer Rate | | | | | Q. 2 | 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
when a standard operator such as < is used
4. The nested query must return a single
column
5. The result can only contain columns from the
tables referenced in the outermost query |
| | A) | 2, 3, 4, 5 |
| B) | 1, 2, 3, 4, 5 | | C) | 1, 3, 4, 5 | | D) | 1, 2, 3, 4 | | | | | Q. 3 | 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 following is the best result of the same
after applying 3NF rule? |
| | 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. 4 | 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 incorporate the requirements of the
organization, system should be designed for
easy maintenance.
4. Information systems should allow interactive
access to data to obtain new information
without writing fresh programs.
5. Data should be stored with minimum
redundancy to ensure consistency in stored
data across different application. |
| | A) | 1, 3, 4, 5 |
| B) | 2, 3, 4, 5 | | C) | 1,2,3,4 | | D) | 1, 2, 3, 4, 5 | | | | | Q. 5 | 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
b. If x y is implied & z is subset of y, then x ---
* z is implied
c. x -4 y is true if y is subset of x
d. If x -4 y is true, then xz -> yz is also true |
| | 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 | | | |
Click here to get
Database Management System (DBMS and Oracle 9i) (MC0067)
New Question
Home > Download > SMU - Question Paper
> MCA > MC0067