Scribd
Upload
56 views11 pages

Application Based Questions For Mysql 12

The document contains a series of application-based questions related to MySQL, covering topics such as cardinality and degree of tables, SQL commands for table management, and differences between various SQL constraints and data types. It includes specific queries and commands to manipulate and retrieve data from databases. Additionally, it addresses practical scenarios for database administrators and provides examples of SQL functions and their outputs.

Uploaded by

Kanchan Behal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
56 views11 pages

Application Based Questions For Mysql 12

The document contains a series of application-based questions related to MySQL, covering topics such as cardinality and degree of tables, SQL commands for table management, and differences between various SQL constraints and data types. It includes specific queries and commands to manipulate and retrieve data from databases. Additionally, it addresses practical scenarios for database administrators and provides examples of SQL functions and their outputs.

Uploaded by

Kanchan Behal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 11

Application Based Questions for MySql

Q.1
Q.2

Q.3
Q.4
Q.5
Questions that have been repeated at least three or more times.

1. A table STUDENT has 5 rows and 3 columns. Table ACTIVITY has 4 rows and 2 columns.
What will
be the cardinality and degree of the Cartesian product of them ? 1
2. Name the SQL commands used to : 2
(i) Physically delete a table from the database.
(ii) Display the structure of a table.
3. Write one similarity and one difference between UNIQUE and PRIMARY KEY constraints. 2
4. Write one similarity and one difference between CHAR and VARCHAR data types. 2
5. Write the UPDATE command to increase the commission (Column name : COMM) by 500
of all the
Salesmen who have achieved Sales (Column name : SALES) more than 200000. The
table’s name is COMPANY. 1
6. While using SQL pattern matching, what is the differencebetween ‘_’ (underscore) and ‘%’
wildcard
symbols ? 2
7. Saumya had previously created a table named ‘Product’ in a database using MySQL.Later
on she
forgot the table structure. Suggest her suitable MySQL commandthrough which she can
check the
structure of the already created table. 1
8. Amit works as a database administrator in a Multinational bank. He wants to undothe
changes
made in the current transaction. Suggest to him a suitable MySQLcommand for the same.
1
9. (a)Observe the table ‘Club’ given below: 2
Club
Member_id Member_name Address Age Fees
M001 Sumit New Delhi 20 1000
M002 Nisha Gurgaon 19 1500
M003 Niharika New Delhi 21 2100
M004 Sachin Faridabad 18 1500
i.What is the cardinality and degree of the above given table?
ii. If a new column contact_no has been added and two more members have joined the club
then
how these changes will affect the degree and cardinality of the above given table.
(b)Write the output of the following SQL queries: 2
i. SELECT INSTR(‘INTERNATIONAL’, ‘NA’);
ii. SELECT LENGTH(CONCAT(‘NETWORK’,’ING’));
iii.SELECT ROUND(563.345,-2);
iv. SELECT DAYOFYEAR(‘2014-01-30’);

You might also like