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

Can anyone help me to create a good mysql database schema with an example. Thanks, Sekar.jr

1 Answers  


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

0 Answers  


What is a storage engine?

0 Answers  


how to Return total number of rows.

0 Answers  


What is the usage of "i-am-a-dummy" flag in mysql?

0 Answers  






How to increment dates by 1 in mysql?

0 Answers  


How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.

0 Answers  


How to check server status with 'mysqladmin'?

0 Answers  


How do you prevent MySQL from caching a query?

1 Answers  


Does adding an index lock a table?

0 Answers  


What is mysql connector used for?

0 Answers  


What is difference between inner vs self vs cross?

0 Answers  


Categories