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