Logo

Mysql Questions Set 64:

Quiz Mode

 What is the default value of column? 

1
2
3
4

Solution:

Which keyword is the synonym for DATABASE? 

1
2
3
4

Solution:

 Which clause specifies periodic execution at fixed intervals? 

1
2
3

Solution:

Which of the following is case-sensitive in MySQL?

1
2
3
4

Solution:

 

When no modes are enabled, what does this statement return?

SELECT @@SESSION.sql_mode;

1
2
3
4

Solution:

 

What is ‘xyz’ in the following statement?

SELECT xyz FROM table1 UNION xyz FROM table2;

1
2
3
4

Solution:

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key. 

1
2
3
4

Solution:

What is the purpose of the UNION operator in MySQL?

1
2
3
4

Solution:

 What will be the storage pattern for “float(4,2)” in Mysql? 

1
2
3

Solution:

  If attribute “fruit” stores data as “apple, mango, banana” in table person then what will be the output of the following SQL command? 



 

SELECT fruit FROM person
   WHERE person_id=1
   ORDER BY fruit;

1
2
3

Solution: