Shell> mysqlsh --host=localhost --user=root -p

Now, examine this command:

Localhost:33060 JS> session

What is the result?

SHOW CREATE VIEW cityview\G;

*************************** 1. row ***************************

View: cityview

Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost`

SQL SECURITY DEFINER VIEW `cityview` AS

Select `city`.`Name` AS `Name`, `city`.`Population` AS `Population`

From `city`

character_set_client: utf8mb4

collation_connection: utf8mb4_0900_a

Now examine this statement executed as root and output:

UPDATE cityview SET Population=2643585 WHERE Name="Roma";

ERROR: 1288 (HY000): The target table cityview of the UPDATE is not updatable

What must precede the UPDATE to avoid this error?

12325.1251717337

6212

551.124111

Which data type will store the values without loss of precision?

SELECT ename, esalary, ebonus FROM employees;

| ename | esalary | ebonus |

|-----------------------|------------|------------|

| Duangkaew Piveteau | 158526.000 | 23109.0000 |

| Mary Sluis | 154070.000 | 7183.0000 |

| Patricio Bridgland | 94771.000 | 23578.0000 |

| Eberhardt Terkki | 91648.000 | 8346.0000 |

| Berni Genin | 113982.000 | 27998.0000 |

| Guoxiang Nooteboom | 94698.000 | 26954.0000 |

| Kazuhito Cappelletti | 71703.000 | 20777.0000 |

| Cristinel Bouloucos | 154424.000 | 22021.0000 |

| Kazuhide Peha | 77013.000 | NULL |

| Lillian Haddadi | 141791.000 | NULL |

| Mayuko Warwick | 137916.000 | NULL |

You must return the ename and the sum of the esalary and ebonus as etotal_pay for all employees.

Which will return the desired result?

  "query_block": {

    "select_id": 1,

    "cost_info": {

      "query_cost": "0.45"

    },

    "table": {

      "table_name": "country",

      "access_type": "ALL",

      "rows_examined_per_scan": 2,

      "rows_produced_per_join": 2,

      "filtered": "100.00",

      "cost_info": {

        "read_cost": "0.25",

        "eval_cost": "0.20",

        "prefix_cost": "0.45",

        "data_read_per_join": "224"

      },

      "used_columns": [

        "code",

        "Name",

        "Continent",

        "LanguageId"

      ]

    }

  }

}

Which EXPLAIN command will obtain the output?

The participants' details are stored in another table.

CREATE TABLE meeting (

id INT NOT NULL AUTO_INCREMENT,

name VARCHAR(100),

start_time VARCHAR(20),

duration VARCHAR(20),

PRIMARY KEY (id)

)

You need to adjust the start_time and duration columns for optimal storage.

What datatype changes would achieve this?

INSERT INTO authors (first_name,last_name)

VALUES ('William','Shakespeare');

Query OK, 1 row affected, 1 warning (0.00 sec)

SHOW WARNINGS;

+---------+------+-----------------------------------------------+

| Level | Code | Message |

+---------+------+-----------------------------------------------+

| Warning | 1265 | Data truncated for column 'last_name' at row 1|

+---------+------+-----------------------------------------------+

Which SQL Mode will cause this INSERT to raise an error instead of a warning?

START TRANSACTION;

UPDATE t1 SET c=100 WHERE id=1;

ALTER TABLE t1 ADD INDEX (c);

INSERT INTO t1 (c) VALUES (200);

COMMIT;

How many transactions have committed?

What is the output?

SET @j = '["a","b","b","c","d","e"]';

Now, examine this output:

[1, "b", "b", "c", "d", "e"]

Which statement produces the output?

E_id INT, e_name VARCHAR(45), dept_id INT, salary INT

You must create a stored function, getMaxSalary(), which returns the maximum salary paid for a given department id.

Which statement will create the function?

（含图）

Which set of statements immediately returns empname for a given emp_id by using a parameterized PREPARE statement?

Session 0> LOCK TABLES test.t1 READ, test.t2 WRITE;

The user running this session now goes to lunch for an hour.

Now, examine these statements executed independently in separate sessions while Session 0 is still active:

_{Session 1> SELECT * FROM test.t2;}

_{Session 2> SELECT * FROM test.t2 FOR UPDATE NOWAIT;}

_{Session 3> SELECT * FROM test.t1;}

_{Session 4> INSERT INTO test.t1 VALUES (0,'a','b');}

_{Session 5> SELECT * FROM t1 FOR UPDATE NOWAIT;}

How many of them will complete while Session 0 is still active?