Write the output produced by the following SQL statement: SELECT LEFT(

प्रश्न

Write the output produced by the following SQL statement:

SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4), MID("Informatics", 3, 4), SUBSTR("Practices", 3);

लघु उत्तर

उत्तर

The result of the given query is shown below:

IND
ence
form
actices

shaalaa.com

Functions in SQL

या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?

Q 2. e)Q 2. d)Q 3.

पाठ 9: Structured Query Language (SQL) - Exercise [पृष्ठ १७७]

APPEARS IN

एनसीईआरटी Computer Science [English] Class 12

पाठ 9 Structured Query Language (SQL)
Exercise | Q 2. e) | पृष्ठ १७७

संबंधित प्रश्‍न

Which method is used to get the row-id of the last modified row?

The MAX () function finds the

Consider the table STUDENT given below:

RollNo	Name	Class	DOB	Gender	City	Marks
1	Anand	XI	6/6/97	M	Agra	430
2	Chetan	XII	7/5/94	M	Mumbai	460
3	Geet	XI	6/5/97	F	Agra	470
4	Preeti	XII	8/8/95	F	Mumbai	492
5	Saniyal	XII	8/10/95	M	Delhi	360
6	Maakhiy	XI	12/12/94	F	Dubai	256
7	Neha	X	8/12/95	F	Moscow	324
8	Nishant	X	12/6/95	M	Moscow	429

State the command that will give the output as:

Name

(i) select Name from student where Class ='XI' and Class='XII';

(ii) select name from student where not Class='XI' and Class='XII';

(iii) select name from student where City="Agra" or City="Mumbai";

(iv) select name from student where City in("Agra", "Mumbai");

Choose the correct option:

Assertion (A): COUNf function ignores DISTINCT

Reason (R): DISTINCT ignores the duplicate values.

Which of the following is not an aggregate function?

Which command is used to delete a table? (in SQL)

Identify Single Row function of MySQL among the following.

What will be returned by the given query? select day of year('2015-02-10') = ______.

What will be returned by the given query? select substr("Computer", 4) = ______.

What will be returned by the given query? select power(3, 2) = ______.

What will be returned by the given query? Select length(trim("ABC Public School")) = ______.

What will be returned by the given query? SELECT RIGHT("LEFT", 2) = ______.

What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.

Name a function of MySQL which is used to remove trailing and leading spaces from a string.

"COUNT" keyword belongs to which categories in Mysql?

What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.

What will be returned by the given query? SELECT DAYOFYEAR('2015-01-10') = ______.

Which of the following is not a date function?

Which of the following is not a text function?

Which function will be used to remove only the trailing spaces from a string?

Which statement is used to count the number of rows in table?

Write the name of the functions to perform the following operation:

To display the day like “Monday”, and “Tuesday”, from the date when India got independence.

Write the name of the functions to perform the following operation:

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

Write the output produced by the following SQL statement:

SELECT ROUND(342.9234, -1);

Write the output produced by the following SQL statement:

SELECT YEAR(“1979/11/26”),
MONTH(“1979/11/26”), DAY(“1979/11/26”), MONTHNAME(“1979/11/26”);

Write the outputs of the SQL queries based on the relations Teacher and Placement given below:

Table: Teacher

T_ID	Name	Age	Department	Date_of_join	Salary	Gender
1	Arunan	34	Computer Sc	2019-01-10	12000	M
2	Saman	31	History	2017-03-24	20000	F
3	Randeep	32	Mathematics	2020-12-12	30000	M
4	Samira	35	History	2018-07-01	40000	F
5	Raman	42	Mathematics	2021-09-05	25000	M
6	Shyam	50	History	2019-06-27	30000	M
7	Shiv	44	Computer Sc	2019-02-25	21000	M
8	Shalakha	33	Mathematics	2018-07-31	20000	F

Table: Placement

P_ID	Department	Place
1	History	Ahmedabad
2	Mathematics	Jaipur
3	Computer Sc	Nagpur

SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;

Predict the output of the code given below:

s="welcome2cs" 

n = len(s)
m=""
for i in range(0, n):
       if (s[i] >= 'a' and s[i] <= 'm'):
            m = m +s[i].upper()
 elif (s[i] >= 'n' and s[i] <= 'z'):
          m = m +s[i-1]
 elif (s[i].isupper()):
     m = m + s[i].lower()
 else:
     m = m +'&'
print(m)

Which type of values will not be considered by SQL while executing the following statement?

SELECT COUNT(column name) FROM inventory;

If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?

SELECT SUM (DISTINCT Fees) FROM student;

In SQL, which function is used to display the current date and time?

Write outputs for SQL queries that are based on the given table PURCHASE:

TABLE: PURCHASE
CNO	CNAME	CITY	QUANTITY	DOP
C01	GURPREET	NEW DELHI	150	2022-06-11
C02	MALIKA	HYDERABAD	10	2022-02-19
C03	NADAR	DALHOUSIE	100	2021-12-04
C04	SAHIB	CHANDIGARH	50	2021-10-10
C05	MEHAK	CHANDIGARH	15	2021-10-20

SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;

Based on the table STUDENT given here, write suitable SQL queries for the following:

Roll No	Name	Class	Gender	City	Marks
1	Abhishek	XI	M	Agra	430
2	Prateek	XII	M	Mumbai	440
3	Sneha	XI	F	Agra	470
4	Nancy	XII	F	Mumbai	492
5	Himanshu	XII	M	Delhi	360
6	Anchal	XI	F	Dubai	256
7	Mehar	X	F	Moscow	324
8	Nishant	X	M	Moscow	429

Display gender-wise highest marks.
Display city-wise lowest marks.
Display the total number of male and female students.

Write suitable SQL query for the following:

Round off the value 23.78 to one decimal place.

Write suitable SQL query for the following:

Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.