In the CREATE TABLE statement, the engine name specified is case insensitive.
Which statement terminates the execution of a function?
The query ‘SELECT NOW()’ shows the current _____________
Which procedure parameter enables the caller to pass in a value and get back a value?
What can be used interchangeably with MYSQL_VERSION_ID?
Character data can be stored as
Association between one or more MyISAM tables and the named key cache is set by _____________
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 )
In the following code, InnerDB is __________
CREATE TABLE student (
name CHAR(30),
student_id INT,
PRIMARY KEY (student_id)
) ENGINE = InnerDB;
Which of the following statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?