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 is the command used to create a database using php and mysql?

0 Answers  


How do I insert multiple rows in a table?

0 Answers  


Write a query to stop mysql in unix

0 Answers  


What is the default port number of mysql?

0 Answers  


What are the differences between char and nchar?

0 Answers  


What is dblink?

0 Answers  


How do I change mysql password?

0 Answers  


What are the differences between drop a table and truncate a table?

10 Answers  


What are the critical issues you have resolved in your company

0 Answers   Wipro,


can you elaborate on blob and text in mysql? : Mysql dba

0 Answers  


Can you shard mysql?

0 Answers  


What is SERIAL data type in MySQL?

3 Answers   Aspire,


Categories