Welcome to www.programmer2programmer.net tips for SMU Question Paper for MT0046


 Microsoft Certification
 Final Year Project Idea
 Connection Strings
 Password Recovery
 SQL Injection
 Encryption & Decryption
 LIVE Academic Project
 Project #1 - VB6, Access
  Project #2 - VB.Net, SQL
 Project #3 - ASP, Access
 Project #4 - ASP.NET, C#
 Project #5 - VB6, SQL
 Project #6 - Stegano
 Project #7 - C
 Project #8 - C++
 Project #9 - JAVA, MySQL
 Project #10- PHP, MySQL
 Project #11- JSP, Oracle
 Project #12- C# Face Exp
 Project #13- Mobile Bank
 Download MBA Project
 MBA Project Topic
 Project Viva Question
  2018 New Projects
 Project Synopsis Download
 University Question Paper, Assignment and Projects
 SMU - Question Paper
 SMU - Assignment
 SMU - Synopsis Projects
 SCDL - Assignment
 IGNOU - Synopsis Projects
 Welingkar - Projects
 Project Report Formats
 Interview Question Answer
 General & HR Round
 Visual Basic 6
 VB.Net & C#
 SQL Server
  Oracle and DBA

100% Tested
Ready Academic IT Projects


Free download of Sikkim Manipal University, SMU previous year, last year, sample question paper for  : [Oracle 9i] MT0046. Find question and answer for Part-A 2 marks, Part-B 4 Marks and Part-C 8 marks. Free download of question paper of previous year test.   Oracle 9i , MT0046 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact

   SMU >> MSc IT >> MT0046

   Oracle 9i

This is the collection of Sikkim Manipal University (SMU) question paper for MSc IT - Oracle 9i. It will help you to prepare your examination. All questions are classified as per question type like PART - A of 2 marks, PART - B of 4 marks and PART - C of 8 marks same as actual examination. SMU question paper set which includes year 2018, 2017, 2016 SMU question papers of Oracle 9i are updated regularly and it is absolutely free to use. SMU Question paper includes multiple choice question and answer as same as real and original examination. It will help you to study and prepare for your final SMU examination.

Sikkim Manipal University
SMU Question Paper
Latest and Updated
FREE to Download
  1. BCA
  2. MCA
  3. BSc IT
  4. MSc IT
  5. MBA

   Get SMU Assignment   

Course Name
        MSc IT (Master of Science in Information Technology)

Subject Code      
MT0046 (Oracle 9i)

Get Questions        PART - A    PART - B    PART - C

Oracle 9i Syllabus.

Unit 1: Introduction to Oracle9i Database
Oracle Database an Introduction, Oracle Instance ,Oracle9i Over View, Background Process, INIT. Ora, Location Entries, Limiting Entries, Feature Entries, Control Files, Redo
Logs , Oracle Data Files , Significant Memory Structures , Logical Structures, Data Blocks, Extents, Segments, Table Spaces, Physical Database Structure, Oracle9i Products for
Installation , Oracle9i Database, Oracle9i Client

Unit 2: SQL with Oracle9i Database
Introduction, Oracle9i SQL, SQL Standards, How SQL Works, Data Definition Language (DDL), Create/Drop Statement, Create Table as, an Example Command to alter a Table ,
Truncate, Constraints, Data Types, Data Manipulation Language (DML) , Insert Statement, Select Statement Update Command, Delete Command, Operators in SQL *Plus Arithmetic
Operators, Comparison Operators , Logical Operators, SQL *Plus Functions, Single Row Functions, Date Functions, Character Functions Numeric Functions, Conversion Functions, Miscellaneous Functions

Unit 3: More SQL *Plus
Set Operators and Joins, Joining Table, Simple join, Equi-join, Non equi-join Self join, Outer join, More Database Objects, Views, Create view, an example Partition View, Object
view, Synonym, Sequences, Index. Partitioning Basics of Partitioning, Benefits of Partitioning, Locks and SQL *Plus Formatting Commands, Row level locks, Table level lock , Share lock , Share update lock , Exclusive lock, SQL *Plus Formatting Commands, Column commands Compute commands, Title commands, Setting Page Dimensions

Unit 4: Introduction to Java in Oracle9i
Introduction, Impression of Java, Java and Object-Oriented Programming Terminology, Interfaces, Polymorphism, The Java Virtual Machine (JVM) Key Features of the Java Language, Why Use Java in Oracle9i?, Multithreading, Automated Storage Management, Footprint, Performance Oracle’s Java Application Strategy, JDBC Drivers, Dynamic HTML Invoking Java, Servlets JavaServer Pages, Distributed Application Development

Unit 5: PL/SQL
Introduction, PL/SQL: The Oracle Programming language, PL/SQL Character Set PL/SQL Structure, PL/SQL variables, Conditional statements , Loops, CASE Statements, Exception Handling Section, Stored Procedures

Unit 6: Distributed Database
Distributed Databases Overview, Distributed Database Architecture, Homogenous Distributed Database Systems, Heterogeneous Distributed Database Systems, Client/Server Database Architecture, Database Links, Database Links and their uses:, Distributed Database Administration, Transaction Processing in a Distributed System, Distributed Database Application Development, Transparency in a Distributed Database System Remote Procedure Calls (RPCs), Distributed Query Optimization

Unit 7: Managing a Distributed Database
Introduction, Managing Global Names in a Distributed System, Understanding How Global Database Names Are Formed , Determining Whether Global Naming Is Enforced, Viewing a Global Database Name, Changing the Domain in a Global Database Name, Creating Database Links, Obtaining Privileges Necessary for Creating Database Links, Specifying Link Types Specifying Link Users, Using Connection Qualifiers to Specify Service Names Within Link Names, Creating Shared Database Links, Configuring Shared Database Links, Managing Database Links, Limiting the Number of Active Database Link Connections, Viewing Information About Database Links, Determining Which Links Are in the Database, Determining Which Link Connections are Open

Unit 8: Distributed Transactions
Introduction, Operations In Distributed Transactions, DML And DDL Transactions, Transaction Control Statements, Session Trees For Distributed Transactions, Distributed Transaction Commit, Prepare Phase, Commit Phase, Forget Phase

  Get Questions        PART - A    PART - B    PART - C

 Click here to get more question paper of MCA, BCA, BSC IT, MSC IT, MBA of SMU

(C) Atanu Maity, 2006-2018