Advertisements
Advertisements
प्रश्न
Write the output produced by the following SQL statement:
SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4),
Advertisements
उत्तर
The result of the given query is shown below:
- IND
- ence
संबंधित प्रश्न
The MAX () function finds the
The char() function in MySql is an example of ______.
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) = ______.
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?
The ______ function returns m raised to the nth power.
Name a function of MySQL used to give position of the first occurrence of a string2 in string1.
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 text function?
What is the general format of UPPER() return type?
Site any two differences between Single Row Functions and Aggregate Functions.
Write the name of the functions to perform the following operation:
To display your name in capital letters.
Write the output produced by the following SQL statement:
SELECT ROUND(123.2345, 2),
ROUND(342.9234, −1);
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;
Which one of the following is not an aggregate function?
In SQL, which function is used to display the current date and time?
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Write suitable SQL query for the following:
Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.
Explain the following SQL function using a suitable example.
UCASE()
Which function returns the sum of all elements of a list?
