Jobs By Abekus

x’ffff’ in decimal is ___________

1

65534

2

65535

3

65537

4

65536

Solution:

Which keyword is used to create an alias in MySQL?

1

this

2

like

3

as like

4

as

Solution:

The maximum size in bytes of a row in MySQL is __________

1

65534

2

65535

3

65536

4

65537

Solution:

What is the default index type for MEMORY tables in MySQL?

1

SPATIAL

2

UNIQUE

3

FULLTEXT

4

HASH

Solution:

The ‘SOCKET’ protocol is permitted on which operating systems?

1

unix only

2

windows only

Solution:

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

1

Varchar

2

Longtext

3

Mediumtext

Solution:

Which of the following is not a trigger in MySQL

1

Before Insert

2

Before Delete

3

After Modify

4

After Delete

Solution:

If the following keyword is used with UNION, then duplicate rows are not retained.

1

NARROW

2

STRICT

3

DISTINCT

4

ALL

Solution:

In the following MySQL command how many rows will be updated?

`UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */`

1

0-9

2

1-6

3

NO ROW

Solution:

What will be the output of the following query?

SELECT * FROM person WHERE emp_id IS NULL;

1

Only those columns whose emp_id is NULL

2

Only those columns whose emp_id is not NULL

3

No output

4

None of the mentioned

Mysql Questions Set 45:

x’ffff’ in decimal is ___________

Solution:

Which keyword is used to create an alias in MySQL?

Solution:

The maximum size in bytes of a row in MySQL is __________

Solution:

What is the default index type for MEMORY tables in MySQL?

Solution:

The ‘SOCKET’ protocol is permitted on which operating systems?

Solution:

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

Solution:

Which of the following is not a trigger in MySQL

Solution:

If the following keyword is used with UNION, then duplicate rows are not retained.

Solution:

In the following MySQL command how many rows will be updated?

`UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */`

Solution:

What will be the output of the following query?

SELECT * FROM person WHERE emp_id IS NULL;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 45:

x’ffff’ in decimal is ___________

Solution:

Which keyword is used to create an alias in MySQL?

Solution:

The maximum size in bytes of a row in MySQL is __________

Solution:

What is the default index type for MEMORY tables in MySQL?

Solution:

The ‘SOCKET’ protocol is permitted on which operating systems?

Solution:

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

Solution:

Which of the following is not a trigger in MySQL

Solution:

If the following keyword is used with UNION, then duplicate rows are not retained.

Solution:

In the following MySQL command how many rows will be updated? UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id&lt;10; /* person_id is a primary key */

Solution:

What will be the output of the following query? SELECT * FROM person WHERE emp_id IS NULL;

Solution:

Related Question Sets:

Related Topics:

In the following MySQL command how many rows will be updated?

`UPDATE person SET lname=’s’, Fname=’p’, WHERE person_id<10; /* person_id is a primary key */`

What will be the output of the following query?

SELECT * FROM person WHERE emp_id IS NULL;