Jobs By Abekus

How many values can be returned from a stored procedure?

1

0

2

1

3

2

4

3

Solution:

Which statement makes changes to the database’s global attributes?

1

CHANGE

2

ALTERNATE

3

ALTER

4

UPDATE

Solution:

Which type of database management system is MySQL?

1

Object Oriented

2

Relational

3

Network

4

Hierarchy

Solution:

What is generally done if an error occurs during the transaction?

1

delete

2

rollback

3

commit

4

update

Solution:

The maximum length of a column of type “char” is _______?

1

256 bytes

2

255 bytes

3

65, 535 bytes

4

None of the above

Solution:

Which operator is used to check whether the expression is “NULL”?

1

IS NULL

2

NOT NULL

3

ON

4

None of the mentioned

Solution:

Which of the following statements is/are correct?

1

True OR true =true

2

True OR false= true

3

False OR false= false

4

All of the mentioned

Solution:

Choose a correct option to Perform an addition operation on the SALARY and COMM column of the EMPLOYEE table in MySQL.

1

SELECT SALARY+COMM FROM EMPLOYEE;

2

SELECT NVL(COMM)+SALARY FROM EMPLOYEE;

3

SELECT SALARY+IFNULL(COMM) FROM EMPLOYEE;

4

b and c

Solution:

Which is not true regarding SQL aliases?

1

Aliases are often used to make column names more readable.

2

An alias is created with the "AS" keyword.

3

The alias operator allows you to specify multiple values in a "WHERE" clause.

4

An alias only exists for the duration of that query.

Solution:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);

1

All columns and rows belong to table employee

2

All columns but only those rows which contain ‘HEAD TELLER’ as a “title” and start_date are greater than 2013-01-24

3

All rows belong to table employee

4

None of the mentioned

Mysql Questions Set 20:

How many values can be returned from a stored procedure?

Solution:

Which statement makes changes to the database’s global attributes?

Solution:

Which type of database management system is MySQL?

Solution:

What is generally done if an error occurs during the transaction?

Solution:

The maximum length of a column of type “char” is _______?

Solution:

Which operator is used to check whether the expression is “NULL”?

Solution:

Which of the following statements is/are correct?

Solution:

Choose a correct option to Perform an addition operation on the SALARY and COMM column of the EMPLOYEE table in MySQL.

Solution:

Which is not true regarding SQL aliases?

Solution:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 20:

How many values can be returned from a stored procedure?

Solution:

Which statement makes changes to the database’s global attributes?

Solution:

Which type of database management system is MySQL?

Solution:

What is generally done if an error occurs during the transaction?

Solution:

The maximum length of a column of type “char” is _______?

Solution:

Which operator is used to check whether the expression is “NULL”?

Solution:

Which of the following statements is/are correct?

Solution:

Choose a correct option to Perform an addition operation on the SALARY and COMM column of the EMPLOYEE table in MySQL.

Solution:

Which is not true regarding SQL aliases?

Solution:

What will be the output of the query given below? SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date&gt;2013-01-24);

Solution:

Related Question Sets:

Related Topics:

What will be the output of the query given below?

SELECT * FROM employee WHERE (title=’HEAD TELLER’) AND (start_date>2013-01-24);