Advanced SQL Questions

MCQ bookmark_border

72.

Find the error in the the above statement.

A

Return type missing

B

Dept_name is mismatched

C

Reference relation is not mentioned

D

All of the mentioned

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

73.

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

A

Procedures

B

Triggers

C

Functions

D

None of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

74.

Triggers are supported in

A

Delete

B

Update

C

Views

D

All of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

75.

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

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

76.

What are the after triggers?

A

Triggers generated after a particular operation

B

These triggers run after an insert, update or delete on a table

C

These triggers run after an insert, views, update or delete on a table

D

All of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

77.

The variables in the triggers are declared using

A

?

C

/

D

/

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

78.

a)

A

.txt

B

.pls

C

.ora

D

.sql

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

79.

supported trigger?

A

BEFORE

B

DURING

C

AFTER

D

INSTEAD OF

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

80.

What are the different in triggers?

A

Define, Create

B

Drop, Comment

C

Insert, Update, Delete

D

All of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion