WorksheetsDatabase Query
Total questions: 16
Worksheet time: 5mins
Which command is used to change the data in a table?
update
drop
grant
which clause will help you to match pattern in select command?
(a)
which of the following are Aggregate functions?
date()
sum()
max()
_____ text function is to remove characters from a string.
remove()
trim()
instr()
monthname(2020/04/07) will return the value....
4
7
April
Find the correct format...
select * from class order by name desc;
select * from class name order by desc;
select * from class order by desc name;
Which text function will return the text in upper case?
(a)
select RIGHT("Informatics Practices",5);
will return ______
secit
scita
tices
pick one or more functions that return a sub-string...
middle()
substr()
substring()
select INSTR("stay home, stay safe","sta") will return the position ......
0
1
11
Now() returns ....
current date
current date and time
current time
Pick the date format MySQL uses...
DD-MM-YYYY
YY-MM-DD
YYYY-MM-DD
Which all of the following are the math functions in SQL?
mod()
sum()
round()
square()
which function can return the length of a string in SQL?
len(str)
length(str)
str.len()
count() is a _______ function.
math function
date function
text function
aggregate function
The quiz helped me to...
improve my skills
find my weak area
have fun
helped me to learn
