WorksheetsDatabase Systems Quiz
Total questions: 40
Worksheet time: 20mins
What is the purpose of controlling redundancy in a database?
b) To ensure data consistency
a) To increase storage space
c) To improve data security
d) To reduce data access time
What is a transaction in the context of a database?
b) An executing program or process involving database accesses
a) A database schema
c) A database constraint
d) A database query
What type of constraint ensures that every course record must have a unique value for Course number?
b) Key or uniqueness constraint
a) Referential integrity constraint
c) Domain constraint
d) Check constraint
What is the capacity to change the conceptual schema without affecting external schemas or application programs?
a) Logical data independence
b) Physical data independence
c) Data abstraction
d) Data manipulation
What are traditional database applications primarily composed of?
a) Textual and numeric data
b) Multimedia data
c) Social media posts
d) Video clips
Which of the following is an implication of using the database approach?
b) Reduced application development time
a) Increased redundancy
c) Decreased data availability
d) Limited scalability
What type of systems are designed to handle large volumes of data?
b) NOSQL systems
a) Traditional database systems
c) Hierarchical systems
d) Network systems
Which interface type presents the user with step-by-step options to formulate a request?
a) Menu-based interfaces
b) Mobile apps
c) Forms-based interfaces
d) Graphical user interfaces
What is the process of storing data in a database controlled by the DBMS called?
b) Construction
a) Definition
c) Manipulation
d) Sharing
What type of interfaces present the user with lists of options to formulate a request?
c) Menu-based interfaces
a) Forms-based interfaces
b) Graphical user interfaces
d) Natural language interfaces
How does an application program access the database?
b) By sending queries or requests to the DBMS
a) By directly interacting with the storage medium
c) By accessing the database catalog
d) By manipulating the data directly
Which of the following is an example of a multimedia database?
d) Image and video storage
a) Online shopping database
b) Geographic information system
c) Computerized library catalog
What type of interfaces present the user with access to their data through a mobile phone?
b) Mobile apps
a) Menu-based interfaces
c) Forms-based interfaces
d) Graphical user interfaces
Which interface type presents a visual representation of the database schema to the user?
b) Graphical user interfaces
a) Forms-based interfaces
c) Menu-based interfaces
d) Natural language interfaces
What type of independence allows changes to the internal schema without affecting the conceptual schema?
b) Physical data independence
a) Logical data independence
c) Data abstraction
d) Data manipulation
What type of interfaces are typically used by parametric users?
d) Parametric interfaces
a) Forms-based interfaces
b) Natural language interfaces
c) Menu-based interfaces
Which interface type involves accepting requests written in natural language?
c) Natural language interfaces
a) Forms-based interfaces
b) Graphical user interfaces
d) Menu-based interfaces
Which interface type is typically used by mobile users to access their data?
b) Mobile apps
a) Forms-based interfaces
c) Menu-based interfaces
d) Graphical user interfaces
What term refers to the suppression of details of data organization and storage?
b) Data abstraction
a) Data independence
c) Data manipulation
d) Data concurrency
What do interfaces for parametric users often involve?
c) Predefined sets of operations
a) Graphical representations
b) Natural language processing
d) Complex query languages
What type of DML retrieves and processes individual records or objects separately?
b) Low-level DML
a) High-level DML
c) Nonprocedural DML
d) Procedural DML
What language is typically used for standalone interactive queries?
a) Structured Query Language (SQL)
b) Data Definition Language (DDL)
c) Data Manipulation Language (DML)
d) View Definition Language (VDL)
What is the capacity to change the schema at one level of a database system without changing the schema at the next higher level called?
a) Data independence
b) Data abstraction
c) Data manipulation
d) Data concurrency
What type of independence allows changes to the conceptual schema without affecting external schemas or application programs?
a) Logical data independence
b) Physical data independence
c) Data abstraction
d) Data manipulation
What language is used to specify the internal schema of a database?
b) Data Definition Language (DDL)
a) Data Manipulation Language (DML)
c) View Definition Language (VDL)
d) Structured Query Language (SQL)
What technology emerged in the 1990s to facilitate electronic commerce on the Web?
d) XML for data interchange
a) Object-oriented databases
b) NOSQL databases
c) Relational databases
Which level of the ANSI architecture is closest to the way many users perceive data?
a) External level
b) Conceptual level
c) Internal level
d) Physical level
What language is used by the DBA to define both internal and conceptual schemas?
b) Data Definition Language (DDL)
a) Data Manipulation Language (DML)
c) Structured Query Language (SQL)
d) View Definition Language (VDL)
What technology emerged in the late 1970s and early 1980s to provide data abstraction and application flexibility?
c) Relational databases
a) Hierarchical databases
b) Network databases
d) Object-oriented databases
Which type of DML retrieves individual records or objects from the database and processes each separately?
b) Low-level DML
a) High-level DML
c) Nonprocedural DML
d) Procedural DML
What types of data models are typically used to describe the structure of a database?
d) Conceptual and physical data models
a) High-level and representational data models
b) Physical and representational data models
c) High-level and low-level data models
Which architecture provides a convenient tool for visualizing the schema levels in a database system?
c) Three-schema architecture
a) Two-schema architecture
b) Four-schema architecture
d) Single-schema architecture
What is the collection of concepts used to describe the structure of a database called?
b) Data model
a) Data abstraction
c) Data independence
d) Data schema
What language is used by the DBA to specify user views and their mappings to the conceptual schema?
c) View Definition Language (VDL)
a) Data Manipulation Language (DML)
b) Data Definition Language (DDL)
d) Structured Query Language (SQL)
Which property of transactions ensures that each transaction appears to execute in isolation from other transactions?
c) Isolation
a) Atomicity
b) Consistency
d) Durability
Which interface type allows users to fill out forms to insert new data or retrieve existing data?
a) Forms-based interfaces
b) Graphical user interfaces
c) Menu-based interfaces
d) Natural language interfaces
Which architecture clearly separates the users' external level, the database's conceptual level, and the internal storage level?
c) Three-schema architecture
a) Two-schema architecture
b) Four-schema architecture
d) Single-schema architecture
Which architecture separates the users' external level, the database's conceptual level, and the internal storage level?
c) Three-schema architecture
a) Two-schema architecture
b) Four-schema architecture
d) Single-schema architecture
What type of DML is set-oriented and can specify and retrieve many records in a single statement?
a) High-level DML
b) Low-level DML
c) Nonprocedural DML
d) Procedural DML
Which characteristic of the database approach ensures program-data independence?
b) Data abstraction
a) Data normalization
c) Data manipulation
d) Data concurrency
