Ondelete clause is specified with
a.)Drop table
b.)Delete command
c.)Create table
d.)Select command

Answers were Sorted based on User's Feedback



Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select comm..

Answer / osboatdan

delete command

Is This Answer Correct ?    9 Yes 2 No

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select comm..

Answer / manish

create command

Ex.
CREATE TABLE mailing_group (
id int unsigned NOT NULL AUTO_INCREMENT ,
mailing_id int unsigned NOT NULL,
group_type enum('Include', 'Exclude'),
entity_table varchar(64) NOT NULL,
entity_id int unsigned NOT NULL,
PRIMARY KEY ( id ),
CONSTRAINT FK_civicrm_mailing_group_mailing_id FOREIGN
KEY (mailing_id) REFERENCES civicrm_mailing(id) ON DELETE
CASCADE
) ENGINE=MyISAM DEFAULT CHARACTER SET utf8 COLLATE
utf8_unicode_ci ;

Is This Answer Correct ?    6 Yes 2 No

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select comm..

Answer / sriram

Delete command

Is This Answer Correct ?    3 Yes 1 No

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select comm..

Answer / shilpa

Delete command

Is This Answer Correct ?    0 Yes 0 No

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select comm..

Answer / guest

C

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More MySQL Interview Questions

What do you understand by mysql terminal?

0 Answers  


How do I quit mysql?

0 Answers  


How to return query output in xml format?

0 Answers  


If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,


In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

0 Answers  


What is data type for image in mysql?

0 Answers  


What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

0 Answers  


What you can use regular expression for in mysql?

0 Answers  


What is prepared statement in mysql?

0 Answers  


Do you need a license for mysql?

0 Answers  


What is mysql optimization?

0 Answers  


How to dump one database for backup.

0 Answers  


Categories