Jobs By Abekus

How many values can be returned from a given stored function?

1

0

2

1

3

2

4

3

Solution:

What is the maximum length for alias names in terms of characters?

1

64

2

32

3

128

4

256

Solution:

Which of the following is an illegal unquoted identifier name?

1

123

2

123id

3

id123

4

123_id

Solution:

Which statement is used for updating existing information in the table?

1

WHERE

2

UPDATE

3

MODIFY

4

ALTER

Solution:

Which data type is used to store data and time in Mysql?

1

Numeric datatype

2

Temporal datatype

3

Text datatype

4

Time Datatype

Solution:

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

1

gender ENUM,

2

gender ENUM( ),

3

gender ENUM("m' , 'f'),

4

none of the mentioned

Solution:

Which mode tells the server to recognize || as the string concatenation operator?

1

DOUBLE_PIPE_AS_CONCAT

2

PIPES_AS_CONCAT

3

ORS_AS_CONCAT

4

LOGIC_OR_AS_CONCAT

Solution:

What is the correct representation of the float value with 4 digits before the decimal and 2 digits after the decimal?

1

24.33

2

Both 24.33 and 124.4

3

124.40

4

12.12

Solution:

Which of these statements about triggers is true?

1

You do not create them with SQL.

2

They execute against only some applications that access a database.

3

They cannot cascade.

4

They have an event, condition, and action.

Solution:

Consider the below student table

^{S.no           Sname                  age                    country}

^{1.                 Alex                       19                    Ukraine}

^{2.                 Gupta                     21                   India}

^{3.                 Karishma              19                    India}

^{4.                 Surya                     20                    India}

^{5.                 Bhushan                22                   India}

Identify which query is suitable for the above table, extract the student details those who are the age greater than 20 and the country is India.

1

SELECT * from student WHERE country="India";

2

SELECT sname, age from student WHERE country="India" and age>20;

3

SELECT * from student WHERE country="India" and age>20;

4

SELECT sname from student WHERE country="India";

Mysql Questions Set 62:

How many values can be returned from a given stored function?

Solution:

What is the maximum length for alias names in terms of characters?

Solution:

Which of the following is an illegal unquoted identifier name?

Solution:

Which statement is used for updating existing information in the table?

Solution:

Which data type is used to store data and time in Mysql?

Solution:

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

Solution:

Which mode tells the server to recognize || as the string concatenation operator?

Solution:

What is the correct representation of the float value with 4 digits before the decimal and 2 digits after the decimal?

Solution:

Which of these statements about triggers is true?

Solution:

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 62:

How many values can be returned from a given stored function?

Solution:

What is the maximum length for alias names in terms of characters?

Solution:

Which of the following is an illegal unquoted identifier name?

Solution:

Which statement is used for updating existing information in the table?

Solution:

Which data type is used to store data and time in Mysql?

Solution:

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

Solution:

Which mode tells the server to recognize || as the string concatenation operator?

Solution:

What is the correct representation of the float value with 4 digits before the decimal and 2 digits after the decimal?

Solution:

Which of these statements about triggers is true?

Solution:

Consider the below student table S.no Sname age country 1. Alex 19 Ukraine 2. Gupta 21 India 3. Karishma 19 India 4. Surya 20 India 5. Bhushan 22 India Identify which query is suitable for the above table, extract the student details those who are the age greater than 20 and the country is India.

Solution:

Related Question Sets:

Related Topics: