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

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  : [RDBMS and MySQL ] BT0075 . 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.   RDBMS and MySQL , BT0075 question paper includes multiple choice options and answer also.

Home Personal Member Forum Source Project Tips Contact
 

   SMU >> BSc IT >> BT0075

   RDBMS and MySQL

This is the collection of Sikkim Manipal University (SMU) question paper for BSc IT - RDBMS and MySQL . 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 RDBMS and MySQL 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
        BSc IT (Bachelor of Science in Information Technology)

Subject Code      
BT0075 (RDBMS and MySQL )

Get Questions        PART - A    PART - B    PART - C


RDBMS and MySQL Syllabus.

Unit 1: Basics of MySQL
Features of MySQL; Top 10 Reasons to use MySQL; MySQL Development Roadmap; Connecting to and Disconnecting from the Server; Accessing and Creating Databases and Tables; Loading Data.

Unit 2: Data Types
Numeric Types; String Types – The CHAR and VARCHAR Types, The BLOB and TEXT Types, The ENUM Type, The SET Type; Date and Time
Types – The DATETIME, DATE, and TIMESTAMP Types, The TIME Type, The YEAR Type, Y2K Issues and Data Types; Column Type Storage Requirements; Choosing the Right Type for a Column; Using Column Types from Other Database Engines.

Unit 3: Data Definition Language (DDL)
CREATE DATABASE; CREATE INDEX; CREATE TABLE; ALTER DATABASE; ALTER TABLE; DROP DATABASE; DROP INDEX; DROP TABLE; DESCRIBE.

Unit 4: Data Manipulation Language (DML)
Loading Data into a Table – INSERT, INSERT ... SELECT, INSERT DELAYED, LOAD DATA INFILE; Retrieving Information from a Table – Retrieving Specific Rows and Columns, Sorting Query Results, Grouping Query Results.

Unit 5: Advanced Data Manipulation Language
JOIN; UNION; DELETE; TRUNCATE; UPDATE; DO; HANDLER; REPLACE.

Unit 6: Subqueries
The Subquery as Scalar Operand; Comparisons Using Subqueries; Subqueries with ANY, IN, and SOME; Subqueries with ALL; Correlated Subqueries; EXISTS and NOT EXISTS; Row Subqueries; Subqueries in the FROM clause;

Unit 7: Operators and Functions
Operators – Parentheses, Comparison Operators, Logical Operators, Case Sensitive Operators; Control Flow Functions; String Functions; Numeric Functions – Arithmetic Operators, Mathematical Functions; Date and Time Functions.

Unit 8: Advanced Functions
Full-text Search Functions – Boolean Full-text Searches, Full-text Searches with Query Expansion, Full-text Restrictions, Fine-tuning MySQL Full-text Search, Full-text Search TODO; Cast Functions; Other Functions – Bit Functions, Encryption Functions, Information Functions; Functions and Modifiers for Use with GROUP BY Clauses – GROUP BY (Aggregate) Functions, GROUP BY Modifiers.

Unit 9: Transaction Management
START TRANSACTION, COMMIT, and ROLLBACK Syntax; Statements that cannot be Rolled back; Statements that cause an Implicit Commit; SAVEPOINT and ROLLBACK TO SAVEPOINT Syntax; LOCK TABLES and UNLOCK TABLES Syntax; SET TRANSACTION Syntax.

Unit 10: Stored Procedures
Stored Procedure and Routines; Maintaining Stored Procedures – CREATE PROCEDURE and CREATE FUNCTION, ALTER PROCEDURE and ALTER FUNCTION, DROP PROCEDURE and DROP FUNCTION, SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION; SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS; CALL Statement.

Unit 11: Control Statements
BEGIN ... END Compound Statement; DECLARE Statement; Variables in Stored Procedures; Variable SET Statement; SELECT ... INTO Statement; DECLARE Conditions and Handlers; Flow Control Constructs – IF Statement, CASE Statement, LOOP Statement, LEAVE Statement, ITERATE Statement, REPEAT Statement, WHILE Statement; Cursors – Declaring Cursors, Cursor OPEN Statement, Cursor FETCH Statement, Cursor CLOSE Statement.

Unit 12: User Account Management
Adding New User Accounts to MySQL; MySQL Usernames and Passwords; Securing the Initial MySQL Accounts; Removing User Accounts from MySQL; Limiting Account Resources; Assigning Account Passwords; Keeping Your Password Secure; Account Management Statements – DROP USER Syntax, GRANT and REVOKE Syntax, SET PASSWORD Syntax.

Unit 13: General Security Issues
General Security Guidelines; Making MySQL Secure Against Attackers; Startup Options for mysqld concerning security; Security Issues with LOAD DATA LOCAL. Unit 14: Log Files Error Log; The General Query Log; The Binary Log; The Slow Query Log; Log File Maintenance.

  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