Paper 2 CS · UNIT 04 · MOCK TEST

Mock 1 – ER Model & Database Concepts

Unit 4: Database Management Systems · 24 questions · about 28 minutes. Press End Mock any time to see your score and the correct answers.

All 11 topic-wise mocks in this unit

0 / 24 answered 00:00

Q1. In order to define the relationship between two entity sets, which of the following operations can be used?

AConcatenation BAdding CCartesian product DUnion

Q2. What is the correct sequence of database design process?
A. Create conceptual schema
B. Data model mapping
C. Requirements collection and analysis
D. Physical design
Choose the correct answer from the options given below:

AC, A, B, D BC, B, A, D CA, B, C, D DA, C, B, D

Q3. What will be the right sequence of the phases of database design?
A. Physical Design
B. Conceptual Design
C. Logical Design
D. Requirement collection and analysis
Choose the correct answer from the options given below:

AD, A, B, C BD, B, C, A CD, B, A, C DD, A, C, B

Q4. The degree of a relation in a database is

Athe number of tuples in the relation Bthe number of attributes in the relation Cthe number of values in the domain Dthe number of keys in a relation

Q5. Which of the following best describes the structure of a relational database?

AData organized into tables with rows and columns BData organized into files and folders CData organized into a hierarchical tree structure DData organized into a network of interconnected nodes

Q6. Given the basic ER diagram and the relational model, which of the following is INCORRECT?

AAn attribute of an entity can have more than one value BAn attribute of an entity can be composite CIn a row of a relational table, an attribute can have more than one value DIn a row of a relational table, an attribute can have exactly one value or a NULL value

Q7. Which of the following statements is correct according to the following instance of the relational schema R(X, Y, Z)?

X	Y	Z
1	1	a
1	1	a
2	1	b
3	2	b

AX → Y, Z → X BY → Z, Z → X CX → Y, X → Z DY → X, X → Z

Q8. Consider the following statements:
Statement I: Composite attributes cannot be divided into smaller subparts.
Statement II: A complex attribute is formed by nesting composite attributes and multivalued attributes in an arbitrary way.
Statement III: A derived attribute is an attribute whose values are computed from other attributes.
Which of the following is correct?

AStatements I, II and III are true BStatement I true and Statements II, III false CStatements I, II true and Statement III false DStatement I false and Statements II, III true

Q9. Size and complexity are a part of

APeople Metrics BProject Metrics CProcess Metrics DProduct Metrics

Q10. Which of the following is an indirect measure of product?

AQuality BComplexity CReliability DAll of these

Q11. Which design metric is used to measure the compactness of the program in terms of lines of code?

AConsistency BConciseness CEfficiency DAccuracy

Q12. Match the following for the UNIX file system:
List I: (A) Boot block (B) Super block (C) Inode block (D) Data block
List II: (I) Contains information about the file system — free block list, free inode list, etc. (II) Contains the operating system files as well as program and data files created by users. (III) Contains the boot program and partition table. (IV) Contains a table entry for every file in the file system, storing file attributes.

AA-III, B-I, C-II, D-IV BA-III, B-I, C-IV, D-II CA-IV, B-III, C-II, D-I DA-IV, B-III, C-I, D-II

Q13.

The degree of a relation in database is

Athe number of tuples in the relation Bthe number of attribute in the relation Cthe number of values in domian Dthe number of keys in a relation

Q14.

Given the basic E R diagram and relational model, which of the the following is incorrect?

AAn attribute of an entity can have more than one value BAn attribute of an entity can be composite CIn a row of relational table, an attribute can have more than one value DIn a row of a relational table, an attribute can have exactly one value or a NULL value

Q15.

Which of the following is consistent with this instance of R(X, Y, Z): (1, 1, a), (1, 1, a), (2, 1, b), (3, 2, b)?

AX → Y, Z → X BY → Z, Z → X CX → Y, X → Z DY → X, X → Z

Q16.

Statement I: Composite attributes cannot be divided into smaller subparts. Statement II: Complex attributes are formed by nesting composite and multivalued attributes in an arbitrary way. Statement III: A derived attribute is one whose values are computed from other attributes. Which is correct?

AStatements I, II and III are true BStatement I true and Statements II, III false CStatements I, II true and Statement III false DStatement I false and Statements II, III true

Q17.

Which of the DBMS component ensures that concurrent execution of multiple operations on the database results into a consistent database state?

ALogs BBuffer manager CFile manager DTransaction processing system

Q18.

Consider following two statements:

Statement I: Relational database schema represents the logical design of the database.

Statement II: Current snapshot of a relation only provides the degree of the relation. In the context to the above statements, choose the correct option from the options given below:

AStatement I is TRUE but Statement II is FALSE BStatement I is FALSE but Statement II is TRUE CBoth Statement I and Statement II are FALSE DBoth Statement I and Statement II are TRUE

Q19.

A company is consuming parts in the manufacturing of other products. Each of the part is either manufactured within the company or purchased from the external suppliers or both. For each part, partnumber, partname is maintained. Attribute batchnumber is maintained if the consumed part is manufactured in the company. If part is purchased from external supplier, then supplier name is maintained. Which of the following constraints need to be considered when modelling class/subclass concepts in ERD for the given problem.

ATotal specialization and overlapping constraints BDisjoint constraint only CPartial participation DPartial participation and disjoint constraints

Q20.

Match List I with List II.

AA-II, B-IV, C-III, D-I BA-IV, B-I, C-II, D-III CA-II, B-I, C-IV, D-III DA-III, B-IV, C-I, D-II

Q21.

Find the minimum number of tables required for converting the following entity relationship diagram into a relational database.

A2 B4 C3 D5

Q22.

Which of the following features is supported in the relational database model?

AComplex data-types BMultivalued attributes CAssociations with multiplicities DGeneralization relationships

Q23.

An attribute A of datatype varchar(20) has the value 'xyz', and the attribute B of datatype char(20) has the value 'lmnop'. Then attribute A has ___ spaces and attribute B has ___ spaces.

A3,5 B20,20 C3,20 D20,5

Q24.

Relations produced from E - R Model will always be in ________.

A1 NF B2 NF C3 NF D4 NF

Next: Mock 2 – Relational Model, Algebra & Calculus (Part 1) →