Jobs By Abekus

Mysql Questions Set 5:

Quiz Mode

Which clause filters JOIN results?

SORT

GROUP

GROUP BY

WHERE

Solution:

The _____ SQL command changes one or more fields in a record.

LOOK-UP

INSERT

MODIFY

CHANGE

Solution:

The datatype for single precision floating point number is ____________

FLOAT

DOUBLE

INT

BIGINT

Solution:

The left and right joins are also known as __________

INNER JOIN

NATURAL JOIN

OUTER JOIN

CARTESIAN JOIN

Solution:

Which is the MySQL instance responsible for data processing?

MySQL client

MySQL server

SQL

Server daemon server

Solution:

The indicator of presence or absence of a word in search is used in which mode?

Boolean mode

Natural language

Query expansion

Cross mode

Solution:

To perform a delete on a single-table, how is the name of a column qualified?

qualification not necessary

column name

table name

database name

Solution:

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

PIPES_AS_CONCAT

DOUBLE_AS_CONCAT

LOGIC_OR_AS_CONCAT

ORS_AS_CONCAT

Solution:

Which of the following options correctly describes the DML (Data Manipulation Language) category?

SELECT, INSERT, DELETE, UPDATE

CREATE, DROP, ALTER, TRUNCATE

CREATE, INSERT, DELETE, TRUNCATE

SELECT, INSERT, ALTER, UPDATE

Solution:

What will be the output of the following query?

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

Only those employees are selected whose first name and last name started with ‘F’

Only those employees are selected whose first name started with ‘F’ but last name can be starts with any other letter

Only those employees are selected whose first name and last name started with any other letter except ‘F’

None of the mentioned

Mysql Questions Set 5:

Which clause filters JOIN results?

Solution:

The _____ SQL command changes one or more fields in a record.

Solution:

The datatype for single precision floating point number is ____________

Solution:

The left and right joins are also known as __________

Solution:

Which is the MySQL instance responsible for data processing?

Solution:

The indicator of presence or absence of a word in search is used in which mode?

Solution:

To perform a delete on a single-table, how is the name of a column qualified?

Solution:

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

Solution:

Which of the following options correctly describes the DML (Data Manipulation Language) category?

Solution:

What will be the output of the following query?

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

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 5:

Which clause filters JOIN results?

Solution:

The _____ SQL command changes one or more fields in a record.

Solution:

The datatype for single precision floating point number is ____________

Solution:

The left and right joins are also known as __________

Solution:

Which is the MySQL instance responsible for data processing?

Solution:

The indicator of presence or absence of a word in search is used in which mode?

Solution:

To perform a delete on a single-table, how is the name of a column qualified?

Solution:

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

Solution:

Which of the following options correctly describes the DML (Data Manipulation Language) category?

Solution:

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

Solution:

Related Question Sets:

Related Topics:

What will be the output of the following query?

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