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

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  


What are federated tables?

0 Answers  


What is view in mysql?

0 Answers  


What are the two types of queries?

0 Answers  


What is difference between mysql_connect and mysql_pconnect?

0 Answers  


How to dump a table from a database.

0 Answers  


How to calculate the difference between two time values?

0 Answers  


Explain federated tables?

3 Answers   Tech Mahindra,


What is mysql and how it works?

0 Answers  


Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

0 Answers  


What is a scalar function?

0 Answers  


What is mysql database extension?

0 Answers  


Categories