Jobs By Abekus

Mysql Questions Set 61:

Quiz Mode

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

Consistency

Concrete

Collision

Compound

Solution:

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

OUT

INOUT

GETINOUT

Solution:

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

IF NOT EXISTS

IF EXISTS

CREATE EXISTS

EXISTS IF

Solution:

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

NOT IN only

LIKE only

IN only

Both IN and NOT IN

Solution:

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

MEDIUMINT SIGNED

MEDIUMINT UNSIGNED

SMALLINT SIGNED

SMALLINT UNSIGNED

Solution:

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

SHOW COLUMNS FROM demo_table LIKE '%ojo';

suffixed with 'ojo'

prefixed with 'ojo'

suffixed with '%ojo'

prefixed with '%ojo'

Solution:

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

SELECT * from tablename LIMIT number

SELECT LIMIT from tablename

SELECT * FROM tablename LIMIT number

SELECT LIMIT * from tablename number

Solution:

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 /

Error

No Error

Depends

None of the mentioned

Solution:

Which operator is used to perform integer division in MySQL?

// is used to perform integer division

DIVISION is used to perform integer division

/ is used to perform integer division

DIV is used to perform integer division

Solution:

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;

{-1, 1, -2, 2, -3, 3}

{1, 2, 3, -1, -2, -3}

{-3, -2, -1, 1, 2, 3}

None of these

Mysql Questions Set 61:

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

Solution:

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

Solution:

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

Solution:

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

Solution:

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

Solution:

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

SHOW COLUMNS FROM demo_table LIKE '%ojo';

Solution:

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

Solution:

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 /

Solution:

Which operator is used to perform integer division in MySQL?

Solution:

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;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 61:

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

Solution:

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

Solution:

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

Solution:

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

Solution:

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

Solution:

Which column names will be displayed when the following command is typed: SHOW COLUMNS FROM demo_table LIKE '%ojo';

Solution:

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

Solution:

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 */

Solution:

Which operator is used to perform integer division in MySQL?

Solution:

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;

Solution:

Related Question Sets:

Related Topics:

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

SHOW COLUMNS FROM demo_table LIKE '%ojo';

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 /

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;