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 86 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
Great answer, keep it coming :)

jackie

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

Your skin wrinkles if you stay in the bathtub a long time because the outermost layer of skin (which consists of dead keratin) swells when it absorbs water. It is tightly attached to the skin below it, so it compensates for the increased area by wrinkling. This happens to the hands and feet because they have the thickest layer of dead keratin cells.

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Radio Views of Saturn Radio Views of Saturn
Use dye specifically made for coolant when checking for leaks using a black light. Use dye specifically made for coolant when checking for leaks using a black light.
Using the cursors on the oscilloscope, the high- and low-oxygen sensor values can be displayed on ... Using the cursors on the oscilloscope, the high- and low-oxygen sensor values can be displayed on ...
How to create a table of values displaying commission and earnings (Question 1) How to create a table of values displaying commission and earnings (Question 1)
Two Views of Mercury Two Views of Mercury
Sketch the graph using the tables providing. Determine if each function is continuous or ... Sketch the graph using the tables providing. Determine if each function is continuous or ...
Video: Genetics of Cancer

For a complete list of videos, visit our video library