Answer the following questions: a) Define RDBMS. Name any two RDBMS software. b) What is the purpose of the fo

Exercises · Q1

Q. Answer the following questions:

a) Define RDBMS. Name any two RDBMS software.

b) What is the purpose of the following clauses in a select statement?

i) ORDER BY

ii) GROUP BY

c) Site any two differences between Single Row Functions and Aggregate Functions.

d) What do you understand by Cartesian Product?

e) Differentiate between the following statements:

i) ALTER and UPDATE

ii) DELETE and DROP

f) Write the name of the functions to perform the following operations:

i) To display the day like "Monday", "Tuesday", from the date when India got independence.

ii) To display the specified number of characters from a particular position of the given string.

iii) To display the name of the month in which you were born.

iv) To display your name in capital letters.

Puducherry TnboardTextbookSubjective· 3mImportance★★★★★

43% · 41/95 Questions

✓ Free question

Concept understanding — SQL Query Concepts

SQL Query Concepts — A First Look

Think of a library. You walk in, and instead of wandering through endless shelves, you go to the librarian and say: "Give me all the books by Tagore published after 1950, sorted by title." The librarian knows exactly where everything is, finds what you asked for, and hands you the list. That's what SQL does — but for data stored in a computer.

SQL stands for Structured Query Language. It is the language we use to talk to databases. A database is just a collection of related information stored in tables — like an Excel workbook with multiple sheets, but far more powerful and organised.

The core idea: tables and queries

A database stores data in tables. Each table has rows (records) and columns (fields). For example, a Students table might have columns like RollNo, Name, City, and Marks. Each row is one student's complete information.

A query is simply a question you ask the database. You write it in SQL, and the database returns an answer — usually a new table made from the data that matches your question.

Note

SQL is not a programming language like Python or Java. You don't tell the computer how to find the data. You only say what data you want. The database figures out the fastest way to get it.

The most common SQL command: SELECT

Almost every query begins with SELECT. It means "show me this data." The basic structure is:

SELECT column1, column2 FROM table_name WHERE condition;

Read it like a sentence: "Select these columns from this table where this condition is true."

If you want all columns, you write SELECT *. The asterisk is a shortcut meaning "everything."

Filtering with WHERE

The WHERE clause is your filter. It keeps only the rows that satisfy a condition. For example, if you want students from Delhi only, you write:

SELECT * FROM Students WHERE City = 'Delhi';

You can combine conditions using AND (both must be true) and OR (at least one must be true). This is exactly like everyday logic: "Show me students from Delhi AND who scored above 80."

Sorting with ORDER BY

Data often comes back in no particular order. To arrange it, use ORDER BY. You can sort ascending (smallest first, which is the default) or descending (largest first) using DESC.

SELECT Name, Marks FROM Students ORDER BY Marks DESC;

This gives you a ranked list — highest marks first.

Why SQL matters for commerce and humanities

You will never calculate a formula in SQL. That is not what it does. What SQL does is organise, filter, and retrieve information — and that is the foundation of every data-driven decision.

A marketing manager uses SQL to find customers who haven't purchased in six months. An HR analyst uses it to list employees eligible for promotion. A historian might use it to query a database of census records from 1901. The skill is not in memorising syntax but in learning to ask the right questions of your data.

Important

SQL is about precision in asking. A small mistake in a condition — writing City = 'delhi' instead of 'Delhi' — can give you zero results even though the data exists. The database does exactly what you tell it, not what you meant.

A few key points to remember

SQL is case-insensitive for keywords (select works the same as SELECT), but data values are often case-sensitive depending on the database.
Text values must be enclosed in single quotes. Numbers are written without quotes.
Every SQL statement ends with a semicolon (;).
You can combine multiple clauses: SELECT ... FROM ... WHERE ... ORDER BY ...

You do not need to memorise every command today. The real learning begins when you start writing queries and seeing what the database returns. Start with simple SELECT statements, add a WHERE condition, then try sorting. Each time, you are asking the database a question — and it answers instantly.

Here are the answers to your questions:

a) Define RDBMS. Name any two RDBMS software.

A Relational Database Management System (RDBMS) is a software system used to create, manage, and query relational databases. In an RDBMS, data is organized into tables, also known as relations, which consist of rows and columns. These tables are related to each other through common fields, allowing for efficient storage, retrieval, and manipulation of structured data. RDBMS uses SQL (Structured Query Language) for data definition and manipulation.

Two common RDBMS software are:

MySQL
PostgreSQL

b) What is the purpose of the following clauses in a select statement?

ORDER BY The ORDER BY clause is used to sort the result set of a SELECT query. It arranges the rows in ascending (ASC) or descending (DESC) order based on the values of one or more specified columns. If no order is specified, ASC is the default.
GROUP BY The GROUP BY clause is used to group rows that have the same values in specified columns into a summary row. It is typically used with aggregate functions (like COUNT(), SUM(), AVG(), MIN(), MAX()) to perform calculations on each group rather than on the entire result set.

c) Site any two differences between Single Row Functions and Aggregate Functions.

Here are two key differences between Single Row Functions and Aggregate Functions:

Feature	Single Row Functions	Aggregate Functions (Group Functions)
Input & Output	Operate on a single row and return a single result for that row.	Operate on a set of rows and return a single summary result for the entire group.
Usage with GROUP BY	Can be used in `SELECT`, `WHERE`, `ORDER BY` clauses without `GROUP BY`.	Are typically used with the `GROUP BY` clause to summarize data for each group.
Examples	`UPPER()`, `LOWER()`, `LENGTH()`, `SUBSTRING()`, `ROUND()`, `NOW()`	`COUNT()`, `SUM()`, `AVG()`, `MIN()`, `MAX()`

d) What do you understand by Cartesian Product?

A Cartesian Product, also known as a cross join, is the result of joining two tables without any join condition. It combines every row from the first table with every row from the second table. If the first table has $M$ rows and the second table has $N$ rows, the Cartesian Product will result in a table with $M \times N$ rows. This operation is generally avoided unless explicitly needed, as it can produce a very large and often meaningless result set.

e) Differentiate between the following statements:

(i) ALTER and UPDATE

ALTER: This is a Data Definition Language (DDL) statement used to modify the structure of an existing database object, such as a table. Examples include adding a new column, dropping an existing column, modifying a column's data type, or adding/dropping constraints.
- Example: ALTER TABLE Students ADD COLUMN Email VARCHAR(100);
UPDATE: This is a Data Manipulation Language (DML) statement used to modify existing data within the rows of a table. It changes the values in one or more columns for rows that satisfy a specified condition.
- Example: UPDATE Students SET Grade = 'A' WHERE RollNo = 101;

(ii) DELETE and DROP

DELETE: This is a Data Manipulation Language (DML) statement used to remove one or more rows from a table based on a specified condition. If no WHERE clause is provided, all rows are deleted, but the table structure remains intact. DELETE operations can typically be rolled back.
- Example: DELETE FROM Students WHERE Grade = 'C';
DROP: This is a Data Definition Language (DDL) statement used to remove an entire database object (like a table, view, or index) from the database. When a table is DROPped, its structure, data, and all associated indexes and constraints are permanently removed. DROP operations are generally irreversible.
- Example: DROP TABLE Students;

f) Write the name of the functions to perform the following operations:

To display the day like "Monday", "Tuesday", from the date when India got independence. DAYNAME()
To display the specified number of characters from a particular position of the given string. SUBSTRING() (or SUBSTR())
To display the name of the month in which you were born. MONTHNAME()
To display your name in capital letters. UPPER() (or UCASE())
✓Final answer
$The answer provides definitions for RDBMS and Cartesian Product, explains the purpose of ORDER BY and GROUP BY clauses, differentiates between Single Row and Aggregate Functions, and between ALTER vs UPDATE and DELETE vs DROP statements, and lists the SQL functions DAYNAME(), SUBSTRING(), MONTHNAME(), and UPPER() for the specified operations.$

This solution defines RDBMS, explains ORDER BY and GROUP BY clauses, differentiates between single-row and aggregate functions, clarifies the Cartesian Product, distinguishes DDL and DML statements like ALTER vs UPDATE and DELETE vs DROP, and provides specific SQL functions for date and string manipulations.

a) Define RDBMS. Name any two RDBMS software.

A Relational Database Management System (RDBMS) is a software system used to create, manage, and query relational databases. It stores data in a structured format using tables, which consist of rows and columns. The core principle of an RDBMS is the relational model, where data is organized into relations (tables) and relationships between these tables are established using common fields (keys). This structure allows for efficient storage, retrieval, and manipulation of data while maintaining data integrity and consistency. SQL (Structured Query Language) is the standard language used to interact with an RDBMS.

Two popular RDBMS software are:

MySQL
PostgreSQL

b) What is the purpose of the following clauses in a select statement?

The SELECT statement is used to retrieve data from a database. Clauses like ORDER BY and GROUP BY modify how the data is presented or aggregated.

i) ORDER BY

The ORDER BY clause is used to sort the result set of a SELECT query based on one or more specified columns. By default, the sorting is in ascending order (ASC), but it can also be specified as descending (DESC). This clause is crucial when you need to present data in a particular sequence, such as alphabetically, numerically, or chronologically.

Example:

To display student names in alphabetical order:

SELECT StudentName, Age FROM Students ORDER BY StudentName ASC;

ii) GROUP BY

The GROUP BY clause is used to group rows that have the same values in specified columns into summary rows. It is typically used with aggregate functions (like COUNT(), SUM(), AVG(), MIN(), MAX()) to perform calculations on each group, rather than on the entire result set. This allows for analytical queries, such as finding the total sales per region or the average score per class.

Example:

To count the number of students in each class:

SELECT Class, COUNT(StudentID) AS NumberOfStudents FROM Students GROUP BY Class;

c) Site any two differences between Single Row Functions and Aggregate Functions.

Feature	Single Row Functions	Aggregate Functions
Operation Scope	Operate on a single row at a time.	Operate on a set of rows (a group or the entire table).
Return Value	Return one result for each row processed.	Return a single result for the entire set of rows.
Number of Rows	The number of output rows is the same as input rows.	Reduce the number of rows, returning one row per group.
Usage Context	Can be used in `SELECT`, `WHERE`, `ORDER BY` clauses.	Primarily used in `SELECT` and `HAVING` clauses, often with `GROUP BY`.
Examples	`UPPER()`, `LOWER()`, `SUBSTRING()`, `LENGTH()`, `DAYNAME()`	`COUNT()`, `SUM()`, `AVG()`, `MIN()`, `MAX()`

d) What do you understand by Cartesian Product?

A Cartesian Product, also known as a Cross Join, is a relational algebra operation that combines every row from one table with every row from another table. If Table A has $m$ rows and Table B has $n$ rows, their Cartesian Product will result in a new table with $m \times n$ rows. The number of columns in the resulting table will be the sum of the number of columns in Table A and Table B.

In SQL, a Cartesian Product is formed when two or more tables are joined without a WHERE clause specifying a join condition, or explicitly using the CROSS JOIN keyword. While sometimes useful for specific analytical tasks, it often results in a very large and potentially meaningless dataset if not intended, as it combines unrelated rows.

Example:

If TableA has 3 rows and TableB has 2 rows, a Cartesian Product will yield $3 \times 2 = 6$ rows.

SELECT * FROM TableA CROSS JOIN TableB;
-- OR
SELECT * FROM TableA, TableB;

e) Differentiate between the following statements:

i) ALTER and UPDATE

Feature	ALTER	UPDATE
Category	DDL (Data Definition Language)	DML (Data Manipulation Language)
Purpose	Modifies the structure or definition of a database object (e.g., adding/dropping columns, changing data types, adding constraints to a table).	Modifies the data within existing rows of a table.
Scope of Change	Affects the schema of the table.	Affects the values stored in the table's rows.
Example	`ALTER TABLE Students ADD COLUMN Email VARCHAR(100);`	`UPDATE Students SET Age = 20 WHERE StudentID = 101;`

ii) DELETE and DROP

Feature	DELETE	DROP
Category	DML (Data Manipulation Language)	DDL (Data Definition Language)
Purpose	Removes rows (records) from a table.	Removes an entire database object (e.g., table, database, index, view).
Scope of Change	Affects the data within a table; the table structure remains.	Removes the object and all its data and structure permanently.
Rollback	Can typically be rolled back (if within a transaction).	Usually cannot be rolled back (permanent operation).
Example	`DELETE FROM Students WHERE Age < 18;`	`DROP TABLE Students;`

f) Write the name of the functions to perform the following operations:

Here are the names of the functions and example SQL queries, assuming a common SQL dialect like MySQL.

i) To display the day like "Monday", "Tuesday", from the date when India got independence.

Function Name: DAYNAME()
Explanation: This function extracts the full name of the weekday from a given date.
Example Query:
```
SELECT DAYNAME('1947-08-15');
```

Expected Output:

+-------------------------+
| DAYNAME('1947-08-15')   |
+-------------------------+
| Friday                  |
+-------------------------+

ii) To display the specified number of characters from a particular position of the given string.

Function Name: SUBSTRING() (or SUBSTR())
Explanation: This function extracts a substring of a specified length from a string, starting at a given position.
Example Query:
```
SELECT SUBSTRING('Computer Science', 10, 7);
```
(Starts at position 10, extracts 7 characters)

Expected Output:

+----------------------------------+
| SUBSTRING('Computer Science', 10, 7) |
+----------------------------------+
| Science                          |
+----------------------------------+

iii) To display the name of the month in which you were born.

Function Name: MONTHNAME()
Explanation: This function extracts the full name of the month from a given date.

Example Query:

SELECT MONTHNAME('2005-03-10'); -- Assuming a birth date in March

Expected Output:

+-------------------------+
| MONTHNAME('2005-03-10') |
+-------------------------+
| March                   |
+-------------------------+

iv) To display your name in capital letters.

Function Name: UPPER() (or UCASE())
Explanation: This function converts all characters in a string to uppercase.
Example Query:
```
SELECT UPPER('Your Name');
```

Expected Output:

+------------------+
| UPPER('Your Name') |
+------------------+
| YOUR NAME        |
+------------------+

✓Final answer

The solution defines RDBMS, explains ORDER BY and GROUP BY clauses, differentiates single-row and aggregate functions, clarifies Cartesian Product, distinguishes ALTER vs UPDATE and DELETE vs DROP, and provides DAYNAME(), SUBSTRING(), MONTHNAME(), and UPPER() functions for the specified operations.

←Previous section · summarySummary →Next questionQ2 — Write the output produced by the following SQL statements: a) SELECT P…

Q.Answer the following questions:

a) Define RDBMS. Name any two RDBMS software.

b) What is the purpose of the following clauses in a select statement?

i) ORDER BY

ii) GROUP BY

c) Site any two differences between Single Row Functions and Aggregate Functions.

d) What do you understand by Cartesian Product?

e) Differentiate between the following statements:

i) ALTER and UPDATE

ii) DELETE and DROP

f) Write the name of the functions to perform the following operations:

i) To display the day like "Monday", "Tuesday", from the date when India got independence.

ii) To display the specified number of characters from a particular position of the given string.

iii) To display the name of the month in which you were born.

iv) To display your name in capital letters.

🎓Unlock everything free for 14 days

Unlock everything free for 14 days