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 - C
| Q. 1 | WHICH OF THE FOLLOWING IS THE EXAMPLE OF NUMBER FUNCTIONS
1) ABS(DATA)
2) CEIL(DATA)
3) FLOOR(DATA)
4) TRUNC(DATA,N)
5) INITCAP(DATA)
6) LENGTH(DATA) |
| | A) | 1,2,3,4 |
| B) | 1,2,3,4,5 | | C) | 1,2,3,4,6 | | D) | 1,2,3 | | | | | Q. 2 | WHICH OF THE FOLLOWING IS TRUE FOR SUBQUERIES
1) THE NESTED QUERY MUST RETURN A SINGLE COLUMN
2) THE RESULT CAN ONLY CONTAIN COLUMNS FROM THE TABLES REFERENCED IN THE OUTERMOST QUERY
3) THE NESTED QUERY MUST RETURN A SINGLE ROW WHEN A STANDARD |
| | A) | 2,3,4,5 |
| B) | 1,2,3,4 | | C) | 2,3,5 | | D) | 1,2,3,4,5 | | | | | Q. 3 | VIEWS CANNOT BE UPDATED IF IT CONTAINS
1) JOINS
2) SET OPERATORS
3) GROUP FUNCTIONS
4) GROUP BY CLAUSE
5) DISTINCT |
| | A) | 1,3,4,5 |
| B) | 1,2,3,4,5 | | C) | 1,2,3,4 | | D) | 1,2,4,5 | | | | | Q. 4 | WHICH OF THE FOLLOWING IS RULES FOR TABLE AND COLUMN NAMES
1) NAMES CAN BE UPTO 30 CHARACTER
2) NAMES MUST BEGIN WITH AN ALPHABET
3) NAMES CANNOT CONTAIN QUOTES
4) NAMES ARE NOT CASE SENSITIVE
5) NAMES CAN CONTAIN CHARACTERS A-Z, 0-9, |
| | A) | 2,3,4,5,7 |
| B) | 1,2,3,5,6,7 | | C) | 1,2,3,5,7 | | D) | 1,2,3,4,5,6,7 | | | | | Q. 5 | WHICH OF THE FOLLOWING ARE THE TYPES OF FUNCTIONS
1) CHARACTER FUNCTION
2) AGGRERATE FUNCTION
3) NUMBER FUNCTION
4) CONVERSION FUNCTION
5) LIKE FUNCTION |
| | A) | 1,2,3,4,5 |
| B) | 1,2,3,4 | | C) | 1,2,3 | | D) | 1,3,4 | | | |
Click here to get
Oracle 9i (MT0046)
New Question
Home > Download > SMU - Question Paper
> MSc IT > MT0046