Logo

Mysql Questions Set 21:

Quiz Mode

 The BIGINT precision is of bit _________ 

1
2
3
4

Solution:

 The mantissa in -1.58E5 is __________
 

1
2
3
4

Solution:

FULLTEXT indexes can be created only for ____________ 

1
2
3
4

Solution:

Which of the given is case sensitive in MySQL?

1
2
3
4

Solution:

  What will be the output of the following statement “true AND Null”?
 

1
2
3
4

Solution:

Which SQL statement is the correct syntax to create a new database?

1
2
3
4

Solution:

  What is the command to disable autocommit and launch a transaction?
 

1
2
3
4

Solution:

 Which of the following functions are not performed by “ALTER” clause? 

1
2
3
4

Solution:

 

Is there any error in this query?


 SELECT e.emp_id, e.fname,e.lname,d.name FROM employee AS e INNER JOIN department AS d ON e.dept_id=e.dept_id; 

1
2
3
4

Solution:

  Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query? 

1
2
3
4

Solution: