Jobs By Abekus

MEMORY tables do not support BLOB and TEXT indexes.

1

True

2

False

Solution:

MEMORY tables do not support BLOB and TEXT indexes.

1

True

2

False

Solution:

Which command is used to redefined the mysql delimiter?

1

redefine_delim

2

redefine

3

delimiter

4

delim_redefine

Solution:

What is the join called which produces all possible row combinations?

1

OUTER

2

INNER JOIN

3

NATURAL

4

CARTESIAN

Solution:

On UNIX, statements entered in ‘MySQL’ are saved in which file?

1

.mysql_queries

2

.queries

3

.mysql_history

4

.history

Solution:

What is 'student' in the following SQL statement?

SELECT student FROM xyz;

1

table name

2

row name

3

keyword

4

column name

Solution:

The “Mysql command line tool” format the results in which of the following format:

1

Rectangle

2

Square

3

Sphere

4

None of the mentioned

Solution:

SELECT CONCAT('SQL', ' is', ' fun!');
Choose the correct option mentioned below.

1

SQL is fun!

2

SQL is fun !

3

SQLisfun!

4

'SQL', ' is', ' fun!'

Solution:

Which one is the correct declaration for choosing the character set other than default?

1

Varchar(20) character set utf8;

2

Varchar(20);

3

Varchar(20) character set;

4

None of the mentioned

Solution:

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;

1

All employees whose last name start with any letter but second letter should be ‘a’

2

All employees whose last name start with any letter but contain at least one ‘e’ in his name

3

All employees whose last name should have letter ‘a’ in second position and at least one ‘e’ in his name

4

All of the mentioned

Mysql Questions Set 58:

MEMORY tables do not support BLOB and TEXT indexes.

Solution:

MEMORY tables do not support BLOB and TEXT indexes.

Solution:

Which command is used to redefined the mysql delimiter?

Solution:

What is the join called which produces all possible row combinations?

Solution:

On UNIX, statements entered in ‘MySQL’ are saved in which file?

Solution:

What is 'student' in the following SQL statement?

SELECT student FROM xyz;

Solution:

The “Mysql command line tool” format the results in which of the following format:

Solution:

SELECT CONCAT('SQL', ' is', ' fun!');
Choose the correct option mentioned below.

Solution:

Which one is the correct declaration for choosing the character set other than default?

Solution:

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 58:

MEMORY tables do not support BLOB and TEXT indexes.

Solution:

MEMORY tables do not support BLOB and TEXT indexes.

Solution:

Which command is used to redefined the mysql delimiter?

Solution:

What is the join called which produces all possible row combinations?

Solution:

On UNIX, statements entered in ‘MySQL’ are saved in which file?

Solution:

What is 'student' in the following SQL statement? SELECT student FROM xyz;

Solution:

The “Mysql command line tool” format the results in which of the following format:

Solution:

SELECT CONCAT('SQL', ' is', ' fun!');Choose the correct option mentioned below.

Solution:

Which one is the correct declaration for choosing the character set other than default?

Solution:

What will be the output of the following query? SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;

Solution:

Related Question Sets:

Related Topics:

What is 'student' in the following SQL statement?

SELECT student FROM xyz;

SELECT CONCAT('SQL', ' is', ' fun!');
Choose the correct option mentioned below.

What will be the output of the following query?

SELECT * FROM employee WHERE lname LIKE ‘_a%e%’;