Jobs By Abekus

Mysql Questions Set 49:

Quiz Mode

In MySQL, identifier names can start with a digit.

True

False

Solution:

SHOW DATABASES lists the databases in the server to which you are connected.

true

false

Solution:

Which of the following does not support materialized view?

MySQL

Oracle

PostgreSQL

SybaseSQL

Solution:

Which keyword is used to search through natural language fulltext?

MATCH

AGAINST

FIND

Solution:

What is the name of the format file for a table named my_tbl?

my_tbl.fmt

my_tbl.frm

my_tbl.fmr

my_tbl.ftm

Solution:

NULL value in MySQL can also mean which of the following things?

a large value

value equal to zero

unknown value

negative value

Solution:

If a string is to be converted to a number, it is converted into a _____________

double precision floating point

single precision floating point

decimal integer

hexadecimal integer

Solution:

The following query belongs to which “Condition Types”?

`SELECT emp_id, fname, lname FROM account WHERE start_date<’2007-10-08’;`

Equality conditions

Inequality condition

Range condition

None of the mentioned

Solution:

When is a Full Outer Join used?

To get all unmatched data from both tables.

To get all matched data from both tables.

To get all unmatched data from one table.

To return all rows from both tables, even if there are no matches between them.

Solution:

What will be the output of the following MySQL statement?

`SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN ('sav', 'chd', 'mm');`

All of the mentioned

Only those values are selected whose product_id does not belong to either 'sav', 'chd', 'mm'

Only those values are selected whose product_id does not belong to either 'sav'

Only those values are selected whose product_id does not belong to either 'sav', 'chd'

Mysql Questions Set 49:

In MySQL, identifier names can start with a digit.

Solution:

SHOW DATABASES lists the databases in the server to which you are connected.

Solution:

Which of the following does not support materialized view?

Solution:

Which keyword is used to search through natural language fulltext?

Solution:

What is the name of the format file for a table named my_tbl?

Solution:

NULL value in MySQL can also mean which of the following things?

Solution:

If a string is to be converted to a number, it is converted into a _____________

Solution:

The following query belongs to which “Condition Types”?

`SELECT emp_id, fname, lname FROM account WHERE start_date<’2007-10-08’;`

Solution:

When is a Full Outer Join used?

Solution:

What will be the output of the following MySQL statement?

`SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN ('sav', 'chd', 'mm');`

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 49:

In MySQL, identifier names can start with a digit.

Solution:

SHOW DATABASES lists the databases in the server to which you are connected.

Solution:

Which of the following does not support materialized view?

Solution:

Which keyword is used to search through natural language fulltext?

Solution:

What is the name of the format file for a table named my_tbl?

Solution:

NULL value in MySQL can also mean which of the following things?

Solution:

If a string is to be converted to a number, it is converted into a _____________

Solution:

The following query belongs to which “Condition Types”? SELECT emp_id, fname, lname FROM account WHERE start_date<’2007-10-08’;

Solution:

When is a Full Outer Join used?

Solution:

What will be the output of the following MySQL statement? SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN ('sav', 'chd', 'mm');

Solution:

Related Question Sets:

Related Topics:

The following query belongs to which “Condition Types”?

`SELECT emp_id, fname, lname FROM account WHERE start_date<’2007-10-08’;`

What will be the output of the following MySQL statement?

`SELECT account_id, product_id, cust_id FROM account WHERE product_id NOT IN ('sav', 'chd', 'mm');`