Which of the following is a primary feature of a distributed DBMS?

Spreads data across multiple sites

What is a key characteristic of the hierarchical data model?

Represents data in a tree-like structure

What is the purpose of data independence

To separate application programs from data storage details

What is a data model?

A set of concepts to describe data structure, operations and constraints

Which of the following is NOT an advantage of the network data model?

Allows for automated query optimization

What is the function of Data Manipulation Language (DML)?

Specifies database retrievals and updates

Which of the following describes an object-relational model?

A hybrid model combining object-oriented and relational features

What does a database schema describe?

The structure and constraints of a database

What does API stand for?

Application Programming Interface

What does OLTP stand for?

Online Transaction Processing Systems

What is the main function of a DBMS utility?

Perform maintenance tasks like backup and performance monitoring

What is a major function of a data dictionary?

Store metadata about the database schema and constraints

Which DBMS interface allows users to enter SQL queries interactively?

Stand-alone query language interface

Which of the following best describes the Three-Schema Architecture?

It provides program-data independence

Which of the following is a key advantage of SQL?

It provides a high level of abstraction

studbud

Database CH02

30 termsStudBud Administration1 play

Imported from external platform

Flashcards30 cardsFPractice quizPHost liveL

Questions 30

Answers

1
Which DBMS component is responsible for enforcing constraints and maintaining integrity?
Concurrency control manager
Query processor
Storage manager
Database engine
2
Which component of a DBMS is responsible for query optimization?
Transaction manager
Query processor
Data dictionary
Database schema
3
Which type of DBMS architecture includes both a database server and multiple clients?
Distributed DBMS
Single-user DBMS
Centralized DBMS
Two-tier Client-server
4
Which of the following is a primary feature of a distributed DBMS?
Does not allow concurrent access
Lacks query optimization capabilities
Uses a single database stored on one machine
Spreads data across multiple sites
5
What is a key characteristic of the hierarchical data model?
Represents data in a tree-like structure
Uses a tabular structure
Allows many-to-many relationships
Uses Object-Oriented principles
6
Which database language is typically used to define the conceptual schema?
SQLJ
ODBC
DDL
DML
7
What is the purpose of data independence
To remove the need for database security
To ensure permanent data deletion
To separate application programs from data storage details
To make the database state unchangeable
8
What is a data model?
A set of concepts to describe data structure, operations and constraints
A programming language for databases
A physical storage mechanism
A graphical presentation of data
9
Which of the following is NOT an advantage of the network data model?
Allows for automated query optimization
Can handle complex relationships
Uses record types and relationship types
Supports optimal navigation
10
Which type of DBMS is commonly used for Web applications?
Single-user DBMS
Three-tier Client-Server DBMS
Hierarchical DBMS
Network DBMS
11
What is the function of Data Manipulation Language (DML)?
Defines the structure of the database
Controls user access permissions
Specifies database retrievals and updates
Creates backup copies of the database
12
Which of the following is NOT a category of data models
Conceptual data models
Relational data models
Physical data models
Logical data models
13
What does ODBC stand for?
Online Database Connectivity
Open Database Control
Open Database Command
Open Database Connectivity
14
Which of the following describes an object-relational model?
A physical model for storage
A model only used in legacy systems
A hybrid model combining object-oriented and relational features
A purely relational model
15
Which level of the Three-Schema Architecture describes the physical storage structures?
Logical Schema
Internal Schema
External Schema
Conceptual Schema
16
Which type of database architecture is known for supporting multiple user views?
File-based System
Three-Schema Architecture
Hierarchical database
Flat file database
17
What does a database schema describe?
The physical location of data
The actual data stored in the database
The structure and constraints of a database
The memory allocations for the tables
18
What does API stand for?
Application Programming Interface
Advanced Programming Interface
Application Processing Interface
Automated Programming Interface
19
What does OLTP stand for?
Online Logical Transport Processing
Online Logical Transaction Processing
Online Transaction Processing Systems
Online Local Transaction Processing
20
What is the main function of a DBMS utility?
Improve user interface
Perform maintenance tasks like backup and performance monitoring
Define database structure
Execute application programs
21
What is an example of a DBMS utility?
DML parser
Backup and recovery tool
DDL compiler
Query processor
22
Which of the following DBMS types provides the highest level of data independence?
Network DBMS
Relational DBMS
File-based System
Hierarchical DBMS
23
What is a major function of a data dictionary?
Store the actual data in a database
Perform transaction processing
Execute database queries
Store metadata about the database schema and constraints
24
Which DBMS interface allows users to enter SQL queries interactively?
Mobile interface
Stand-alone query language interface
Natural language interface
Forms-based interface
25
What is an advantage of the relational model?
Requires extensive pointer management
Complex navigational queries
High level of data abstraction
Uses a hierarchical structure
26
Which of the following best describes the Three-Schema Architecture?
It provides program-data independence
It is explicitly used in all DBMS
It eliminates the needs for external schemas
It enforces data redundancy
27
What does DML stand for?
Data Management Logistic
Data Manipulation Language
Database Modeling Language
Data Management Language
28
What does JDBC stand for?
Java Database Commands
Java Database Connection
Java Database Connectivity
Java Database Configuration
29
Which of the following is a key advantage of SQL?
It is a procedural language
It is not used in modern database systems
It provides a high level of abstraction
It only supports hierarchical databases
30
What does DDL stand for?
Dynamic Data Language
Data Deployment Language
Data Determination Language
Data Definition Language

Database CH02 Flashcards | StudBud