Author Question: SQL triggers are used for providing default values, validity checking, updating views, and ... (Read 32 times)

stephzh · **on:** Jul 7, 2018

SQL triggers are used for providing default values, validity checking, updating views, and performing referential integrity actions.

Indicate whether the statement is true or false

Question 2

Describe how to create a new database in MySQL 5.6 Community Server Edition.

What will be an ideal response?

dyrone · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

TRUE

Answer to Question 2

In MySQL 5.6 Community Server Edition, new databases are created in the MySQL Workbench. Click the Create a new schema in the connected server button in the Object Browser. The new_schema tabbed window is displayed. Enter the database name and click the Apply button. The Apply SQL Script to Database dialog box is displayed. Click the Apply SQL button and then, after the SQL script has run, click the Finish button. In the new_schema tabbed window, click the Close button. The new schema appears in the Object Browser.