What does ‘C’ stand for in the ACID property of transactions? 

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

Which statement to use if we want to create database if and only if it does not exist?

It is easier to use the SQL keywords IN and NOT IN when three or more AND and OR conditions are combined.

If an integer column is used for values in the range 1 to 99999, the best suitable data type is ______.

Which column names will be displayed when the following command is typed: 

SHOW COLUMNS FROM demo_table LIKE '%ojo';

Which of the following syntax is correct for LIMIT in MySQL?

Will this query produce any error? 

INSERT INTO person   (person_id, fname,lname) 

  VALUES (1,’S’,’U’),   VALUES (1,’T’,’U’); 

/* where person_id is a primary key */

Which operator is used to perform integer division in MySQL?

If the set of stud_id values is {-1, -2, 2, 3, -3, 1}, what will be the output when the following query is executed?

SELECT stud_id FROM person ORDER BY stud_id;