Logo

Mysql Questions Set 59:

Quiz Mode

How to comment on SQL queries?

1
2
3
4

Solution:

Which statement is used to access an existing Database? 

1
2
3
4

Solution:

To create a database only if it doesn’t already exist, which clause is used? 

1
2
3
4

Solution:

The facility that allows nesting one select statement into another is called __________ 

1
2
3
4

Solution:

The number of rows in the table is 100. Suppose all rows are deleted. The new row starts with sequence number _____________ 

1
2
3
4

Solution:

Which mode tells the server to recognize double quote as an identifier quoting character? 

1
2
3
4

Solution:

Which SQL command is used to retrieve all records from a table?

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:

 Which mode is used to turn off the special meaning of backslash and treat it as an ordinary character? 

1
2
3
4

Solution:

 What will happen if the data being loaded into a text column exceeds the maximum size of that type? 

1
2
3
4

Solution: