Logo

Mysql Questions Set 16:

Quiz Mode

SPATIAL indexes can be created on NOT NULL spatial columns.

1
2

Solution:

To perform division operation in MySQL, which operator is used?

1
2
3
4

Solution:

 How is communication established with MySQL?  

1
2
3
4

Solution:

Which facility allows nesting one select statement into another?

1
2
3
4

Solution:

Which subquery cannot be executed by itself as a separate statement? 

1
2
3
4

Solution:

Which SQL clause is used to display information that matches a given pattern?

1
2
3
4

Solution:

What is known as the set of SQL statements that either executes successfully or none of them have an effect.

1
2
3
4

Solution:

The property of InnoDB that enforces foreign key relationships stay intact is called _____________ 

1
2
3
4

Solution:

Which of the following is used for selecting  record from the table?

1
2
3
4

Solution:

 

If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following query?


 SELECT DISTINICT cust_id FROM account; 

1
2
3
4

Solution: