[go: up one dir, main page]
Scribd
Upload
953 views7 pages

18CSC303J - (Database Management Systems) UNIT-2 Multiple Choice Questions

The document contains 31 multiple choice questions related to concepts in database management systems including: - Functional requirements versus database design - The physical design phase and what it involves - Components of the ER model like entity sets and relationship sets - Relationship types and attributes - Data types like composite and multi-value attributes - Keys like primary and foreign keys - Constraints like unique, not null and check - Generalization and specialization in ER diagrams - Converting an ER model to relational tables

Uploaded by

Ch Rd ctd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
953 views7 pages

18CSC303J - (Database Management Systems) UNIT-2 Multiple Choice Questions

The document contains 31 multiple choice questions related to concepts in database management systems including: - Functional requirements versus database design - The physical design phase and what it involves - Components of the ER model like entity sets and relationship sets - Relationship types and attributes - Data types like composite and multi-value attributes - Keys like primary and foreign keys - Constraints like unique, not null and check - Generalization and specialization in ER diagrams - Converting an ER model to relational tables

Uploaded by

Ch Rd ctd
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 7

18CSC303J – (Database Management Systems)

UNIT-2
MULTIPLE CHOICE QUESTIONS
1. Functional requirement or database design..............
A. Describe about kind of operation translation could be performed on the data.
B. Describe functionality of program
C. Describe functionality of query language
D. Describe functionality of each and every data element

2. Physical design phase of the database design involved ..............


A. File organization only
B. Internal storage only
C. Both file organization and internal storage.
D. None of the above

3. ER Model…............
A. Uses collection of entity and relationship among them.
B. Collection of entity
C. Describe relationship alone without entity definition
D. Hierarchical model

4. Which is not part of ER Model basic concept


A. Entity set
B. Relationship set
C. Attributes
D. Attribute set

5. Regressive relationship set is.................


A. Same entity set participate in relationship set more than once in difference roles.
B. Same entity set participate in relationship set more than once in same roles
C. Different entity set participate in relationship set more than once in difference roles
D. Same entity set participate in relationship set more than once in same roles

6. Composite attributes are one….................


A. Whose values are unique
B. Whose values can be divided into sub part.
C. Whose values can be divided into only two parts
D. Whose values can’t be divided into sub parts

7. Which is not multi value attribute?


A. Phone_no
B. Date of birth
C. Email-id
D. Vehicle of the person

8. Which could be a derived values attribute?


A. Faculty_Id
B. Age
C. Monthly_salary
D. Aadhar_Id

9. Which is not true for ER diagram?


A. Diamond represents relationship set symbol
B. Undivided rectangular represents attributes of relationship set
C. Divided rectangular represents attributes of relationship set.
D. Dashed line link attributes of relationship set to relationship set

10. Identify which option is correct:

A. Many - One relationship


B. One – Many relationship
C. One- One relationship
D. Many-Many relationship

11. Which is not the complex/composite attributes?


A. Faculty-name
B. Faculty-address
C. Student-name
D. Date of birth

12. to_char(‘date', format) use….................


A. Reformats data according to format.
B. Converts the strings into given format
C. Months added to data
D. Number of months between two dates

13. months_between(d1, d2) use............


A. Numbers of dates between two dates
B. Date corresponding to the last day of the month
C. Date of the day that immediately follows the date ’d’.
D. None of the above

14. Identify which option is correct:

A. Many - One relationship


B. One – Many relationship
C. One- One relationship
D. Many-Many relationship

15. Log (b,n) is use for….........


A. LOG n base b
B. Log b base n
C. Natural log of n (base e)
D. Natural log of e (base n)

16. Which is not true for group function.............


A. Group functions has no null values
B. Columns that are not a part of the group functions
C. Group functions can be placed in the where clause.
D. Having clause is to restrict groups

17. Super key is…............


A. A set of one or more attribute to identify uniquely a record in the relation.
B. It is only a one key with only one attribute used to define super class
C. It is a foreign key for identify parent class
D. It is a foreign key for identifying child class

18. A primary key can be…...................


A. Name of the person
B. Salary of the person
C. Date of Birth
D. Aadhar Id

19. Which one is the composite attribute?


A. Register number
B. Age
C. Branch
D. Address

20. Which is not a single value attribute?


A. Regd number
B. Gender
C. Date of Birth
D. Mobile number

21. Which one is the derived attribute?


A. Age
B. Email Id
C. Ph number
D. Gender

22. Which could be a key attribute for student database


A. Age
B. Branch
C. Name
D. Register number

23. In order to avoid duplicate value what constraints we have impose


A. Not a null
B. Unique
C. Primary key
D. Check

24. Not null constraints…......


A. It will not accept null value
B. It will not accept duplicate value
C. It will accept null value
D. N numbers of constraints is not possible in a relationship

25. Foreign key..........


A. It is a primary key that will be a referential key for another table.
B. It will not allow duplicate values
C. Not allow null value
D. It is not a primary key that will be a referential key for another table

26. Specialization is ….............


A. Create sub group with an entity by some special attributes.
B. Create sub group between entity
C. Defining initial entity into successive level of entity
D. Combining entity

27. In E-R diagram specialization is indicated by.........


A. Filled arrow head
B. Line arrow head
C. Hollow arrow head
D. Double side arrow head

28. Employee is generalized of...........


A. Faculty, secretary, storekeeper
B. Student, car, bus
C. Male, female
D. Salary, employee id
29. The term tuple is used to refer …..........
A. A column of table
B. A table
C. A rows of table
D. Collection of tables

30. Converting ER model to relational table for strong entity set with multi value attributes will
create …....... no of tables
A. 1 table
B. 2 table
C. 3 table
D. Multi table

31. E-R diagram after conversion to relational table will be

A.

Regd Name Ph-no

B.

Regd Name

C.

Regd.no Ph.no

Regd.no Name

D.

Name Regd.no
name Ph.no

Correct option: C

You might also like