This topic contains a solution. Click here to go to the answer

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

stephzh

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


meow1234

  • Member
  • Posts: 333
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

 

Did you know?

The average older adult in the United States takes five prescription drugs per day. Half of these drugs contain a sedative. Alcohol should therefore be avoided by most senior citizens because of the dangerous interactions between alcohol and sedatives.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

ACTH levels are normally highest in the early morning (between 6 and 8 A.M.) and lowest in the evening (between 6 and 11 P.M.). Therefore, a doctor who suspects abnormal levels looks for low ACTH in the morning and high ACTH in the evening.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

For a complete list of videos, visit our video library