Jobs By Abekus

Mysql Questions Set 65:

Quiz Mode

The AUTO_INCREMENT sequences begin at __________

-1

Solution:

In UNIX, the name of the option file is __________

.my.ini

.my.opt

.my.cnf

.my.opc

Solution:

Which keyword is used to delete all the rows from the table?

REMOVE

TRUNCATE

DELETE ALL

CLEAR

Solution:

To check how MySQL will execute a SELECT query, which statement is used?

TELL

SHOW

EXPLAIN

DISPLAY

Solution:

Is The “optimizer_prune_level” parameter set by default?

true

fasle

depends on the system

can't be answered

Solution:

What executes on a time activated basis according to a schedule?

Events

Stored procedures

Stored program

Triggers

Solution:

Fill the blank with a suitable option.
To perform the analysis of the key values by the server, the instruction ______ is used.

ANALYZE KEYS

ANALYZE TABLE

PERFORM ANALYSIS

PERFORM TABLE ANALYSIS

Solution:

What is the durability property of transactions?

statements form a logic unit

database remains consistent

one transaction does not affect the other

transaction effects are recorded permanently

Solution:

Write the query to get all “Last_Name” in the lowercase of the employee table.

SELECT LOWER(Last_name) FROM employee;

SELECT (Last_name).LOWER FROM employee;

SELECT (Last_name) FROM employee;

SELECT LOWER(Last_name) FROM TABLE employee;

Solution:

Write the query to get the employee’s department and total salary, grouped by the department of the employee table.

SELECT Departement, SUM(Salary) AS total

FROM employee

GROUP BY Departement;

SELECT Departement, SUM(Salary) AS total

FROM TABLE employee

GROUP BY Departement;

SELECT Departement, SUM(Salary) AS total

FROM employee

ORDER BY Departement;

SELECT Departement, SUM(Salary) AS total

FROM employee TABLE

GROUP BY Departement;

Mysql Questions Set 65:

The AUTO_INCREMENT sequences begin at __________

Solution:

In UNIX, the name of the option file is __________

Solution:

Which keyword is used to delete all the rows from the table?

Solution:

To check how MySQL will execute a SELECT query, which statement is used?

Solution:

Is The “optimizer_prune_level” parameter set by default?

Solution:

What executes on a time activated basis according to a schedule?

Solution:

Fill the blank with a suitable option.
To perform the analysis of the key values by the server, the instruction ______ is used.

Solution:

What is the durability property of transactions?

Solution:

Write the query to get all “Last_Name” in the lowercase of the employee table.

Solution:

Write the query to get the employee’s department and total salary, grouped by the department of the employee table.

Solution:

Related Question Sets:

Related Topics:

Mysql Questions Set 65:

The AUTO_INCREMENT sequences begin at __________

Solution:

In UNIX, the name of the option file is __________

Solution:

Which keyword is used to delete all the rows from the table?

Solution:

To check how MySQL will execute a SELECT query, which statement is used?

Solution:

Is The “optimizer_prune_level” parameter set by default?

Solution:

What executes on a time activated basis according to a schedule?

Solution:

Fill the blank with a suitable option.To perform the analysis of the key values by the server, the instruction ______ is used.

Solution:

What is the durability property of transactions?

Solution:

Write the query to get all “Last_Name” in the lowercase of the employee table.

Solution:

Write the query to get the employee’s department and total salary, grouped by the department of the employee table.

Solution:

Related Question Sets:

Related Topics:

Fill the blank with a suitable option.
To perform the analysis of the key values by the server, the instruction ______ is used.