A major disadvantage of the traditional File Processing Approach is the:
Anonymous Quiz
19%
Data Abstraction
8%
Controlled Access
19%
Data Sharing
54%
Program-Data Dependence
In the three-schema architecture, the schema that describes the entire database structure for the community of users is the:
Anonymous Quiz
13%
Storage Schema
21%
External Schema
54%
Conceptual Schema
13%
Internal Schema
The property of separating the data denoscription from the application programs is known as:
Anonymous Quiz
0%
Data Isolation
20%
Data Sharing
65%
Data Abstraction
15%
Data Integrity
Logical Data Independence refers to the ability to change the conceptual schema without altering the:
Anonymous Quiz
73%
External Views/Application Programs
14%
Internal Schema
5%
Physical Storage Files
9%
System Catalog
Which of the following is an essential advantage of the Database Approach over the File System Approach?
Anonymous Quiz
78%
Enforcement of Integrity Constraints
6%
Increased Storage Costs
11%
Higher System Complexity
6%
No Need for a DBA
Which DBMS role is typically responsible for authorizing access and granting privileges to users?
Anonymous Quiz
94%
Database Administrator (DBA)
0%
Application Programmer
6%
Sophisticated End User
0%
Systems Analyst
Which of the following is NOT a main characteristic of the Database Approach?
Anonymous Quiz
6%
Data Sharing
44%
Self-describing nature via a Catalog
6%
Support for multiple views
44%
High Program-Data Dependence
Which phase of the database system lifecycle involves defining data types, structures, and constraints?
Anonymous Quiz
21%
Manipulating a database
47%
Defining a database
0%
Sharing a database
32%
Constructing a database
The general levels of the three-schema architecture are:
Anonymous Quiz
5%
Storage, System, and User
68%
Internal, Conceptual, and External
11%
Logical, Physical, and Application
16%
Relational, Hierarchical, and Network
The primary goal of multi-user transaction processing systems is to ensure:
Anonymous Quiz
0%
Low availability
29%
Interleaved processing
71%
High availability and fast response time
0%
Sequential execution
Which schema in the three-schema architecture uses a Physical Data Model to describe storage details?
Anonymous Quiz
38%
Conceptual Schema
50%
Internal Schema
6%
External Schema
6%
Logical Schema
The term that describes the size or unit of a named data item (Record, Disk block, Attribute value) is:
Anonymous Quiz
13%
Dependency
13%
Granularity
60%
Concurrency
13%
Integrity
Which database user interacts with the DBMS through a Query Language (like SQL) rather than pre-written programs?
Anonymous Quiz
65%
Sophisticated End Users
18%
Parametric End Users
12%
Standalone Users
6%
Casual End Users
A group of concurrent SQL statements executed as a single logical unit of work is called a:
Anonymous Quiz
7%
Batch
13%
Program
73%
Transaction
7%
Procedure
Interleaved processing is used for:
Anonymous Quiz
14%
Multiuser DBMS
7%
Single-user DBMS
64%
Traditional file systems
14%
Stand-alone database
The concept that helps the DBMS enforce data quality rules is:
Anonymous Quiz
0%
Data Redundancy
57%
Integrity Constraints
14%
Data Isolation
29%
Program-Data Dependence
Which recent application type involves storing and querying large collections of images, video, and audio?
Anonymous Quiz
25%
Numeric and textual database
75%
Multimedia database
0%
Data Warehouse
0%
Mobile database
An attribute that can be divided into smaller, meaningful components (e.g., Address) is called a:
Anonymous Quiz
0%
Simple Attribute
33%
Multivalued Attribute
67%
Composite Attribute
0%
Derived Attribute
The relationship type in which the same entity type participates in different roles is called a:
Anonymous Quiz
32%
Binary Relationship
53%
Recursive Relationship
11%
Weak Relationship
5%
Ternary Relationship
Which notation is used to represent an Entity Type in an E-R diagram?
Anonymous Quiz
21%
Double Rectangle
53%
Rectangle
16%
Diamond
11%
Oval