Home > Download > SMU - Question Paper > BSc IT > BT0075

RDBMS and MySQL

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

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.

Home > Download > SMU - Question Paper > BSc IT > BT0075