Logo

Mysql Questions Set 24:

Quiz Mode

Which statement is used to select a default database? 

1
2
3
4

Solution:

  Transactional processing requires lesser overhead due to CPU cycles and memory. 

1
2

Solution:

 Which program reads the statement from a binary log? 

1
2
3
4

Solution:

Which command lists the databases managed by the server?

1
2
3
4

Solution:

 The maximum length of the varchar columns is
 

1
2
3
4

Solution:

 

What is ‘tamp’ in the following command?


mysql -h xyz.host.try.net -p -u tamp

1
2
3
4

Solution:

 

What is x in the following statement?

DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

1
2
3
4

Solution:

To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword? 

1
2
3
4

Solution:

 To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword? 

1
2
3
4

Solution:

 

What is abc in the following statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

1
2
3
4

Solution: