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

programmer2programmer.net

 Tips
 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
  2017 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#
 ASP.Net
 SQL Server
  Oracle and DBA
 My SQL
  

100% Tested
Ready Academic IT Projects

BE, ME, BTech, BCA, MCA, MBA, Bsc-IT, MS, BIT, ADIT, DOEACC, IGNOU, SMU
readymadeproject.com

Free download of Sikkim Manipal University, SMU previous year, last year, sample question paper for  : [DBMS & SQL server] MT0034. 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.   DBMS & SQL server , MT0034 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact
 

   SMU >> MSc IT >> MT0034

   DBMS & SQL server

This is the collection of Sikkim Manipal University (SMU) question paper for MSc IT - DBMS & SQL server. 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 2017, 2016, 2015 SMU question papers of DBMS & SQL server 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      
MT0034 (DBMS & SQL server)

Get Questions        PART - A    PART - B    PART - C


DBMS & SQL server Syllabus.

Unit 1: Database Management System
Introduction, Data processing requirements, Data flow diagrams, DBMS characteristics, Problems with traditional systems, Three schema architecture, DBMS history, Data models, E-R model, Relationship, Ternary relationship

Unit 2: Relational Data Model, Constraints and Relational Algebra
Introduction, Relational Database, Constraints, Data Integrity, Relational algebra, Database planning, Steps in database planning, Database design, Conversion of e-r diagram to relations, Introduction to normalization.

Unit 3: Query language-SQL
Introduction, Data types, DDL statements, Data manipulation language, Data control language

Unit 4: Normalization and Data Storage Devices
Introduction, Functional dependency, Decomposition of relations, Normalization, Schema design, Axioms for fds and mvds, Fourth normal form, Fourth generation languages, Data storage devices, File systems.

Unit 5: Model Review, System Architecture and Optimization
Introduction, Hierarchical data model, Network data model, HDMS : a typical DBMS, Transaction model, Client-server architecture, Query tree and query operators, Query optimization

Unit 6: Security, Integrity and Information Quality
Introduction, Security and Integrity Threats, Security, Information Quality, Privacy etc.

Unit 7: Introduction to Databases
Introduction to Databases, Basic Database Concepts, Characteristics of a Database Management System, Relational model, Characteristics of a Relational DBMS Model, Relational Database Objects, TABLES, UNIQUENESS AND KEYS, Normalization, History, Normal Forms, First normal form, Second normal form, Third normal form (3NF), Boyce-Codd normal form, Fourth normal form, Fifth normal form, Domain/key normal form, Sixth normal form

Unit 8: Introduction to SQL
SQL Server 2005 Overview, Layout of the SQL Server 2005 Data Platform, Structured Query Language, Enhancements in Transact-SQL, Query Notification, Platforms, Integration with Microsoft Back office, Client/Server Architecture, The components in the communication architecture include: Client Application, Application Development Architecture, Database Architecture, System Database, Database Implementation, SQL Server 2005 System Tables and Views, System Views, Information Schema, SQL Server Components, Server Software, SQL Server Service, SQL Server Administration Tools & Wizards, Full support of SQL Server 2005, New state-of-the-art graphical user interface, Rapid database management and navigation, Easy management of all SQL Server objects, Advanced data manipulation tools, Effective security management, Excellent visual and text tools for query building, Report designer with clear in use report construction wizard, Impressive data export and import capabilities, Visual Database Designer to handle database structure in a few clicks, Easy-to-use wizards performing SQL Server administrative tasks, Other useful tools to make your work with SQL Server as easy as it can be, SQL Server Configuration Manager, Surface Area Configuration Tool, SQL Server Management Studio

Unit 9: Installing and Configuring SQL Server 2005
SQL Server 2005 Editions, Versions for SQL Server 2005, Hardware and Software Requirement, System Requirements, Hardware and Software Requirements, Cluster Hardware Requirements, Network Software Requirements, Internet Requirements, Software Requirements, Understanding SQL Server Installation Options, Licensing Mode, Character Set, Default Installation path, SQL Server Logon Account, Using a Domain User Account, Auto Start Services, Running SQL Server 2005 Setup Program, Starting and stopping SQL Services, Configuration Manager, Connecting to SQL Server, SQLCMD, Using Graphical Utility

Unit 10: Building a Database
Database Consideration, DevicesCreating Databases, Allocating Units, Transaction Log, Managing Databases, Creating Database Devices, Creating Tables, Object Explorer MANAGING DATABASES, Managing Data and Log File Growth, Expanding Database and Log Files, Adding secondary database files, Creating Filegroups, DROPPING DATABASE, TABLES, CREATING TABLE, ALTERING TABLES, Adding a Column, Dropping a Column, Dropping Tables, Data Types (Transact-SQL), SQL Server Data Types and Their .NET Framework Equivalents

Unit 11: Retrieving & Managing Data
Introduction, Select System (T-SQL), Using comparison operators, Using String Comparisons, Using Logical Operators, Retrieving a Range of Values, Retrieving a List of Values, Sorting Result Sets, Additional Language Elements, Local and Global Variables, Operators, Functions, Control-Of-Flow Statements, Local Variables (User defined), Global Variables (System supplied), Operators (T-SQL), Arithmetic Operators, Assignment Operator, Bitwise Operators, Comparison Operators, Locical Operators, String Concatenation Operator, Unary Operators, Operator Precedence, Enhancements in T-SQL, Functions, Mathematical Function, String Functions, Date Functions, Data Conversion Functions, Control of Flow Language Elements, Ways to Execute Transact-SQL statements, Dynamically Constructing Statements, Using Transactions, Constraints, Naming Conventions, Determining Which type of constraint to use, Disabling Constraint Checking, Disabling Constraint Checking on Existing Data, Disabling Constraint Checking when loading new data, Impleting Indexes, Use the CRETE INDEX statement to create an Index, Use the DROP INDEX statement to Drop an Index, Data Ingegrity, Entity Integrity, domain Integrity, Referential Integrity

Unit 12: Views, Triggers and Stored Procedures
Views: Advantages of Views, Disadvantages of View, A view is used to do any or all of these functions, Dropping Views, Renaming Views, What is an Indexed View?, What’s new for Indexed Views in SQL Server 2005 ?, Group by Restrictions Triggers: Characteristics of a Trigger, Creating Triggers, Magic Tables, The INSERT Trigger, Delete Trigger, The ALTER TRIGGER, The DROP TRIGGER Command, Triggers and Data Integrity, Multiple Triggers, AFTER and SNSTEAD of Triggers Stored Procedures: Details of the CLR Integration, The NET Framework, CLR Integration, Interactively Using the sqlcmd Utility, Using a sqlcmd Startup Script, Using the Query Editor to build a sqlcmd Script
Cursors : Structure of Cursors, Cursor Types, The four APL serve cursor types supported by SQL Server, Declaring Cursors, Opening Cursors, FETCH Statement, Closing Cursors, Deallocate Cursors, Control of Flow Language

  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-2017