309
119.5k
Chapter:

1200+ more mcqs Solved MCQs

in DataBase Management System (DBMS)

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .

Chapters

More MCQs
1201.

Relational calculus is a

A. Procedural language.
B. Non- Procedural language.
C. Data definition language.
D. High level language
Answer» B. Non- Procedural language.
1202.

In a relational database a referential integrity constraint can be specified with the help of

A. primary key
B. foreign key
C. secondary key
D. none of the above
Answer» B. foreign key
1203.

A super key is a set of one or more attributes that, taken collectively, allow us

A. to identify uniquely an entity in the entity set
B. to make the key most powerful for faster retrieval
C. to increase effectiveness of database access
D. none of the above
Answer» A. to identify uniquely an entity in the entity set
1204.

4NF is designed to cope with:

A. Transitive dependency
B. Join dependency
C. Multi valued dependency
D. None of these
Answer» C. Multi valued dependency
1205.

A relational database developer refers to a record as

A. a criteria.
B. a relation.
C. a tuple.
D. an attribute.
Answer» C. a tuple.
1206.

The relational model feature is that there

A. is no need for primary key data.
B. is much more data independence than some other database models.
C. are explicit relationships among records.
D. are tables with many dimensions.
Answer» B. is much more data independence than some other database models.
1207.

SET concept is used in :

A. Network Model
B. Hierarchical Model
C. Relational Model
D. None of these
Answer» A. Network Model
1208.

Relational Algebra is

A. Data Definition Language .
B. Meta Language
C. Procedural query Language
D. None of the above
Answer» C. Procedural query Language

Done Studing? Take A Test.

Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.