Jobs By Abekus

In Boolean search, results are sorted by relevance

1

True

2

False

Solution:

Which data structure does MySQL use

1

B+ tree

2

Hash index

3

B trees

4

Both B tree & Hash index

Solution:

Which of the following subquery returns a single value?

1

column

2

row

3

table

4

None of the above

Solution:

Which instruction is used to check the operation of the optimizer?

1

SHOW

2

ANALYZE

3

VERIFY

4

EXPLAIN

Solution:

CROSS JOIN and JOIN are similar to __________

1

INNER JOIN

2

NATURAL JOIN

3

OUTER JOIN

4

CARTESIAN JOIN

Solution:

The statement that exits a labeled flow-control construct is _____________

1

DESCRIBE

2

LEAVE

3

LOOP

4

RETURN

Solution:

What is the default format for “Datetime” data type?

1

DD-YYYY-MM MI:HH:SS

2

MM-YYYY-DD HH:MI:SS

3

YYYY-MM-DD HH:MI:SS

4

None of the mentioned

Solution:

A) Blob is used to store images only

B) Varchar can store upto 65,535 characters

1

Only A is true

2

Only B is true

3

Both are true

4

Neither are true

Solution:

Which privilege must be given to the database to create a stored function or procedure?

1

CREATE METHOD

2

CREATE FUNCTION

3

CREATE PROCEDURE

4

CREATE ROUTINE

Solution:

Which among the following data types can be used with “Range Condition”?

1

Numeric data type

2

Temporal data type

3

String data type

4

Both Numeric and Temporal data type

Mysql Questions Set 57:

In Boolean search, results are sorted by relevance

Solution:

Which data structure does MySQL use

Solution:

Which of the following subquery returns a single value?

Solution:

Which instruction is used to check the operation of the optimizer?

Solution:

CROSS JOIN and JOIN are similar to __________

Solution:

The statement that exits a labeled flow-control construct is _____________

Solution:

What is the default format for “Datetime” data type?

Solution:

A) Blob is used to store images only

B) Varchar can store upto 65,535 characters

Solution:

Which privilege must be given to the database to create a stored function or procedure?

Solution:

Which among the following data types can be used with “Range Condition”?

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 57:

In Boolean search, results are sorted by relevance

Solution:

Which data structure does MySQL use

Solution:

Which of the following subquery returns a single value?

Solution:

Which instruction is used to check the operation of the optimizer?

Solution:

CROSS JOIN and JOIN are similar to __________

Solution:

The statement that exits a labeled flow-control construct is _____________

Solution:

What is the default format for “Datetime” data type?

Solution:

A) Blob is used to store images only B) Varchar can store upto 65,535 characters

Solution:

Which privilege must be given to the database to create a stored function or procedure?

Solution:

Which among the following data types can be used with “Range Condition”?

Solution:

Related Question Sets:

Related Topics:

A) Blob is used to store images only

B) Varchar can store upto 65,535 characters