Paper 2 CS · UNIT 04 · MOCK TEST

Mock 11 – Mixed Practice

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

All 11 topic-wise mocks in this unit

0 / 13 answered 00:00

Q1. What will be the order of the typical steps when processing a high-level query?
A. Query optimizer
B. Runtime database processor
C. Scanning, parsing and validating
D. Query code generator
Choose the correct answer from the options given below:

AD, A, C, B BC, A, D, B CC, D, B, A DD, C, B, A

Directions (Q96–100): A company is implementing a new database system to manage its customer information. The database contains tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representative who manages the account. The database is designed to improve efficiency in tracking sales and customer interactions.

Q2. Based on the passage, which of the following statements is true?

AEach customer can place only one order. BEach sales representative can manage multiple customer accounts. CEach order can be associated with only one product. DThe database does not include a table for products.

Q3. In which of the following database models do we have a parent-child relationship?
1. Hierarchical databases
2. Network databases
3. Relational databases
Choose the correct answer from the options given below:

A1, 2 B1, 3 C2, 3 D1, 2, 3

Q4. Identify the correct operation that produces the given output from the two relations R1 and R2.

Name	Class
a1	9
b1	5
c1	6
d1	11

Name	Class
b1	5
f1	8

Output

Name	Class
b1	5

AR1 ∩ R2 BR1 − R2 CR1 − (R1 − R2) DR1 ∪ R2

Q5. A software project was estimated at 864 Function Points. A six-person team will be assigned to the project consisting of one requirement gathering person, one designer, two programmers and two testers. The salary of the requirement gatherer is Rs. 50,000 per month, the designer Rs. 70,000 per month, and each programmer and each tester Rs. 60,000 per month. The average productivity for the team is 12 Function Points per person-month. Which of the following represents the projected cost of the project?

ARs. 33,20,000 BRs. 43,20,000 CRs. 33,10,000 DRs. 22,10,000

Q6. A software project was estimated at 352 Function Points (FP). A four person team will be assigned to this project consisting of a project manager who will be paid ₹80,000 per month, two programmers who will be paid ₹60,000 per month each and one tester who will be paid ₹50,000 per month. The average productivity for the team is 8 FP per person month. Which of the following represents the projected cost of the project?

A₹28,16,000 B₹20,90,000 C₹26,95,000 D₹27,50,000

Q7. A software company needs to develop a project that is estimated as 1000 function points and is planning to use JAVA as the programming language whose approximate lines of code per function point is accepted as 50. Considering a = 1.4 as multiplicative factor, b = 1.0 as exponential factor for the basic COCOMO effort equation and c = 3.0 as multiplicative factor, d = 0.33 as exponential factor for the basic COCOMO duration equation, approximately how long does the project take to complete?

A11.2 months B12.2 months C13.2 months D10.2 months

Q8. The functional requirements of a proposed system have been estimated as 500 function points. Assume that JAVA is the programming language with the LOC/FP ratio of 50. Using the basic COCOMO effort equation E = a(KLOC)^b with a = 2.5 and b = 1.0, the estimated effort is

A25 person months B75 person months C62.5 person months D72.5 person months

Q9. Suppose there are six files F1, F2, F3, F4, F5, F6 with corresponding sizes 150 KB, 225 KB, 75 KB, 60 KB, 275 KB and 65 KB respectively. The files are to be stored on a sequential device in such a way that optimizes (average) access time. In what order should the files be stored?

AF5, F2, F1, F3, F6, F4 BF4, F6, F3, F1, F2, F5 CF1, F2, F3, F4, F5, F6 DF6, F5, F4, F3, F2, F1

Q10. In UNIX, files are protected using a 9-bit permission mode ("rights bits"). Consider the statements: (I) A mode of 641 (octal) means the owner can read and write the file, other members of the owner's group can only read it, and all other users can only execute it. (II) A mode of 100 (octal) allows the owner to execute the file, but prohibits all other access. Which of the following is correct?

AOnly I is correct BOnly II is correct CBoth I and II are correct DBoth I and II are incorrect

Q11.

Match the LIST-I with LIST-II

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

Directions (Q96–100): A company is implementing a new database to manage customer information. It holds tables for customers, orders, products and sales representatives. Each customer can place multiple orders and each order can contain multiple products. Each order is associated with a specific sales representative who manages the account. The design aims to improve tracking of sales and customer interactions.

Q12.

Which of the following best describes the relationship between the "orders" table and the "Customers" table in the company's database system?

AOne-to-One BOne-to-Many CMany-to-One DMany-to-Many

Q13.

R1(Name, Class) = {(a1, 9), (b1, 5), (c1, 6), (d1, 11)} and R2(Name, Class) = {(b1, 5), (f1, 8)}. Which operation produces the output {(b1, 5)}?

AR1 R2 BR1-R2 CR 1-(R 1-R 2) DR1 U R2