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 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 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 | SQL server supports the_________ |
| A) | SMP |
| B) | NNTP | | C) | HTTP | | D) | None of the above | | | | Q. 2 | SQL *Plus is used by Database administrator to ____ |
| A) | Specify rights and privileges to users |
| B) | Query and retrieve data from the database | | C) | Generate reports | | D) | All the above | | | | Q. 3 | An extent is ____ contiguous pages or ____ KB |
| A) | 8, 64 |
| B) | 10,640 | | C) | 4, 16 | | D) | 16, 960 | | | | Q. 4 | In which of the following situations, sequential file organization is not preferred? |
| A) | In which of the following situations,
sequential file organization is not preferred? |
| B) | For intermediate results of operations | | C) | For small files | | D) | None of these | | | | 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 | __________ is a user interface for Microsoft back office server management . |
| A) | Microsoft Management console |
| B) | Microsoft distributed transaction coordinator | | C) | Microsoft system management server | | D) | Non of the above | | | | Q. 7 | Select the wrong statement |
| A) | A primary key is a minimal superkey |
| B) | An entity may have many candidate keys | | C) | A weak entity is always related to one or
more strong entities | | D) | All the above | | | | Q. 8 | The number of attributes in a relation is called as its ____ |
| A) | Cardinality |
| B) | Degree | | C) | Tuples | | D) | Entity | | | | Q. 9 | The captured data has to be classified based on the nature and intended usage is ____ |
| A) | Data capture |
| B) | Data classification | | C) | Data arranging | | D) | Data coding | | | | Q. 10 | The________ is essentially used to search for patterns in target string |
| A) | Like Predicate |
| B) | Null Predicate | | C) | In Predicate | | D) | Out Predicate | | | |
Click here to get
Database Management System (DBMS and Oracle 9i) (MC0067)
New Question
Home > Download > SMU - Question Paper
> MCA > MC0067