Logo

Mysql Questions Set 43:

Quiz Mode

 The IN, OUT and INOUT keywords do not apply to stored functions. 

1
2

Solution:

Which spatial datatype is used to store a curve? 

1
2
3
4

Solution:

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

1
2

Solution:

Which table is used to run a UNION-type query on MyISAM tables? 

1
2
3
4

Solution:

What is the correct syntax to drop a table?

1
2
3
4

Solution:

 

he number of attributes in the following table is ______________

CREATE TABLE student (
std_name CHAR(30),
std_id INT
);

1
2
3
4

Solution:

 The default definer of an event is the user who _______________ 

1
2
3
4

Solution:

  If ANSI_QUOTES is enabled, MySQL treats the double quotes as ________________
 

1
2
3
4

Solution:

Which SQL command can be efficiently used to permanently delete a table from the database?

1
2
3
4

Solution:

  Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________
 

1
2
3
4

Solution: