Jobs By Abekus

What is an attribute in MySQL?

1

table

2

row

3

column

4

object

Solution:

MySQL can not be used to execute script files.

1

False

2

True

Solution:

Which among the following is an optional Keyword?

1

DISTINICTS

2

ALL

3

AS

4

Both AS and ALL

Solution:

Which statement is used to delete an existing row from the table?

1

DELETE

2

WHERE

3

MODIFY

4

UPDATE

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

1

SPECIFY

2

SET

3

ASSIGN

4

CHANGE

Solution:

The statement that constructs a branching flow-control construct is _____________

1

BEGIN…END

2

CASE

3

ITERATE

4

LEAVE

Solution:

Which of these columns are faster?

`Variable length, Fixed length`

1

same

2

variable length

3

fixed length

4

indeterminate

Solution:

Which of the following is a default database that comes with installation of MySQL?

1

mysql

2

information_schema

3

readme_db

4

sampdb

Solution:

When no modes are enabled, the output of the statement "SELECT @@SESSION.sql_mode;" is _____.

1

empty value

2

zero

3

a negative value

4

a garbage value

Solution:

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

1

All columns

2

Only those columns which are mention with “SELECT” clause

3

Columns mention with “SELECT” clause and only those rows which contain ‘HEAD TELLER’ as a “title”

4

None of the mentioned

Mysql Questions Set 60:

What is an attribute in MySQL?

Solution:

MySQL can not be used to execute script files.

Solution:

Which among the following is an optional Keyword?

Solution:

Which statement is used to delete an existing row from the table?

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

Solution:

The statement that constructs a branching flow-control construct is _____________

Solution:

Which of these columns are faster?

`Variable length, Fixed length`

Solution:

Which of the following is a default database that comes with installation of MySQL?

Solution:

When no modes are enabled, the output of the statement "SELECT @@SESSION.sql_mode;" is _____.

Solution:

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 60:

What is an attribute in MySQL?

Solution:

MySQL can not be used to execute script files.

Solution:

Which among the following is an optional Keyword?

Solution:

Which statement is used to delete an existing row from the table?

Solution:

Which statement can be used to specify the sql_mode system variable at runtime?

Solution:

The statement that constructs a branching flow-control construct is _____________

Solution:

Which of these columns are faster? Variable length, Fixed length

Solution:

Which of the following is a default database that comes with installation of MySQL?

Solution:

When no modes are enabled, the output of the statement "SELECT @@SESSION.sql_mode;" is _____.

Solution:

What will be the output of the query given below? SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;

Solution:

Related Question Sets:

Related Topics:

Which of these columns are faster?

`Variable length, Fixed length`

What will be the output of the query given below?

SELECT emp_id, fname, lname FROM employee WHERE title=’HEAD TELLER’;