Logo

Mysql Questions Set 51:

Quiz Mode

In the CREATE TABLE statement, the engine name specified is case insensitive. 

1
2

Solution:

  Which statement terminates the execution of a function? 

1
2
3
4

Solution:

 The query ‘SELECT NOW()’ shows the current _____________ 

1
2
3
4

Solution:

Which procedure parameter enables the caller to pass in a value and get back a value? 

1
2
3
4

Solution:

  What can be used interchangeably with MYSQL_VERSION_ID?
 

1
2
3
4

Solution:

  Character data can be stored as
 

1
2
3
4

Solution:

 Association between one or more MyISAM tables and the named key cache is set by _____________
 

1
2
3
4

Solution:

What does “salary” represent in the following query?

CREATE TABLE demo_tbl (  id number not null,  salary number(9,3),  hiring_date DATE,  birth_date DATE )

1
2
3
4

Solution:

 

In the following code, InnerDB is __________


CREATE TABLE student (
name CHAR(30),
student_id INT,
PRIMARY KEY (student_id)
) ENGINE = InnerDB;

1
2
3
4

Solution:

Which of the following statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it? 

1
2
3
4

Solution: