Database Query

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?

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?

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