Jobs By Abekus

MySQL can be used to execute script files.

1

True

2

False

Solution:

INFORMATION_SCHEMA is less portable than SHOW statements.

1

True

2

False

Solution:

An uncorrelated subquery contains any reference to the values from the outer query.

1

True

2

False

Solution:

DML stands for

1

Data Manipulation Language

2

Data Manipulation Level

3

Data Markup Language

4

Data Markup Level

Solution:

What does ‘A’ stand for in the ACID property of transactions?

1

Availability

2

Accuracy

3

Adjustability

4

Atomicity

Solution:

The special database that always exists after setting up MySQL in a computer is __________

1

information

2

information_schema

3

readme_db

4

mysql

Solution:

Which of the following commands belong to the Transaction Control Language (TCL)?

1

Commit, Rollback, Savepoint

2

Commit, Rollback, Update

3

Commit, Rollback, Insert

4

Commit, Rollback, Delete

Solution:

Which of the following WHERE clauses are faster?
1. WHERE col * 2 < 4 2. WHERE col < 4 / 2

1

Depends on the operating system

2

Both have the same speed

3

The first request

4

The second request

Solution:

What is the isolation property of transactions?

1

statements form a logic unit

2

database remains consistent

3

one transaction does not affect the other

4

transaction effects are recorded permanently

Solution:

In the indexed scheme of blocks to a file, the maximum possible size of the file depends on:

1

The number of blocks used for index and the size of index

2

Size of Blocks and size of Address

3

Size of index

4

Size of Block

Mysql Questions Set 1:

MySQL can be used to execute script files.

Solution:

INFORMATION_SCHEMA is less portable than SHOW statements.

Solution:

An uncorrelated subquery contains any reference to the values from the outer query.

Solution:

DML stands for

Solution:

What does ‘A’ stand for in the ACID property of transactions?

Solution:

The special database that always exists after setting up MySQL in a computer is __________

Solution:

Which of the following commands belong to the Transaction Control Language (TCL)?

Solution:

Which of the following WHERE clauses are faster?
1. WHERE col * 2 < 4 2. WHERE col < 4 / 2

Solution:

What is the isolation property of transactions?

Solution:

In the indexed scheme of blocks to a file, the maximum possible size of the file depends on:

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 1:

MySQL can be used to execute script files.

Solution:

INFORMATION_SCHEMA is less portable than SHOW statements.

Solution:

An uncorrelated subquery contains any reference to the values from the outer query.

Solution:

DML stands for

Solution:

What does ‘A’ stand for in the ACID property of transactions?

Solution:

The special database that always exists after setting up MySQL in a computer is __________

Solution:

Which of the following commands belong to the Transaction Control Language (TCL)?

Solution:

Which of the following WHERE clauses are faster?1. WHERE col * 2 < 4 2. WHERE col < 4 / 2

Solution:

What is the isolation property of transactions?

Solution:

In the indexed scheme of blocks to a file, the maximum possible size of the file depends on:

Solution:

Related Question Sets:

Related Topics:

Which of the following WHERE clauses are faster?
1. WHERE col * 2 < 4 2. WHERE col < 4 / 2