Ch 01: Introduction to Databases

25 Questions25 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 11 โ€“ 20 of 25 Questions
Page 2 of 3
Q11
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 01.3. Importance of databasesMediumโญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Which of the following enterprise software functions is designed to provide operational data such as sales prospects, contact information, product details, product configurations, and sales quotes?
  1. A.Sales Force Automation (SFA)
  2. B.Customer Relationship Management (CRM)
  3. C.Enterprise Resource Planning (ERP)
  4. D.Management Information Systems (MIS)
Q12
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.2. Database Architecture and SchemasEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
A description of a particular collection of data using a given data model is called a database ________.
  1. A.Schema
  2. B.Database
  3. C.Relation
  4. D.Instance
Q13
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.1. Introduction to DatabasesEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Data about data is referred to as metadata.
  1. A.True
  2. B.False
Q14
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.3. Database Design ProcessEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
During the logical design phase of a database, internal storage structures, access paths, and file organization for database files are specified.
  1. A.True
  2. B.False
Q15
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.3. Database Design ProcessMedium๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Which of the following statements concerning the database design process is INCORRECT?
  1. A.During requirements collection and analysis phase, one can gather the data requirements of database users.
  2. B.By referring to a high-level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
  3. C.Transformation of the high-level data model into the implementation data model is called logical design or data model mapping.
  4. D.Physical database design is completely independent of the target Database Management System (DBMS) and hardware platform.
Q16
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.1. Introduction to DatabasesEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
Data about data is called a database.
  1. A.True
  2. B.False
  3. C.Partially True
  4. D.None of the Above
Q17
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.2. Database System ArchitectureEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
A ________ system architecture is used to establish and maintain connections between client users and the central database management system.
  1. A.client-server
  2. B.mail server
  3. C.file server
  4. D.none of the given
Q18
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.1. Introduction to DatabasesEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
A software package designed to define, store, manipulate, and manage databases is called a ________.
  1. A.DBMS (Database Management System)
  2. B.Database
  3. C.File System
  4. D.Operating System
Q19
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.2. Database System ArchitectureEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
A typical Database Management System (DBMS) utilizes an unlayered architecture.
  1. A.True
  2. B.False
Q20
โ“ MCQ๐Ÿ“˜ CS403๐Ÿ“‘ Lec 1๐Ÿท๏ธ 1.2. Database Architecture and SchemasEasy๐Ÿ”โญ๐Ÿ’ก๐Ÿ“„๐ŸŽ“VU๐Ÿ›๏ธVU
A technique or mechanism used to hide physical storage details and present users with a conceptual view of the database is called ________.
  1. A.Data Abstraction
  2. B.Data Concurrency
  3. C.Data Relationship
  4. D.Data Model