Advertisements
Advertisements
प्रश्न
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)Advertisements
उत्तर
sELCcME&Cc
APPEARS IN
संबंधित प्रश्न
______ is used to get a specified day of the month for a given date.
______ keyword is used to find out the number of values in a column?
Which of the following belongs to an "aggregate function"?
The MAX () function finds the
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
The char() function in MySql is an example of ______.
Which command is used to delete a table? (in SQL)
What will be returned by the given query? select mid("Computer", 2, 4) = ______.
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 MID('LeaminglsFun', 2, 4) = ______.
Name a function of MySQL used to give position of the first occurrence of a string2 in string1.
Which function will be used to remove only the trailing spaces from a string?
The string function that returns the index of the first occurrence of substring is ______.
What is the general format of UPPER() return type?
Site any two differences between Single Row Functions and Aggregate Functions.
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”);
Differentiate between count() and count(*) functions in SQL with appropriate examples.
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;
Which one of the following functions are used to find the largest value from the given data in MySQL?
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Explain the following SQL function using a suitable example.
UCASE()
Which function returns the sum of all elements of a list?
