Jobs By Abekus

Can MySQL be used to run script files?

1

YES

2

NO

Solution:

_____ sorts rows in SQL.

1

SORT BY

2

ALIGN BY

3

GROUP BY

4

ORDER BY

Solution:

FULLTEXT indexes can be created only for ____________

1

MyISAM

2

InnoDB

3

MEMORY

4

TRANSITION

Solution:

What are the left and right joins also known as?

1

INNER JOIN

2

OUTER JOIN

3

CARTESIAN JOIN

4

NATURAL JOIN

Solution:

Which of these modes is a composite server mode?

1

COMPOSITE

2

COMPOSITE_MODE

3

COMPOSITE_SERVER

4

ANSI

Solution:

Which search mode uses natural language search as a subroutine?

1

Natural language

2

Boolean mode

3

Query expansion

4

Cross mode

Solution:

Which command is used in Mysql command line tool to return to window command shell?

1

exit

2

quit

3

both quit and exit

4

none of the above

Solution:

Which statement is used to determine the storage engine for individual tables?

1

SHOW STATUS OF TABLE

2

SHOW STATUS TABLE

3

SHOW TABLE STATUS

4

SHOW DEFAULT STATUS

Solution:

If ASC or DESC is not specified after a SQL ORDER BY clause, what is the default sorting order?

1

Ascending order

2

There is no default order

3

None of the above

4

Descending order

Solution:

What is the durability property of transactions?

1

transaction effects are recorded permanently

2

statements from a logic unit

3

database remains consistent

4

one transaction does not affect

Mysql Questions Set 2:

Can MySQL be used to run script files?

Solution:

_____ sorts rows in SQL.

Solution:

FULLTEXT indexes can be created only for ____________

Solution:

What are the left and right joins also known as?

Solution:

Which of these modes is a composite server mode?

Solution:

Which search mode uses natural language search as a subroutine?

Solution:

Which command is used in Mysql command line tool to return to window command shell?

Solution:

Which statement is used to determine the storage engine for individual tables?

Solution:

If ASC or DESC is not specified after a SQL ORDER BY clause, what is the default sorting order?

Solution:

What is the durability property of transactions?

Solution:

Related Question Sets:

Related Topics: