Jobs By Abekus

The datatype INT stores ___________

1

16 bit

2

32 bit

3

48 bit

4

64 bit

Solution:

Which of these comparisons is slow?

1

BIGINT/BIGINT

2

INT/INT

3

INT/BIGINT

4

All have the same speed

Solution:

What will be the output of the following MySQL statement “Null OR Null”?

1

True

2

Null

3

False

4

None of the mentioned

Solution:

What are the key characteristics of a primary key?

1

All the above

2

i) only

3

i), ii) and iv) only

4

i), iii) and ii) only

Solution:

Which is the MySQL instance responsible for data processing?

1

MySQL client

2

MySQL server

3

SQL

4

Server daemon program

Solution:

What is abc in the following statement?

`SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');`

1

column name

2

table name

3

search string

4

database name

Solution:

What is xyz in the following statement?

SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

1

column name

2

table name

3

search string

4

database name

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

1

True

2

False

Solution:

Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

1

gender char(1) check( gender IN (‘M’, ‘F’)),

2

gender char (1) check,

3

gender char (1) check ( gender ),

4

none of the mentioned

Solution:

What will be the output of the following query?

SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’T’;

1

Only those employees are selected whose last name started with ‘T’

2

Only those employees are selected whose last name started with other than ‘T’

3

All of the mentioned

4

None of the mentioned

Mysql Questions Set 53:

The datatype INT stores ___________

Solution:

Which of these comparisons is slow?

Solution:

What will be the output of the following MySQL statement “Null OR Null”?

Solution:

What are the key characteristics of a primary key?

Solution:

Which is the MySQL instance responsible for data processing?

Solution:

What is abc in the following statement?

`SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');`

Solution:

What is xyz in the following statement?

SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Solution:

Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

Solution:

What will be the output of the following query?

SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’T’;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 53:

The datatype INT stores ___________

Solution:

Which of these comparisons is slow?

Solution:

What will be the output of the following MySQL statement “Null OR Null”?

Solution:

What are the key characteristics of a primary key?

Solution:

Which is the MySQL instance responsible for data processing?

Solution:

What is abc in the following statement? SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

Solution:

What is xyz in the following statement? SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

Solution:

The connection parameters for setting up MySQL can be stored in an option file to save typing the names every time a connection is established.

Solution:

Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

Solution:

What will be the output of the following query? SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’T’;

Solution:

Related Question Sets:

Related Topics:

What is abc in the following statement?

`SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');`

What is xyz in the following statement?

SELECT * FROM my_table WHERE MATCH(abc) AGAINST('xyz');

What will be the output of the following query?

SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’T’;