Jobs By Abekus

MySQL server mode values are case sensitive.

1

True

2

False

Solution:

It is possible to drop multiple tables in the same statement.

1

True

2

False

Solution:

Can ROW_NUMBER() function without ORDER BY clause be executed?

1

True

2

False

Solution:

What does ‘mysql_query()’ return on failure?

1

0

2

1

3

-1

4

a non-zero value

Solution:

Which clause is used to remove a foreign key constraint?

1

REMOVE

2

DELETE

3

DROP

4

EXCLUDE

Solution:

Which table stores information about the threads executing within the server?

1

PROCESSLIST

2

PROCESS

3

LIST

4

THREADLIST

Solution:

Which subquery cannot be executed by itself as a separate statement?

1

Correlated

2

Uncorrelated

3

EXISTS

4

NOT EXISTS

Solution:

Which server mode value disables use of built in function names as identifiers?

1

IGNORE_FUNC

2

ANSI

3

IGNORE_SPACE

4

TRADITIONAL

Solution:

To create a database only if it does not already exist, which clause is used?

1

IF NOT EXISTS

2

CREATE EXISTS

3

EXISTS IF

4

IF EXISTS

Solution:

You have a table with no.of books. Suppose you want to get the details of books starting from 25th what is the query you want to use.

1

select 25 from books

2

select * from books limit 25

3

select count(*) from books

4

select * from books where id=25;

Mysql Questions Set 40:

MySQL server mode values are case sensitive.

Solution:

It is possible to drop multiple tables in the same statement.

Solution:

Can ROW_NUMBER() function without ORDER BY clause be executed?

Solution:

What does ‘mysql_query()’ return on failure?

Solution:

Which clause is used to remove a foreign key constraint?

Solution:

Which table stores information about the threads executing within the server?

Solution:

Which subquery cannot be executed by itself as a separate statement?

Solution:

Which server mode value disables use of built in function names as identifiers?

Solution:

To create a database only if it does not already exist, which clause is used?

Solution:

You have a table with no.of books. Suppose you want to get the details of books starting from 25th what is the query you want to use.

Solution:

Related Question Sets:

Related Topics: