Menu

Question Discussion & Solution

MCQ

Q.

Which of the following gives a logical structure of the database graphically?

A

Entity-relationship diagram

B

Entity diagram

C

Database diagram

D

Architectural representation

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.

What is a relationship called when it is maintained between two entities?

A

Unary

B

Binary

C

Ternary

D

Quaternary

Discussion

MCQ

2.

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 (such as the email address, or phone number) before the record is accepted

C

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

D

Then entering an order quantity, the user must input a number and not some text (i.e., 12 rather than

Discussion

MCQ

3.

. In an E-R diagram attributes are represented by

A

rectangle

B

square

C

ellipse

D

triangle

Discussion

MCQ

4.

A relational database consists of a collection of

A

Tables

B

Fields

C

Records

D

Keys

Discussion

MCQ

5.

A window into a portion of a database is

A

Schema

B

View

C

Query

D

Data dictionary

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