1.	In an e-r diagram double lines indicate

A . Total participation.

B . Multiple participation.

C . Cardinality N.

D . None of the above.

Answer

2.	Relationships among relationships can be represented in an-E-R model using

A . Aggregation

B . Association

C . Weak entity sets

D . Weak relationship sets

Answer

3.	In the relational modes, cardinality is termed as:

A . Number of tuples.

B . Number of attributes.

C . Number of tables.

D . Number of constraints.

Answer

4.	In the architecture of a database system external level is the

A . physical level.

B . logical level.

C . conceptual level

D . view level.

Answer

5.	An entity set that does not have sufficient attributes to form a primary key is a

A . strong entity set.

B . weak entity set.

C . simple entity set.

D . primary entity set.

Answer

6.	In a Hierarchical model records are organized as

A . Graph.

B . List.

C . Links.

D . Tree.

Answer

7.	In an E-R diagram attributes are represented by

A . rectangle.

B . square.

C . ellipse.

D . triangle.

Answer

8.	In an E-R diagram an entity set is represent by a

A . rectangle.

B . ellipse.

C . diamond box.

D . circle.

Answer

9.	A relational database developer refers to a record as

A . a criteria.

B . a relation.

C . a tuple.

D . an attribute.

Answer

10.	Which of the following are the properties of entities?

A . Groups

B . Table

C . Attributes

D . Switchboards

Answer

11.	Which of the following operation is used if we are interested in only certain columns of a table?

A . PROJECTION

B . SELECTION

C . UNION

D . JOIN

Answer

12.	Which database level is closest to the users?

A . External

B . Internal

C . Physical

D . Conceptual

Answer

13.	Which are the two ways in which entities can participate in a relationship?

A . Passive and active

B . Total and partial

C . Simple and Complex

D . All of the above

Answer

14.	In E-R Diagram derived attribute are represented by

A . Ellipse

B . Dashed ellipse

C . Rectangle

D . Triangle

Answer

15.	In E-R Diagram relationship type is represented by

A . Ellipse

B . Dashed ellipse

C . Rectangle

D . Diamond

Answer

16.	Hierarchical model is also called

A . Tree structure

B . Plex Structure

C . Normalize Structure

D . Table Structure

Answer

17.	In E-R diagram generalization is represented by

A . Ellipse

B . Dashed ellipse

C . Rectangle

D . Triangle

Answer

18.	In the relational modes, cardinality is termed as:

A . Number of tuples.

B . Number of attributes.

C . Number of tables.

D . Number of constraints.

Answer

19.	The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

A . Simple attribute

B . Composite attribute

C . Multivalued attribute

D . Derived attribute

Answer

20.	The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

A . Single valued

B . Multi valued

C . Composite

D . Derived

Answer

21.	Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________

A . Relations, Attribute

B . Attributes, Relation

C . Tuple, Relation

D . Tuple, Attributes

Answer

22.	Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.

A . Attributes of common

B . Tuple of common

C . Tuple of distinct

D . Attributes of distinct

Answer

23.	Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.

A . Instance, Schema

B . Relation, Schema

C . Relation, Domain

D . Schema, Instance

Answer

24.	Student(ID, name, dept name, tot_credits) In this Schema which attributes form the primary key?

A . Name

B . Dept

C . Tot_cred

D . ID

Answer

---

Relevant Materials :

☞ Database Management System Objective Type Question Bank-Unit-1 - [ DBMS ]

☞ Database Management System Objective Type Question Bank-Unit-2 - [ DBMS ]

☞ Database Management System Objective Type Question Bank-Unit-3 - [ DBMS ]

☞ Database Management System Objective Type Question Bank-Unit-4 - [ DBMS ]

☞ Database Management System Objective Type Question Bank-Unit-5 - [ DBMS ]

---

Similar Materials :

☞ R - Programming MCQs - Unit-1 - [ R-Programming ]

☞ R - Programming MCQs - Unit-2 - [ R-Programming ]

☞ R - Programming MCQs - Unit-3 - [ R-Programming ]

☞ R - Programming MCQs - Unit-4 - [ R-Programming ]

☞ R - Programming MCQs - Unit-5 - [ R-Programming ]

☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-1 - [ FLAT ]

☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-2 - [ FLAT ]

☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-3 - [ FLAT ]

☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-4 - [ FLAT ]

☞ Formal Languages and Automata Theory (FLAT) MCQs - Unit-5 - [ FLAT ]

☞ PPS MCQs - Unit-1 - [ PPS ]

☞ PPS MCQs - Unit-2 - [ PPS ]

☞ PPS MCQs - Unit-3 - [ PPS ]

☞ PPS MCQs - Unit-4 - [ PPS ]

☞ PPS MCQs - Unit-5 - [ PPS ]

☞ Object Oriented Programming through Java MCQs - Unit-1 - [ OOP_JAVA ]

☞ Object Oriented Programming through Java MCQs - Unit-2 - [ OOP_JAVA ]

☞ Object Oriented Programming through Java MCQs - Unit-3 - [ OOP_JAVA ]

☞ Object Oriented Programming through Java MCQs - Unit-4 - [ OOP_JAVA ]

☞ Object Oriented Programming through Java MCQs - Unit-5 - [ OOP_JAVA ]

☞ Design and Analysis of Algorithms MCQs - Unit-1 - [ DAA ]

☞ Design and Analysis of Algorithms MCQs - Unit-2 - [ DAA ]

☞ Design and Analysis of Algorithms MCQs - Unit-3 - [ DAA ]

☞ Design and Analysis of Algorithms MCQs - Unit-4 - [ DAA ]

☞ Design and Analysis of Algorithms MCQs - Unit-5 - [ DAA ]

☞ Software Engineering MCQs - Unit-1 - [ SE ]

☞ Software Engineering MCQs - Unit-2 - [ SE ]

☞ Software Engineering MCQs - Unit-3 - [ SE ]

☞ Software Engineering MCQs - Unit-4 - [ SE ]

☞ Software Engineering MCQs - Unit-5 - [ SE ]

☞ Data Mining MCQs - Unit-1 - [ DM ]

☞ Data Mining MCQs - Unit-2 - [ DM ]

☞ Data Mining MCQs - Unit-3 - [ DM ]

☞ Data Mining MCQs - Unit-4 - [ DM ]

☞ Data Mining MCQs - Unit-5 - [ DM ]

☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-1 - [ COA ]

☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-2 - [ COA ]

☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-3 - [ COA ]

☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-4 - [ COA ]

☞ Computer Organization and Architecture (COA) Objective Question Bank-Unit-5 - [ COA ]

☞ Data Structures Objective Type Question Bank-Unit-1 - [ DS ]

☞ Data Structures Objective Type Question Bank-Unit-2 - [ DS ]

☞ Data Structures Objective Type Question Bank-Unit-3 - [ DS ]

☞ Data Structures Objective Type Question Bank-Unit-4 - [ DS ]

☞ Data Structures Objective Type Question Bank-Unit-5 - [ DS ]

☞ Cyber Forensics Objective Type Question Bank-Part-2 - [ Cyber Forensics ]

☞ Cyber Forensics Objective Type Question Bank-Part-1 - [ Cyber Forensics ]

☞ Java Programming Objective Type Question Bank - [ Java Programming ]

☞ Java Programming Objective Type Questions-Part-1 - [ Java Programming ]

☞ Java Programming Objective Type Questions-Part-2 - [ Java Programming ]