Jobs By Abekus

Mysql Questions Set 48:

Quiz Mode

The UNION ALL has LESSER precedence than UNION DISTINCT.

TRUE

FALSE

Solution:

What represents a ‘tuple’ in a relational database?

Table

Column

Row

Object

Solution:

Which data type is used for a fixed-length binary string?

BLOB

VARCHAR

BINARY

UNARY

Solution:

Which column attribute provides unique numbers for identification?

AUTO_INCREMENT

UNSIGNED

IDENTIFY

DESCRIBE

Solution:

What will be the output of the following MySQL statement “Null AND Null”?

True

Null

False

None of the mentioned

Solution:

Which feature is used for automatic increment of the column?

AUTO_INCREMENT

AUTO

INCREMENT

All of the mentioned

Solution:

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

TRANSPARENT

CONCRETE

CASCADED

ELABORATE

Solution:

What column names are displayed when this command is executed?

`SHOW COLUMNS FROM table_name LIKE '%name';`

suffixed with ‘name’

prefixed with ‘name’

suffixed with ‘%name’

prefixed with ‘%name’

suffixed with ‘name’

prefixed with ‘name’

suffixed with ‘%name’

prefixed with ‘%name’

Solution:

What are the differences between the COUNT and SUM aggregate functions?

None of these

Both are the same

The COUNT function retrieves the count of records, while the SUM function calculates the sum of numeric values

The SUM function retrieves the count of records, while the COUNT function calculates the sum of numeric values

Solution:

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE %bas% OR fname LIKE %bbs%;

All employees whose last name should contain substring “bas”

All employees whose first name should contain substring “bbs”

All employees whose last name should contain substring “bas” or first name should contain substring “bbs”

None of the mentioned

Mysql Questions Set 48:

The UNION ALL has LESSER precedence than UNION DISTINCT.

Solution:

What represents a ‘tuple’ in a relational database?

Solution:

Which data type is used for a fixed-length binary string?

Solution:

Which column attribute provides unique numbers for identification?

Solution:

What will be the output of the following MySQL statement “Null AND Null”?

Solution:

Which feature is used for automatic increment of the column?

Solution:

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

Solution:

What column names are displayed when this command is executed?

`SHOW COLUMNS FROM table_name LIKE '%name';`

Solution:

What are the differences between the COUNT and SUM aggregate functions?

Solution:

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE %bas% OR fname LIKE %bbs%;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 48:

The UNION ALL has LESSER precedence than UNION DISTINCT.

Solution:

What represents a ‘tuple’ in a relational database?

Solution:

Which data type is used for a fixed-length binary string?

Solution:

Which column attribute provides unique numbers for identification?

Solution:

What will be the output of the following MySQL statement “Null AND Null”?

Solution:

Which feature is used for automatic increment of the column?

Solution:

Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________

Solution:

What column names are displayed when this command is executed? SHOW COLUMNS FROM table_name LIKE '%name';

Solution:

What are the differences between the COUNT and SUM aggregate functions?

Solution:

What will be the output of the following query? SELECT * FROM employee WHERE lname LIKE %bas% OR fname LIKE %bbs%;

Solution:

Related Question Sets:

Related Topics:

What column names are displayed when this command is executed?

`SHOW COLUMNS FROM table_name LIKE '%name';`

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE %bas% OR fname LIKE %bbs%;