Ch 02: Data and Information

24 Questions24 MCQs0 Short Questions0 Long Questions
๐ŸŽฏ Exam Practice Papers
SEMESTER PASS

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

๐Ÿ“˜ VU MID TERM EXAMLectures 1 to 22
โฑ๏ธ 60 Mins

Mid Term Examination

Covers syllabus of Lectures 1 to 22 with 30 high-yield MCQs in a timed exam environment.

๐Ÿ“30 MCQs
โฑ๏ธ60 Minutes
๐Ÿ“— VU FINAL TERM EXAMLectures 23 to 45
โฑ๏ธ 90 Mins

Final Term Examination

Comprehensive semester exam preparation with 45 MCQs covering Lectures 23 to 45 with complete course coverage.

๐Ÿ“45 MCQs
โฑ๏ธ90 Minutes
Showing 1 โ€“ 10 of 24 Questions
Page 1 of 3
Q1
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.2. Context Level DFDHardโญ๐Ÿ’ก๐ŸŒŸ๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Consider designing a Context-Level (Level-0) Data Flow Diagram (DFD) for a McDonald's Fast Food Ordering System. What is the correct representation of external entities, data flows, and central process within this system?
๐Ÿ’ป text Snippet
[Customer] --(OrderDetails/Payment)--> (0: McDonald's System) --(OrderSlip)--> [Kitchen]
  1. A.Central Process: 'McDonald's System'; External Entities: 'Customer' and 'Kitchen'; Data Flows: Customer sends OrderDetails to System, System sends OrderSlip to Kitchen, and Kitchen sends Food to Customer.
  2. B.Central Process: 'Customer'; External Entities: 'McDonald's System' and 'Kitchen'; Data Flows: System sends Payment to Customer, and Kitchen sends Receipt to System.
  3. C.Central Process: 'McDonald's System'; External Entities: 'Food', 'Payment', and 'Receipt'; Data Flows: Food flows to Payment, and Payment flows to Receipt.
  4. D.Central Process: 'Kitchen'; External Entities: 'Customer' and 'Manager'; Data Flows: Customer sends Order to Manager, and Manager sends Food to Kitchen.
Q2
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.4. Importance of DataHard๐Ÿ”โญ๐Ÿ’ก๐ŸŒŸ๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Which of the following statements is INCORRECT with respect to physical file systems?
  1. A.At the physical level, pointer or hashed address scheme may be employed to provide a certain degree of data independence at the user level.
  2. B.A logical record is concerned with efficient storage of information in the secondary storage devices.
  3. C.Some physical organisations use pointers to record blocks to locate records on disk.
  4. D.The efficiency of a file system depends on how efficiently operations such as retrieve, insert, update, delete may be performed on the information stored in the file.
Q3
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.6. Users of Database SystemsEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
True or False: The existence of functional departments in each business organization may vary depending on the nature of the industry and the nature of the products/services being offered.
  1. A.True
  2. B.False
Q4
๐Ÿ“ Short Q๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.4. Importance of DataMedium๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
What should be the basic objective of any business organization, and how do database and management information systems (MIS) support it?
Q5
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.2. Context Level DFDMedium๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Which of the following statements is strictly correct regarding a Data Flow Diagram (DFD)?
  1. A.A single DFD is sufficient to fully represent a complex system.
  2. B.The dataflow must be bidirectional.
  3. C.DFDs are created at increasing levels of detail (hierarchical decomposition).
  4. D.DFDs are used to represent the relationships among external entities.
Q6
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.6. Users of Database SystemsEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
True or False: A hierarchical organization is structured in such a way that every entity in the organization, except one, is subordinate to a single other entity.
  1. A.True
  2. B.False
Q7
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.2. Context Level DFDEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
In a Data Flow Diagram (DFD) modeling a system boundary, which of the following represents the single central process bubble in a Context-Level (Level-0) DFD?
๐Ÿ’ป text Snippet
[External_Entity] --(Data_Flow)--> (0: Central_System_Process) --> [Other_Entity]
  1. A.The database management server storage engine
  2. B.The entire system, modeled as a single high-level process bubble (Process 0)
  3. C.The external actors and terminators connected through data stores
  4. D.The detailed subprocesses showing file validation algorithms
Q8
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.4. Importance of DataMediumโญ๐Ÿ’ก๐ŸŒŸ๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
True or False: Automated digital databases are structurally less susceptible to mass destruction, unauthorized copying, and misuse than traditional paper record files.
  1. A.True
  2. B.False
Q9
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.6. Users of Database SystemsEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
True or False: Small organizations usually have complex management structures.
  1. A.True
  2. B.False
Q10
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 2๐Ÿท๏ธ 02.6. Users of Database SystemsMediumโญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Which type of computer software is specifically designed to facilitate and support semi-structured and unstructured decision-making processes within an organization?
  1. A.Enterprise Management System (EMS)
  2. B.Decision Support System (DSS)
  3. C.Management Information System (MIS)
  4. D.Database Management System (DBMS)