This topic contains a solution. Click here to go to the answer
« previous next »

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

stephzh

  • Hero Member
  • *****
  • Posts: 556
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?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

dyrone

  • Sr. Member
  • ****
  • Posts: 322
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.


stephzh

  • Member
  • Posts: 556
Reply 2 on: Jul 7, 2018
:D TYSM

LegendaryAnswers

  • Member
  • Posts: 341
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Spiral Galaxies (Nearly Face-on Views) Spiral Galaxies (Nearly Face-on Views)
Three views of neurulation in an amphibian embryo Three views of neurulation in an amphibian embryo
Normal lab values Normal lab values
Views of Hard Stabilization Views of Hard Stabilization
Hokusai, Sunshu Ejiri, from the series Thirty-Six Views of Mount Fuji. Hokusai, Sunshu Ejiri, from the series Thirty-Six Views of Mount Fuji.
How to setup and solve a half-life problem using a table of values (Question 1) How to setup and solve a half-life problem using a table of values (Question 1)
Video: The Lac Operon in E. Coli

For a complete list of videos, visit our video library