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 - A
| Q. 1 | To sort data in ascending or descending
order _______ clause is used |
| | A) | Sort |
| B) | Where | | C) | Group by | | D) | Order by | | | | | Q. 2 | __________contains data assisting day to
day activities of the organisation |
| | A) | Control database |
| B) | Operational database | | C) | Strategic database | | D) | Sequential database | | | | | Q. 3 | In an ER model, ____ is described in the
database by storing its data. |
| | A) | Entity |
| B) | Attribute | | C) | Relationship | | D) | Notation | | | | | Q. 4 | ______ is the activity where the data is
converted into one form into another. |
| | A) | Data transcription |
| B) | Data transmission | | C) | Data verification | | D) | Data retrieval | | | | | Q. 5 | Relationship of department with employer is
an example for.________ relationship |
| | A) | one to one |
| B) | many to one | | C) | one to many | | D) | many to many | | | | | Q. 6 | The SQL server services includes
_________ |
| | A) | SQL server agent |
| B) | Microsoft distribution transaction coordinator | | C) | Both a& b | | D) | Non of the above | | | | | Q. 7 | The main task carried out in the_________
is to remove repeating attributes to separate
tables |
| | A) | First Normal form |
| B) | Second Normal form | | C) | Third Normal form | | D) | Fourth Normal form | | | | | Q. 8 | Anything that affects the database schema
is a part of |
| | A) | DML |
| B) | DCL | | C) | DDL | | D) | All of the above | | | | | Q. 9 | The DBMS utility, ____ allows to
reconstruct the correct state of database from
the backup and history of transactions |
| | A) | Backup |
| B) | Recovery | | C) | Monitoring | | D) | Data loading | | | | | Q. 10 | In DBMS, ____ refers to the rights of
individuals and organizations so that they can
decide who could be permitted access to their
data |
| | A) | Data Integrity |
| B) | Security | | C) | Privacy | | D) | Correctness | | | |
Click here to get
Database Management System (DBMS and Oracle 9i) (MC0067)
New Question
Home > Download > SMU - Question Paper
> MCA > MC0067