Jobs By Abekus

The datatype SMALLINT stores ___________

1

16 bit

2

32 bit

3

64 bit

4

4 bit

Solution:

Which of the following is not an aggregate function in MySQL?

1

sum

2

count

3

avg

4

find

Solution:

What is the default format for the 'Date' data type?

1

YYYY-MM-DD

2

MM-YYYY-DD

3

DD-MM-YYYY

Solution:

Which clause is used to sort a UNION result as a whole?

1

LIMIT

2

OFFSET

3

ORDER BY

4

SORT BY

Solution:

Which privileges are required on the source server to use mysqldbcopy?

1

CREATE

2

INSERT

3

UPDATE

4

SELECT

Solution:

Which statement is used to create a trigger?

1

CREATE TRIGGER

2

CREATE TRIGGERS

3

PRODUCE TRIGGER

4

PRODUCE TRIGGERS

Solution:

The option in mysqlshow to show information about indexes in a table is _________

1

-no-data

2

-indexes

3

-keys

4

-flag

Solution:

What is the meaning of “NULL” in Mysql?

1

Not applicable

2

Value not yet known

3

Value undefined

4

All of the mentioned

Solution:

Which parameter determines the shortest words to index in FULLTEXT indexes?

1

ft_min_word_len

2

ft_min_len_word

3

ft_word_min_len

4

ft_word_len_word

Solution:

Grant and Revoke queries come under which category of MYSQL?

1

Data Control Language

2

Data Definition Language

3

Data Manipulation Language

4

Data Query Language

Mysql Questions Set 19:

The datatype SMALLINT stores ___________

Solution:

Which of the following is not an aggregate function in MySQL?

Solution:

What is the default format for the 'Date' data type?

Solution:

Which clause is used to sort a UNION result as a whole?

Solution:

Which privileges are required on the source server to use mysqldbcopy?

Solution:

Which statement is used to create a trigger?

Solution:

The option in mysqlshow to show information about indexes in a table is _________

Solution:

What is the meaning of “NULL” in Mysql?

Solution:

Which parameter determines the shortest words to index in FULLTEXT indexes?

Solution:

Grant and Revoke queries come under which category of MYSQL?

Solution:

Related Question Sets:

Related Topics: