The statement used to create a trigger is . . . . . . . .

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

A

for insert, on

B

On, for insert

C

For, insert

D

None of the mentioned

Which of the following types of statement can trigger a trigger execution?

A

Only DML statements

B

Only DDL statements

C

Only DCL statements

D

Both DML & DDL statements

A statement is followed by two arguments. Decide which of the arguments is / are strong with respect to the statement. Statement: Should government run campaigns to create mass awareness to use fuel responsibly? Arguments: I. Yes, awareness is needed about the amount of natural resources used to generate electricity. This will create a sense of responsibility in the citizens. II. No, urbanisation has made people get used to comforts. It is very difficult to educate the massand from discipline.

A

Both I and II are strong.

B

Only argument II is strong.

C

Only argument I is strong

D

Neither I nor II is strong

Which statement is used to create a trigger?

A

CREATE TRIGGER

B

CREATE TRIGGERS

C

PRODUCE TRIGGER

D

PRODUCE TRIGGERS

The statement used to create a trigger is ______________

A

CREATE TRIGGER

B

CREATE TRIGGERS

C

PRODUCE TRIGGER

D

PRODUCE TRIGGERS

What is ghi in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

A

trigger name

B

table name

C

trigger statement

D

update statement

What is def in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

A

trigger name

B

table name

C

trigger statement

D

update statement

What is abc in the following MySQL statement?

CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;

A

trigger name

B

table name

C

trigger statement

D

update statement

Given is a statement followed by two arguments numbered I and II. Consider the statement and the arguments and decide which of the arguments is strong. Statement: Is the choice of junk food a better option to create interest in eating in children? Arguments: I. Yes, the best way to create interest is to give the food a child likes. II. No, junk food is the reason behind obesity, heart diseases, diabetes and other health problems and it is important to induce healthy eating habits in children.

A

Only argument II is strong.

B

Both arguments I and II are strong

C

Neither argument I nor II is strong

D

Only argument I is strong

Given is a statement followed by two arguments numbered I and II. Consider the statement and thearguments and decide which of the arguments is strong.
Statement:
Is the choice of junk food a better option to create interest in eating in children?
Arguments:
I. Yes, the best way to create interest is to give the food a child likes.
II. No. junk food is the reason behind obesity, heart diseases, diabetes and other health problems and itis important to induce healthy eating habits in children.

A

Only argument II is strong.

B

Both arguments I and II are strong.

C

Neither argument I nor H is strong.

D

Only argument I is strong.

The statement used to create a trigger is . . . . . . . .

Related Questions