Jobs By Abekus

Mysql Questions Set 12:

Quiz Mode

Which is an alternative word for DATABASE?

TABLE

OBJECT

SCHEMA

Solution:

What can be used to make changes to the DB's global attributes?

ALTER

ALTERNATE

UPDATE

CHANGE

Solution:

The number of legal hexadecimal values among 0x0b, 0x0B, 0X0b and 0X0B is ___________

Solution:

Which system variable in MySQL server enables to configure the SQL mode?

sql_mode

sql_server

sql_config

sql_enable

Solution:

What is abc in the following MySQL statement?

`DECLARE abc HANDLER FOR def ghi;`

action

condition value

statement

null

Solution:

Choose the correct option Which is used to delete all rows in a table without having the action logged?

TRUNCATE

DELETE

DROP

REMOVE

Solution:

What is the function of Ctrl-_ in MySQL input editor?

copies to clipboard

pastes from clipboard

undoes last change

deletes the current line

Solution:

What may be the results of the following queries if column 'col' is declared as INTEGER?

Both are the same

The second request produces an error

The two are different

The first request produces an error

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id ASC;

{9, 7, 6, 4, 3, 1, 2}

{1, 2, 3, 4, 6, 7, 9}

{2, 1, 3, 4, 6, 7, 9}

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);

All columns and rows belong to table employee

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

All rows belong to table employee

None of the mentioned

Mysql Questions Set 12:

Which is an alternative word for DATABASE?

Solution:

What can be used to make changes to the DB's global attributes?

Solution:

The number of legal hexadecimal values among 0x0b, 0x0B, 0X0b and 0X0B is ___________

Solution:

Which system variable in MySQL server enables to configure the SQL mode?

Solution:

What is abc in the following MySQL statement?

`DECLARE abc HANDLER FOR def ghi;`

Solution:

Choose the correct option Which is used to delete all rows in a table without having the action logged?

Solution:

What is the function of Ctrl-_ in MySQL input editor?

Solution:

What may be the results of the following queries if column 'col' is declared as INTEGER?

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id ASC;

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 12:

Which is an alternative word for DATABASE?

Solution:

What can be used to make changes to the DB's global attributes?

Solution:

The number of legal hexadecimal values among 0x0b, 0x0B, 0X0b and 0X0B is ___________

Solution:

Which system variable in MySQL server enables to configure the SQL mode?

Solution:

What is abc in the following MySQL statement? DECLARE abc HANDLER FOR def ghi;

Solution:

Choose the correct option Which is used to delete all rows in a table without having the action logged?

Solution:

What is the function of Ctrl-_ in MySQL input editor?

Solution:

What may be the results of the following queries if column 'col' is declared as INTEGER?

Solution:

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query? SELECT emp_id FROM person ORDER BY emp_id ASC;

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:

What is abc in the following MySQL statement?

`DECLARE abc HANDLER FOR def ghi;`

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?

SELECT emp_id

FROM person

ORDER BY emp_id ASC;

What will be the output of the query given below?

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