Question
SQL Queries:
Answer :
Word Count : 1258
_________ ____ _________ ________ ___ _____ ___.
_____ __________ ______ ______ ________ _____ ______ ___ _______ _____.
________ ___ ______ _________ ___ ___.
___ ________ __________ ________ ________ _________.
_______ _________ ____ ________ ______ ___ _______ ______ _________ ________.
__________ _________ _______ ________ _________ ___ ____ _____ _____ _________.
____ ___ ____ _____ _______ ___.
_________ ____ ______ _______ _______ _______ ___ ____ __________ __________.
_________ _______ _____ ________ ________ ___ ____ ____ _________.
___ ______ ___ ____ __________ ______ ________ ____ _____ ____ ____.
__________ ________ _______ ____ ________ ____ _____ ____ _______ ________.
___ _________ ______ ________ _________ _______ ____.
_______ _____ ____ _____ ___ ______.
____ _________ _________ _________ _____ ___ ________ ______ ______.
_____ _________ _________ ________ _______ __________ ______ _______ ____ ___.
___ ___ _________ ______ _______ ____ _____ _______ _____ ___ ______.
__________ ______ ____ ________ _________.
______ _______ ________ ____ ___ _______ ______ __________ ______ _______.
_____ _______ ________ __________ ___ ____ ____ ________ __________.
________ _________ _______ ________ _____.
_________ __________ _______ __________ ________ ______ ___.
____ _____ _______ _________ _________ _______ ______ ______.
_____ _______ ____ _________ ________ __________ ___ __________.
___ _______ _____ _____ _____ ______ __________ __________ ________ ______ ___ _________.
_______ _________ ________ ______ _______ _________ _________.
_____ ___ _________ _________ _________ ________ ____ ___ _________ ________ _________ ________.
____ _____ _____ ___ ________ ____ ________ ______ __________.
______ _____ ___ __________ __________ ______.
______ ________ _____ _____ ________ ____ _______ _______ ____ _______ ________ __________.
________ ______ _______ ______ ______ __________ ___ _____ ___ ______.
_________ ____ _____ ___ ______ __________ _____.
____ _______ _____ ___ _______ ________ ________ ______ ________ _________ _________ _______.
__________ ______ _______ _______ _______ _____.
__________ ____ ______ ___ ______ __________.
_____ __________ ________ _____ ______ __________.
__________ __________ _____ _________ _________ _____ ________ ______ ______ _________.
___ __________ _____ _______ ______ _______ _________ ______ _______ ______.
____ _______ ____ ____ _________ ______ _____ ________ _______ __________ ______ ________.
____ _______ ________ ____ ______ ____ __________ _____.
_______ __________ __________ _________ ___ ________ ___.
_______ _________ ____ ____ _________ _____ _______.
__________ ____ _______ ____ _____ _________ _________ _________ _________ _____ ___ _________.
_____ _______ _________ ____ ______ __________ ___ ___.
________ _____ ________ ____ ____ ____ __________ __________ ___.
______ ___ __________ __________ _______ __________ ______ _______ _______ ________ ___ ___.
___ ________ _________ ________ ________ _________ ________ ______ __________.
______ ________ _______ _____ ______ _____ _______ ________ _______ ____ _________ _____.
_______ ____ ______ ______ _____ _____ ________ _____ ________ _________ ___ __________.
________ _______ _____ _______ _______ ___ _____ ____ ________.
__________ _________ ________ ______ _______ ____ ________.
_____ __________ ______ _________ ________ ______ _____.
_____ __________ _____ _______ ______ ____ ___ ____ _____ _________.
__________ _______ ____ ________ ____ _______ _________ __________ _____ _____.
_________ ____ _________ ___ _________ _________ ________ ______ _____ _________.
_________ _______ ______ ___ __________ _________.
___ _____ ___ _______ _________ _______ _____ _______ ________ ____.
________ _____ _____ ____ ______ _____ ___ _______ ______ ___ _______ ____.
_________ ____ ___ ________ ____ _____ ____ ________.
___ _____ ___ _____ ______.
__________ ________ ___ ________ ___ ______.
___ ____ ___ ______ ________.
___ ___ ________ ___ ____ __________ _______ __________ _________ _________ ____.
_____ _____ __________ ___ _____ __________ ____.
___ _________ ____ __________ _______ __________ _________ _________ ____ _____ _______.
__________ _____ ___ ___ _________.
___ ____ _________ ______ _______ _____ _______ ______ ___ _______ ______.
____ ___ ___ __________ _______.
_________ ______ ___ ___ ______ _______ ____ ____ _______.
_____ ________ _________ ______ ____ ______.
___ ___ _________ ______ _______ ___ ________.
________ ___ _______ ________ __________ __________ _____.
___ ________ _________ __________ ____ _____.
_________ _______ ____ ____ ___ _______ ___ _______ ____ _________ _________.
_________ _________ _____ _________ ________ _____ _______ ____ ______ ______.
____ ______ ___ ____ ________ _________ _________ ___ ___ _____.
__________ _________ _________ ______ ______ ______ _____ __________ _______ ___ _________.
______ ________ ____ _____ _________ ___ ______ ________ ______.
_________ ______ ___ __________ _________ _______ _______.
_______ ___ __________ _________ _____ ________ _____ ___ ____ __________ ____.
____ ________ ___ _________ _____ ____ _____ ________ _______ __________ ______.
____ _______ ________ __________ __________.
________ _______ ___ ______ ______ _________ ______ ____.
___ _____ ________ ___ _____.
________ ____ ____ __________ ____.
____ _________ ________ ________ _______ ______ _____ ___.
____ ___ ____ ___ __________ __________ _____.
____ ______ ___ ____ __________ _________ __________ ________ ______ _____ ___.
_______ ______ _____ ________ _____ _________ _______ _________ _______ ________ ___.
__________ _____ ______ ____ _________ _______ ______ ________.
______ ______ _____ ___ ______ _________ _________ ________ _____ ______ ________.
_______ _______ ______ ______ ___ ______ ____ ____.
____ ________ _______ _____ _______ ___.
_____ ________ __________ _____ ______ ______.
_____ _________ _________ _________ ___ _______ ______ ____ _____.
______ _______ _____ ___ _____ ______ ______ ________.
_________ ________ _________ _________ __________ _________ _______ ______ _______ _________ ____.
____ _________ _______ _________ _____.
_______ ________ ________ ___ ______ ___ ____ ____ _____.
____ __________ _______ ______ _____ ______ ______ _______.
_________ ____ __________ ________ ______.
____ ___ _______ _______ ________ __________ ___ ______ _____ ______ _________.
_________ _____ ________ _____ ___ ________ _______ _______.
_______ ___ ____ ______ ___ _______ __________ _____ _____ _______ ____.
_____ ______ _______ _____ ___ _____ _______ __________ ____.
____ _______ ____ _____ ________ _________ ____.
__________ ___ ________ ___ ____ ______ ________ ______ ___.
_____ __________ ____ ___ _______ _______ __________.
________ ___ ____ __________ _________ ____ ______ _________ ____ __________.
_________ ____ ________ ___ ______ _________ ________ ______ ________.
________ _________ _________ ____ ________ _______ ___ ______.
_____ _______ _____ _____ _________ ______ ____ _____ ___ _________.
_________ _______ _________ _____ ________ ______ ____ _________ _______ ____ ______.
_______ _________ ______ _______ __________ ____ ____ _____.
_________ _______ ___ ________ _____ _________ __________ __________ ___ _____.
Skip in 10
SQL queries are instructions written in Structured Query Language (SQL) that are used to communicate with a relational database management system (RDBMS). In DBMS and C++ Lab, SQL queries are important because they provide a systematic way to create databases, store data, retrieve required information, modify existing records, and control access to database resources. SQL is widely used with database systems such as MySQL, Oracle, PostgreSQL, and SQL Server. A C++ program can also interact with a database by sending SQL queries through suitable database connectivity libraries or APIs. Therefore, understanding SQL queries is essential for developing database-oriented applications in C++. SQL is generally divided into several categories according to the purpose of the commands. Data Definition Language (DDL) is used to define and modify the structure of database objects. Common DDL commands include `CREATE`, `ALTER`, `DROP`, and `TRUNCATE`. For example, a table named `Student` can be created using: ```sql CREATE TABLE Student ( Student_ID INT PRIMARY KEY, Name VARCHAR(50), Course VARCHAR(30), Marks INT ); ``` This query creates a table with four columns. `Student_ID` is declared as the primary key, which uniquely identifies each student. The `VARCHAR` data type stores character values, while `INT` stores integer values. In a C++ Lab application, such a table could be used to store information entered by students through a program. The `ALTER` command is used to modify the structure of an existing table. For example: ```sql ALTER TABLE Student ADD Email VARCHAR(100); ``` This query adds an `Email` column to the `Student` table. The `DROP` command permanently removes a database object, while `TRUNCATE` removes all records from a table without normally removing the table structure. Data Manipulation Language (DML)
______ ____ _____ __________ _____ ______._________ ____ _________ ________ ___ _____ ___.
_____ __________ ______ ______ ________ _____ ______ ___ _______ _____.
________ ___ ______ _________ ___ ___.
___ ________ __________ ________ ________ _________.
_______ _________ ____ ________ ______ ___ _______ ______ _________ ________.
__________ _________ _______ ________ _________ ___ ____ _____ _____ _________.
____ ___ ____ _____ _______ ___.
_________ ____ ______ _______ _______ _______ ___ ____ __________ __________.
_________ _______ _____ ________ ________ ___ ____ ____ _________.
___ ______ ___ ____ __________ ______ ________ ____ _____ ____ ____.
__________ ________ _______ ____ ________ ____ _____ ____ _______ ________.
___ _________ ______ ________ _________ _______ ____.
_______ _____ ____ _____ ___ ______.
____ _________ _________ _________ _____ ___ ________ ______ ______.
_____ _________ _________ ________ _______ __________ ______ _______ ____ ___.
___ ___ _________ ______ _______ ____ _____ _______ _____ ___ ______.
__________ ______ ____ ________ _________.
______ _______ ________ ____ ___ _______ ______ __________ ______ _______.
_____ _______ ________ __________ ___ ____ ____ ________ __________.
________ _________ _______ ________ _____.
_________ __________ _______ __________ ________ ______ ___.
____ _____ _______ _________ _________ _______ ______ ______.
_____ _______ ____ _________ ________ __________ ___ __________.
___ _______ _____ _____ _____ ______ __________ __________ ________ ______ ___ _________.
_______ _________ ________ ______ _______ _________ _________.
_____ ___ _________ _________ _________ ________ ____ ___ _________ ________ _________ ________.
____ _____ _____ ___ ________ ____ ________ ______ __________.
______ _____ ___ __________ __________ ______.
______ ________ _____ _____ ________ ____ _______ _______ ____ _______ ________ __________.
________ ______ _______ ______ ______ __________ ___ _____ ___ ______.
_________ ____ _____ ___ ______ __________ _____.
____ _______ _____ ___ _______ ________ ________ ______ ________ _________ _________ _______.
__________ ______ _______ _______ _______ _____.
__________ ____ ______ ___ ______ __________.
_____ __________ ________ _____ ______ __________.
__________ __________ _____ _________ _________ _____ ________ ______ ______ _________.
___ __________ _____ _______ ______ _______ _________ ______ _______ ______.
____ _______ ____ ____ _________ ______ _____ ________ _______ __________ ______ ________.
____ _______ ________ ____ ______ ____ __________ _____.
_______ __________ __________ _________ ___ ________ ___.
_______ _________ ____ ____ _________ _____ _______.
__________ ____ _______ ____ _____ _________ _________ _________ _________ _____ ___ _________.
_____ _______ _________ ____ ______ __________ ___ ___.
________ _____ ________ ____ ____ ____ __________ __________ ___.
______ ___ __________ __________ _______ __________ ______ _______ _______ ________ ___ ___.
___ ________ _________ ________ ________ _________ ________ ______ __________.
______ ________ _______ _____ ______ _____ _______ ________ _______ ____ _________ _____.
_______ ____ ______ ______ _____ _____ ________ _____ ________ _________ ___ __________.
________ _______ _____ _______ _______ ___ _____ ____ ________.
__________ _________ ________ ______ _______ ____ ________.
_____ __________ ______ _________ ________ ______ _____.
_____ __________ _____ _______ ______ ____ ___ ____ _____ _________.
__________ _______ ____ ________ ____ _______ _________ __________ _____ _____.
_________ ____ _________ ___ _________ _________ ________ ______ _____ _________.
_________ _______ ______ ___ __________ _________.
___ _____ ___ _______ _________ _______ _____ _______ ________ ____.
________ _____ _____ ____ ______ _____ ___ _______ ______ ___ _______ ____.
_________ ____ ___ ________ ____ _____ ____ ________.
___ _____ ___ _____ ______.
__________ ________ ___ ________ ___ ______.
___ ____ ___ ______ ________.
___ ___ ________ ___ ____ __________ _______ __________ _________ _________ ____.
_____ _____ __________ ___ _____ __________ ____.
___ _________ ____ __________ _______ __________ _________ _________ ____ _____ _______.
__________ _____ ___ ___ _________.
___ ____ _________ ______ _______ _____ _______ ______ ___ _______ ______.
____ ___ ___ __________ _______.
_________ ______ ___ ___ ______ _______ ____ ____ _______.
_____ ________ _________ ______ ____ ______.
___ ___ _________ ______ _______ ___ ________.
________ ___ _______ ________ __________ __________ _____.
___ ________ _________ __________ ____ _____.
_________ _______ ____ ____ ___ _______ ___ _______ ____ _________ _________.
_________ _________ _____ _________ ________ _____ _______ ____ ______ ______.
____ ______ ___ ____ ________ _________ _________ ___ ___ _____.
__________ _________ _________ ______ ______ ______ _____ __________ _______ ___ _________.
______ ________ ____ _____ _________ ___ ______ ________ ______.
_________ ______ ___ __________ _________ _______ _______.
_______ ___ __________ _________ _____ ________ _____ ___ ____ __________ ____.
____ ________ ___ _________ _____ ____ _____ ________ _______ __________ ______.
____ _______ ________ __________ __________.
________ _______ ___ ______ ______ _________ ______ ____.
___ _____ ________ ___ _____.
________ ____ ____ __________ ____.
____ _________ ________ ________ _______ ______ _____ ___.
____ ___ ____ ___ __________ __________ _____.
____ ______ ___ ____ __________ _________ __________ ________ ______ _____ ___.
_______ ______ _____ ________ _____ _________ _______ _________ _______ ________ ___.
__________ _____ ______ ____ _________ _______ ______ ________.
______ ______ _____ ___ ______ _________ _________ ________ _____ ______ ________.
_______ _______ ______ ______ ___ ______ ____ ____.
____ ________ _______ _____ _______ ___.
_____ ________ __________ _____ ______ ______.
_____ _________ _________ _________ ___ _______ ______ ____ _____.
______ _______ _____ ___ _____ ______ ______ ________.
_________ ________ _________ _________ __________ _________ _______ ______ _______ _________ ____.
____ _________ _______ _________ _____.
_______ ________ ________ ___ ______ ___ ____ ____ _____.
____ __________ _______ ______ _____ ______ ______ _______.
_________ ____ __________ ________ ______.
____ ___ _______ _______ ________ __________ ___ ______ _____ ______ _________.
_________ _____ ________ _____ ___ ________ _______ _______.
_______ ___ ____ ______ ___ _______ __________ _____ _____ _______ ____.
_____ ______ _______ _____ ___ _____ _______ __________ ____.
____ _______ ____ _____ ________ _________ ____.
__________ ___ ________ ___ ____ ______ ________ ______ ___.
_____ __________ ____ ___ _______ _______ __________.
________ ___ ____ __________ _________ ____ ______ _________ ____ __________.
_________ ____ ________ ___ ______ _________ ________ ______ ________.
________ _________ _________ ____ ________ _______ ___ ______.
_____ _______ _____ _____ _________ ______ ____ _____ ___ _________.
_________ _______ _________ _____ ________ ______ ____ _________ _______ ____ ______.
_______ _________ ______ _______ __________ ____ ____ _____.
_________ _______ ___ ________ _____ _________ __________ __________ ___ _____.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.