Jobs By Abekus

Is MySQL case sensitive

1

True

2

False

Solution:

Numbers prefixed with ‘0x’ are in base __________

1

4

2

8

3

10

4

16

Solution:

Which subquery returns a single value?

1

column

2

row

3

table

4

scalar

Solution:

Which of these field types would be best to hold a .jpg image?

1

char binary

2

nchar binary

3

text

4

blob

Solution:

Which data type is more suitable for storing “small notes” in Mysql?

1

Char

2

Varchar

3

Mediumtext

4

Longtext

Solution:

To measure the length of a string in bytes, the operator used is __________

1

CHAR_LENGTH()

2

LENGTH()

3

LEN()

4

SIZE()

Solution:

What is the value of val2?

`UPDATE t SET val1 = val1 + 2, val2 = val1;`

1

previous val1

2

updated val1

3

unchanged

4

val1 + 1

Solution:

Which authentications are required for login into Mysql command line tool?

1

Username

2

Password

3

Both username and password

4

None of the above

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id FROM person ORDER BY emp_id DESC;

1

{9, 7, 6, 4, 3, 1, 2}

2

{1, 2, 3, 4, 6, 7 , 9}

3

{2, 1, 3, 4, 6, 7, 9}

4

None of the mentioned

Solution:

What is the significance of “ORDER BY emp_id ASC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;

1

Data of emp_id will be sorted in descending order

2

Data of emp_id will be sorted in ascending order

3

Data of emp_id will be sorted in either ascending or descending order

4

All of the mentioned

Mysql Questions Set 6:

Is MySQL case sensitive

Solution:

Numbers prefixed with ‘0x’ are in base __________

Solution:

Which subquery returns a single value?

Solution:

Which of these field types would be best to hold a .jpg image?

Solution:

Which data type is more suitable for storing “small notes” in Mysql?

Solution:

To measure the length of a string in bytes, the operator used is __________

Solution:

What is the value of val2?

`UPDATE t SET val1 = val1 + 2, val2 = val1;`

Solution:

Which authentications are required for login into Mysql command line tool?

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id FROM person ORDER BY emp_id DESC;

Solution:

What is the significance of “ORDER BY emp_id ASC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 6:

Is MySQL case sensitive

Solution:

Numbers prefixed with ‘0x’ are in base __________

Solution:

Which subquery returns a single value?

Solution:

Which of these field types would be best to hold a .jpg image?

Solution:

Which data type is more suitable for storing “small notes” in Mysql?

Solution:

To measure the length of a string in bytes, the operator used is __________

Solution:

What is the value of val2? UPDATE t SET val1 = val1 + 2, val2 = val1;

Solution:

Which authentications are required for login into Mysql command line tool?

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? SELECT emp_id FROM person ORDER BY emp_id DESC;

Solution:

What is the significance of “ORDER BY emp_id ASC” in the given query? SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;

Solution:

Related Question Sets:

Related Topics:

What is the value of val2?

`UPDATE t SET val1 = val1 + 2, val2 = val1;`

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id FROM person ORDER BY emp_id DESC;

What is the significance of “ORDER BY emp_id ASC” in the given query?

SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;