12th Class ICS Computer Science Online MCQ Test for (Data Base Process)

Which of the following are ingredients of data modeling?

• Entities A
• Attributes B
• Relationship C
• All D

A data model is :

• A logical representation of the structure of the database A
• Shown as an entity-relationship diagram B
• Transformed into tables and relationships C
• All D

An entity related to itself in an ERD model refers to :

• Recursive relationship A
• One-to-many relationship B
• Many-to-many relationship C
• One-to-one relationship D

In a relational database a single piece of information is called:

• Table A
• Record B
• Entity C
• Attribute D

An index may be created on:

• Primary key A
• Secondary key B
• Foreign key C
• All D

• mendatory A
• optional B
• may be many C
• none of theses D

Which of the following is NOT included in the definition of an entity?

• Person A
• Object B
• Concept C
• Action D

A file is stored in:

• RAM A
• ROM B
• Cache C
• Hard disk D

Which of the following can be used as flag value

• + A
• # B
• - C
• all D

An entity related to itself in an ERD model refers to

• recursive relationship A
• one-to-many relationship B
• many to many relationship C
• on to one relationship D

Which of the following keys us not unique:

• Candidate key A
• Forein key B
• Primary key C
• Secondary key D

Types of translators are:

• Compiler A
• Interpreter B
• Assembler C
• All of these D

Which of the following is used to describe the characteristics of an object?

• Attribute A
• Relationship B
• Cardinality C
• Modality D

Data type int contain bytes:

• 10 A
• 4 B
• 2 C
• 1 D

The output of the statement print ("%2f', 11.4519), is

• 11.4519 A
• 11.45 B
• 11.51 C
• 11 D

Organizing the database in computer disk storage is done in:

• Logical design A
• Physical design B
• Analysis C
• Implimentation D

Which of the following is basic data distribution strategy?

• Centralized A
• Partitioned B
• Replication C
• All D