Home > Download > SMU - Question Paper
> MSc IT > MT0046
Oracle 9i
This is the collection of
Sikkim Manipal University (SMU) question and answers for 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 Oracle 9i, SMU - Master of Science in Information Technology.
Course Name
MSc IT (Master of Science in Information Technology)
Subject Code MT0046 (Oracle 9i)
Get Questions
PART - A
PART - B
PART - C
Subject : Oracle 9i
MT0046 : PART - A
| Q. 1 | _______ files allocate space to table spaces
that make up the logical database |
| | A) | Control files |
| B) | Data files | | C) | Redo files | | D) | Log files | | | | | Q. 2 | WHICH OF THE FOLLOWING IS INFORMATIVE MESSAGES THAT ARE APPLICATOIN SPECIFIC AND GENERATED BY CERTAIN TRANSACTIONS |
| | A) | ALERTS |
| B) | SECURITY | | C) | PROCEDURES | | D) | TRIGGERS | | | | | Q. 3 | HOW MANY SET OPERATOR DOES ORACLE SUPPORT |
| | A) | TWO |
| B) | THREE | | C) | FOUR | | D) | FIVE | | | | | Q. 4 | IN HOW MANY CATEGORIES DOES SQL COMMANDS FALLS |
| | A) | TWO |
| B) | THREE | | C) | FOUR | | D) | NONE OF THE ABOVE | | | | | Q. 5 | TO CREATE TABLES AND MANIPULATE THE DATA WITHIN TABLES ORACLE PROVIDES THE DATABASE ACCESS LANGUAGE CALLED |
| | A) | SQL |
| B) | SLQ | | C) | ACCESS | | D) | NONE OF THE ABOVE | | | | | Q. 6 | WHICH COMMAND IS USED WHEN THE SQL SELECT STATEMENT IS EXPECTED TO RETURN MORE THAN ONE ROW |
| | A) | PACKAGES |
| B) | FUNCTIONS | | C) | CURSORS | | D) | NONE OF THE ABOVE | | | | | Q. 7 | HOW MANY MODES DOES PARAMETER HAS |
| | A) | TWO |
| B) | THREE | | C) | FOUR | | D) | NONE OF THE ABOVE | | | | | Q. 8 | ________ process automatically saves copies
of redo logs in a DBA – specified storage
location when media recovery is enabled |
| | A) | Oracle |
| B) | Archiver | | C) | Both A and B | | D) | Neither A nor B | | | | | Q. 9 | PL/SQL CODE IS GROUPED INTO STRUCTURES CALLED |
| | A) | BLOCKS |
| B) | SECTION | | C) | TRIGGERS | | D) | PACKAGE | | | | | Q. 10 | ________ is / are key files that the Oracle
DBMS maintains about the state of the
database |
| | A) | Log files |
| B) | Redo file | | C) | Control files | | D) | None of above | | | |
Click here to get
Oracle 9i (MT0046)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0046