Advanced SQL Questions

MCQ bookmark_border

41.

Updating the value of the view

A

Will affect the relation from which it is defined

B

Will not change the view definition

C

Will not affect the relation from which it is defined

D

Cannot determine

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

42.

SQL view is said to be updatable (that is, inserts, updates or deletes can be applied on the view) if which of the following conditions are satisfied by the query defining the view?

A

The from clause has only one database relation

B

The query does not have a group by or having clause

C

The select clause contains only attribute names of the relation and does not have any expressions, aggregates, or distinct specification

D

All of the mentioned

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

43.

Which of the following is used at the end of the view to reject the tuples which do not satisfy the condition in where clause?

A

With

B

Check

C

With check

D

All of the mentioned

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

44.

a)

A

Create table

B

Modify table

C

Alter table

D

Drop table

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

45.

Which of the following is not an integrity constraint?

A

Not null

B

Positive

C

Unique

D

Check

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

46.

What will be the result of the query?

A

All statements executed

B

Error in create statement

C

Error in insert into Employee values

D

Error in insert into Employee values

Correct Answer: D

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

47.

negative which of the following should be used?

A

Check

B

Check

C

Alter

D

Alter

Correct Answer: A

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

48.

Foreign key is the one in which the ________ of one relation is referenced in another relation.

A

Foreign key

B

Primary key

C

References

D

Check constraint

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

49.

Which of the following is used to delete the entries in the referenced table when the tuple is deleted in course table?

A

Delete

B

Delete cascade

C

Set null

D

All of the mentioned

Correct Answer: B

None.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

50.

Domain constraints, functional dependency and referential integrity are special forms of _________

A

Foreign key

B

Primary key

C

Assertion

D

Referential constraint

Correct Answer: C

None.

Check Answer report_problem Report forum Discussion