Menu

Question Discussion & Solution

MCQ

Q.

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

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Login to Discuss

Similar Questions

MCQ

1.

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

A

Foreign key

B

Primary key

C

Assertion

D

Referential constraint

Discussion

MCQ

2.

The variables in the triggers are declared using

A

?

C

/

D

/

Discussion

MCQ

3.

a _______ query that is nonrecursive and a __________ query.

A

Base, recursive

B

Recursive, Base

C

Base, Redundant

D

View, Base

Discussion

MCQ

4.

Which of the following can be addressed by enforcing a referential integrity constraint?

A

All phone numbers must include the area code

B

Certain fields are required

C

Information on the customer must be known before anything can be sold to that customer

D

When entering an order quantity, the user must input a number and not some text

Discussion

MCQ

5.

Which of the following is an advantage of view?

A

Data security

B

Derived columns

C

Hiding of complex queries

D

All of the above

Discussion

More Database Management System Topics

Miscellaneous or General

71 MCQs

Relational Algebra

3 MCQs

Database Systems

49 MCQs

Data Models

16 MCQs

The Relational Database Model

58 MCQs

Entity Relationship (ER) Modeling

59 MCQs

Advanced Data Modeling

1 MCQs

Normalization

58 MCQs

Structured Query Language (SQL)

7 MCQs

Advanced SQL

90 MCQs

Database Design

2 MCQs

Transaction and Concurrency

10 MCQs

Data Warehouses

10 MCQs

Database Administration

1 MCQs

Mixed

10 MCQs