Jobs By Abekus

The mantissa in -2.57E6 is __________

1

2.57

2

-2.57

3

E

4

6

Solution:

Which storage engine is not available in MySQL 5.0?

1

InnoDB

2

Solution:

The statement to change the table name is ________

1

CHANGE

2

RENAME

3

CHANGENAME

4

CHANGENM

Solution:

Which program performs logical backups?

1

mysqlimport

2

mysqldump

3

myslqpit

4

mysqllogic

Solution:

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________

1

32

2

64

3

65

4

16

Solution:

In which log are data changes received from a replication master server written?

1

Error Log

2

General Query Log

3

Binary Log

4

Relay Log

Solution:

What type of join is needed when you wish to include rows that do not have matching values?

1

Equi-join

2

Natural join

3

Outer join

4

All of the above

Solution:

What is the purpose of the LIKE keyword in MySQL?

1

Both i) and ii)

2

None of these

3

% and _ are used in the LIKE function

4

LIKE is used for pattern matching in records

Solution:

Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

1

Varchar

2

Char

3

Both Varchar and Char

4

None of the mentioned

Solution:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date>2013-01-24);

1

All columns and rows belong to table employee

2

All columns but only those rows which contain ‘HEAD TELLER’ as a “title” OR start_date are greater than 2013-01-24

3

All rows belong to table employee

4

None of the mentioned

Mysql Questions Set 13:

The mantissa in -2.57E6 is __________

Solution:

Which storage engine is not available in MySQL 5.0?

Solution:

The statement to change the table name is ________

Solution:

Which program performs logical backups?

Solution:

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________

Solution:

In which log are data changes received from a replication master server written?

Solution:

What type of join is needed when you wish to include rows that do not have matching values?

Solution:

What is the purpose of the LIKE keyword in MySQL?

Solution:

Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

Solution:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date>2013-01-24);

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 13:

The mantissa in -2.57E6 is __________

Solution:

Which storage engine is not available in MySQL 5.0?

Solution:

The statement to change the table name is ________

Solution:

Which program performs logical backups?

Solution:

The DECIMAL used for expressions containing only exact values with fractional part is of digit precision _________

Solution:

In which log are data changes received from a replication master server written?

Solution:

What type of join is needed when you wish to include rows that do not have matching values?

Solution:

What is the purpose of the LIKE keyword in MySQL?

Solution:

Which declaration doesn’t use the same number of bytes and consumption of bytes depends on the input data?

Solution:

What will be the output of the query given below? SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date&gt;2013-01-24);

Solution:

Related Question Sets:

Related Topics:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date>2013-01-24);